Configuring IBM DB2 for direct access

To enable a direct connection to IBM DB2 tables through Analytics server profiles, you must configure the DB2 instance, AX Server or the AX Engine Node, and Analytics to support the connection.

Database server

The DB2 administrator must do the following:

  • grant the appropriate users or roles CONNECT authority to access the database
  • grant the appropriate users or roles SELECT privileges to the tables they are permitted to access

AX Server or AX Engine Node

The Analytics Exchange administrator must do the following:

  • install the DB2 run-time client
  • configure the connection to the DB2 database from the DB2 command line on each server where the DB2 runtime client is installed: 
# catalog the node - syntax:
catalog tcpip node <node_name> remote <hostname> server <port>
# catalog the node - example:
catalog tcpip node kong remote kong.dev.example.com server 50000
# add the database to the node - syntax:
catalog database <db_name> as <db_alias> at node <node_name>
# add the database to the node - example:
catalog database sample as kong at node kong
# test the connection - syntax:
connect to <db_alias> user <username> using <password>
# test the connection - example:
connect to kong user acldev using acldev

Analytics

The end user or Analytics Exchange administrator must:

  • configure a server profile with the correct information to connect to AX Server
  • set up a database profile

Server profile

When AX Client is installed, a server profile called Analytics Exchange is created and is configured to connect to AX Server. If AX Client is not installed, you must create the server profile manually.

Note

The server profile is called AuditExchange in version 4.0.

Database profile information

  • Server Profile the server profile used to connect to AX Server
  • Type DB2
  • User ID the user account used to connect to the database
  • Password the password used to connect to the database. To avoid saving the password in the profile and enter the password at each connection, leave this blank
  • Service Name the DB2 alias configured on AX Server