Databases overview
The integration server can manipulate business data that is stored in databases. If you have databases, you must configure them before you can access them from your message flow. Both ODBC and JDBC connections are supported, but some restrictions apply on some platforms, as described in the following paragraphs.
If you configure your message flows to access databases, you cannot access some of the data types that are supported by these databases. The supported data types are defined in Data types of values from external databases.
Other local and remote database managers might also be supported for your computer. For more information, see IBM® App Connect Enterprise system requirements.
Some ODBC drivers are supplied and installed with IBM App Connect Enterprise.
- Go to the Software Compatibility Reports website: https://www.ibm.com/software/reports/compatibility/clarity/softwareReqsForProduct.html.
- In the Full or partial product name field, type the name or part of the name of the product that you want to query; for example "App Connect."
- Click the Search icon next to the Full or partial product name field to populate the Search Results field.
- Select a product from the Search Results field; for example, IBM App Connect Enterprise.
- Select a version from the Version field; for example, 12.0.1.0.
- In the Operating system platforms section, select the checkbox for your platform; for example, Windows.
- In the Product components section, select the checkbox for All components.
- In the Capabilities section, select the checkbox for Databases.
- Click Submit to open the Detailed System Requirements page.
- Select the Supported Software tab to view the information about supported databases.
JDBC drivers are not supplied by IBM App Connect Enterprise; you must obtain these files from your database vendor.
- Go to the Software Compatibility Reports website: https://www.ibm.com/software/reports/compatibility/clarity/softwareReqsForProduct.html.
- In the Full or partial product name field, type the name or part of the name of the product that you want to query; for example "App Connect."
- Click the Search icon next to the Full or partial product name field to populate the Search Results field.
- Select a product from the Search Results field; for example, IBM App Connect Enterprise.
- Select a version from the Version field; for example, 12.0.1.0.
- In the Operating system platforms section, select the checkbox for your platform; for example, Windows.
- In the Product components section, select the checkbox for All components.
- In the Capabilities section, select the checkbox for JDBC Drivers.
- Click Submit to open the Detailed System Requirements page.
- Select the Supported Software tab to view the information about supported JDBC drivers.
You can make JDBC connections to a database from the IBM App Connect Enterprise Toolkit by using a Data Design Project. A Data Design Project can aid in your development and is a requirement if you want to use the Mapping node to map to or from a database. For more information, see Mapping database content.
The toolkit includes a simplified JDBC Providers template for a number of database types and versions. Because of its simplicity, it might not be able to connect to all databases that the runtime can. The pre-populated list of templates is there for your convenience but you might not want or need to use them. You must not rely on the list because the content can change without notice between releases of IBM App Connect Enterprise.
IBM does not support database connections through the toolkit, so you must resolve any connectivity problems. For more information about connections to databases, see Database connections.