IBM integration bus v 10 ODBC connectivity for integration node
IBM INTEGRATION BUS required ODBC connectivity to remote database for integration node on Linux/Windows server. The connection is facilitated the ODBC driver that allows the INTERGRATION NODE the allows to connect to the database server directly.
Checklist for the configuration to enable ODBC connection on distribution systems.
1. Configure your odbc.ini and odbcinst.ini
2. Ensure the you source mqsiprofile
3. Database environment setup profile to be sourced on the application accessing them required for the database trying to connect database ex: DB2, ORACLE etc.,
4. To set the data source at INTEGRATION NODE
5. Run the command mqsicvp