Setting your environment to support access to databases

When you have configured your ODBC data source names (DSNs), you must also configure the environment so that you can issue console commands, and the integration node that you start can access the required database libraries. For example, if you have a DB2® database, you must add the Db2 client libraries to your library search path.

About this task

Windows platform

  1. On Windows platforms, the environment is typically set up for you when you install the database product, and no further action is required. However, some database managers provide a database profile that you must run to enable the connection from the integration node; for further information, see Running database setup scripts before starting an integration node.

Linux platformUNIX platform

  1. On Linux® and UNIX systems, run a profile for each database you want to access. For example, on Db2 you must run db2profile; other database vendors have similar profiles. For further information, see Running database setup scripts before starting an integration node.