Configuring the Oracle Database Connection

You can configure the native Oracle database name to connect to the Oracle database and retrieve the database details. You must provide the native Oracle database name to configure the connection information for the Oracle database.

Be sure that the Oracle native connectivity client is installed on the computer where the Intelligence Data Adapter service is configured. For more information, see the Oracle documentation.

To configure the Oracle Database connection

1. In the Data Adapter Type box, select Oracle Database.

2. In the Data Source Configuration section, do the following:

   

   1. In the Data Source time zone list, click the time zone of the database that the external data source system is referencing.

      The default time zone is the time zone of your computer. You can select the (UTC) Coordinated Universal Time option if the external data source system being referenced uses UTC for its time fields.

      You can click the Automatically adjust time for Daylight Savings check box if the time zone that you select is affected by daylight saving time (DST). For more information about time zone handling, see Time Zone for a Data Source.

   2. In the Data source name box, type the name of the Oracle data source server.

   3. In the User name box, type the user name for configuration.

   4. In the Password box, type the valid password.

3. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take few minutes to retrieve the schema from the data source. For more information about retrieving the schema, see Retrieve the schema.

4. Click Done and then click Save.