Connecting to Oracle

Concept Information

ACCESSDATA command

Oracle is a widely used relational database management system (RDBMS). You can use the Oracle data connector to import data from your company's on-premise Oracle database.

Note

The Oracle data connector does not support importing data from Oracle Cloud or Oracle Fusion data sources.

ACL for Windows provides Oracle as an optional connector and if it is not available in your Data Access window, it is likely that the connector was not selected during installation. For more information, see Install optional Analytics data connectors and Python engine.

Before you start

Oracle credentials

To connect to Oracle, you must gather the following:

  • your Oracle username and password
  • the host name or IP address and service name of the database
  • read access to the tables in the database

For help gathering the connection prerequisites, contact the Oracle administrator in your organization. If your administrator cannot help you, you or your administrator should contact Oracle Support.

Oracle Instant Client

The connector requires that Oracle Instant Client is installed on the same computer as Analytics. The bitness of the Instant Client must match your Operating System's bitness. If a 32-bit Oracle Instant Client is installed on a 64-bit machine, the connection fails.

Create an Oracle connection

  1. From the Analytics main menu, select Import > Database and application.
  2. From the New Connections tab, in the ACL Connectors section, select Oracle.

    Tip

    You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

  3. In the Data Connection Settings panel, enter the connection settings and at the bottom of the panel, click Save and Connect.

    You can accept the default Connection Name, or enter a new one.

The connection for Oracle is saved to the Existing Connections tab. In the future, you can reconnect to Oracle from the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Oracle, see Working with the Data Access window.

Connection settings

Basic settings

Setting Description Example
Server

The host name or IP of the server hosting the Oracle database.

 localhost
Port The port to connect to the server hosting the Oracle database. 1521
Service Name The service name of the Oracle database. XE
User The user Id for authentication with the Oracle database. SYSTEM
Password The password to authenticate the specified user with the Oracle database.  

Advanced settings

Setting Description Example
Browsable Schemas To provide comma-separated list of schemas to restrict browse-able database object tree. BrowsableSchemas=SYSTEM,SYS