Details on Oracle Connection


This dialog is used to set up a connection to an Oracle database, where you can analyze data from the database without bringing it into your analysis. Note that the Oracle Data Access Component (ODAC) driver (Oracle Data Provider for .NET4 (ODP.NET4)) must be installed on the machine running the Oracle connector. See the system requirements at http://support.spotfire.com/sr.asp for details.

  1. Select Tools > Manage Data Connections.

  2. Click Add New > Data Connection and select Oracle.

  1. Select File > Add Data Tables....

  2. Click Add.

  3. Select Connection To > Oracle.

data_oracle_connection_d.png

Option

Description

Server

The name of the server where your data is located. To include a port number, add it directly after the server name preceded by colon.

Example with port number:
MyOracleDatabaseServer:1234

Connect using

 

   SID

Select this option to specify an Oracle System Identifier (SID) to use when connecting to the database. SID is used to uniquely identify a particular database on a system.

   Service name

Select this option to specify a service name to use when connecting to the database. The service name is the TNS alias that you give when you remotely connect to your database.

Authentication method

The authentication method to use when logging into the database. Choose from Windows authentication and Oracle authentication.

Windows authentication

When using Windows authentication, e.g., Kerberos, the access token of the currently logged in user will be used. Users that have been given the appropriate access rights to the Oracle database will be able to connect and read data.

Domain credentials are not stored in the analysis file.

Oracle authentication

With database authentication the authentication is done using a database user. Database credentials can be stored, unencrypted, as part of the analysis file, using a setting in the Data Source Settings dialog. If credentials are found in the analysis file they will be used to automatically authenticate against the database.

If no credentials or credentials profiles are found in the analysis file all who open the file will be prompted for database credentials.

Note that there will be no prompting for credentials if the credentials embedded in the analysis file fail.

Username

The username you wish to use when logging into the Oracle database.

Password

The password for the specified username.

See also:

Data Overview

Adding Data Connections to an Analysis

Oracle Data Types