Configuring IBM DB2

In order to connect to IBM DB2 tables through ACL Analytics server profiles, you need to configure DB2, AX Server (or AX Engine Node), and ACL Analytics to support the connection.

Database server

The following steps need to be completed by the DB2 database administrator:

  • 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 following steps need to be completed by the ACL Analytics Exchange administrator:

  • Install the DB2 runtime client.

  • Configure the connection to the DB2 database on each server where the DB2 runtime client is installed by completing the following steps using the DB2 command line. The first line in each step lists the syntax, and the second line provides an example.

    1. Catalog the node.

      catalog tcpip node <node_name> remote <hostname> server <port>
      catalog tcpip node kong remote kong.dev.acl.com server 50000

    2. Add the database to the node.

      catalog database <db_name> as <db_alias> at node <node_name>
      catalog database sample as kong at node kong

    3. Test the connection.

      connect to <db_alias> user <username> using <password>
      connect to kong user acldev using acldev

ACL Analytics

The following steps need to be completed by the end-user or the ACL Analytics Exchange administrator:

  • Ensure that a server profile is configured with the correct information to connect to AX Server. A server profile called “Analytics Exchange” (or “AuditExchange” for version 4.0.0), which has the setting configured to connect to AX Server, is automatically created when AX Client is installed. If AX Client is not installed on the computer, you must create the server profile manually.

  • Set up a new database profile using the following information:

    • Server Profile – The server profile used to connect to AX Server. By default, the server profile is “Analytics Exchange” (or “AuditExchange” for version 4.0.0).

    • Type – Select DB2.

    • User ID – Specify the user account to use to connect to the DB2 database.

    • Password – Specify the password to use to connect to the DB2 database. If you do not want to save the password with the database profile you can leave the field blank, but you will need to specify it each time you use the database profile.

    • Service Name – The DB2 database alias configured on AX Server.


(C) 2015 ACL Services Ltd. All Rights Reserved.