Connecting to Oracle (v.1)

This version of the Oracle data connector has been removed from Analytics 18.x.
Scripts that use this version of the Oracle connector will not run in Analytics 18.x and must be updated to use the new version of the connector.
This version of the connector will continue to work in Analytics 17.x, and earlier versions of Analytics, for as long as the connector and the data source remain compatible.
See Transitioning to a new ACL connector version

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.

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