You can access user databases from Compute, Database, and Filter nodes, and use the data in the databases to update or create messages, or use the data in the message to update or create data in the databases.
If you want to query an external database, you must configure the node with the connection information for the database. This consists of an ODBC data source name. Ensure that the WebSphere Business Integration Message Broker or database administrator has created a suitable ODBC data source on the systems, on which the brokers to which the message flows are deployed, are running.
If you invoke the mqsisetdbparms command to set a user ID and password for a particular database, the broker uses these values to connect to the database. If you have not set values for the database, the broker uses the default database user ID and password that you supplied on the mqsicreatebroker command that created the individual broker, or that you modified on the mqsichangebroker command.
On z/OS systems, the broker uses the broker started-task ID to connect to the database.
Ensure that the WebSphere Business Integration Message Broker or database administrator has granted sufficient database privileges to this user to query the specified database tables. If not, the broker generates a runtime error when it attempts to process a message and connect to the database for the first time.