Connecting to Oracle

Oracle is a widely used relational database management system (RDBMS). Use Analytics's data connector to import your organization's Oracle data.

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 Import data using the Data Access window .