About this task
When you include a
DatabaseRetrieve,
DatabaseRoute,
JavaCompute,
Mapping, or Java™
user-defined node in a message flow, and interact with a database in that node, the
integration server must establish a connection with the database to fulfill the
operations that are performed by the node. You must define a JDBC Providers policy to provide the
integration server with the information that it needs to complete the
connection.
Important: When naming your JDBC Providers policy, consider the
following requirements:
- If you want to use your JDBC Providers policy with a JavaCompute node, or with a Java user-defined node, the name of your policy must match the
datasourceName parameter in the getJDBCType4Connection() API
call from the node.
- If you want to use your JDBC Providers policy with a Mapping node, the name of your policy must match the database
name that is used by the database transforms in your Graphical Data Map. For each database
transform, the database name is determined by the database definition (.dbm
file) in the Data Design project that was used to create the map.
- If you want to use your JDBC Providers policy with a DatabaseRetrieve node, or with a DatabaseRoute node, the name of your policy must match the value
of the Data source name property of the node.
A JDBC Providers policy supports connections to one database only; you must create a
policy for each database that your nodes or Java applications
connect to.
To set up a JDBC provider for type 4 connections, complete the following
steps.
What to do next
If required, set up security for the JDBC connection, set up the environment to include the
JDBC Providers policy in globally coordinated transactions, or both.