Configuring Oracle

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

Database server

The following steps need to be completed by your Oracle database administrator:

  • Configure network access to the database using HTTP by setting up a Listener and Local Net Service Name. These steps can be completed using the Oracle Net Configuration Assistant.

  • Grant the appropriate users or roles the CREATE SESSION privilege to access the database.

  • Grant the appropriate users or roles SELECT rights to the tables they are permitted to access.

AX Server or AX Engine Node

If your AX Server uses PostgreSQL as the database server, you will need to install and configure the Oracle Instant Client on each server that will access Oracle server tables. If your AX Server uses Oracle as the database server, the Oracle Instant Client is installed as a prerequisite, but some additional configuration is required.

You must complete the following configuration steps on each ACL Analytics Exchange server that will access Oracle database tables using the AX Connector:

  • Create a tnsnames.ora file with the settings required to connect to the Oracle database, or copy the tnsnames.ora from the Oracle database server and adjust the configuration settings as necessary. The file can be stored in the folder where the Oracle Instant Client is installed. The default location is C:\instantclient_11_1

  • Configure an environment variable called TNS_ADMIN that specifies the path where the tnsnames.ora, listener.ora, and sqlnet.ora files are located.

  • Ensure that the necessary rights are configured for the folder where tnsnames.ora is located.

ACL Analytics

  • Ensure that the “Analytics Exchange” (or “AuditExchange” for version 4.0.0) server profile is configured with the correct information to connect to AX Server.

  • Set up a new database profile using the following:

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

    • Type – Select Oracle.

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

    • Password – Specify the password to use to connect to the Oracle database.

    • Service Name – The net service name for the database service you want to connect to. The net service name is defined in the tnsnames.ora file on AX Server.


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