Note: It is recommended to use a data connection or an information link to retrieve your data rather than the data provider access described below, if possible.
To reach the Configure Data Source Connection dialog:
On the authoring bar, click Files and data .
In the Files and data flyout, click Other. and then click Load Data with ODBC, OLE DB, or ADO.NET data provider.
In the Open Database dialog, click to select the OracleClient Data Provider.
Click Configure....
Option |
Description |
Oracle
server name |
The net service name for the Oracle instance where your data are located. The net service name can be found either in the local tnsnames.ora file, on an Oracle Names server, or, it can depend on your configuration of the Oracle Native Naming Adapters for your system. |
Username |
The username you wish to use when logging into the Oracle server. |
Password |
The password for the specified username. |
Save
credentials in analysis |
Select this option to save your credentials (username and password) in the analysis file. Caution: When this is option is enabled, username and password are stored unencrypted in the analysis file. Anyone with access to the file can obtain the credentials. |