Establishing an Oracle Connection String

Follow these steps to establish a connection string to an Oracle data source so you can connect TIBCO Spotfire Metrics to Analysis Services.

1. Download the 64-bit ODAC 11.2 Release 5 (11.2.0.3.20) Xcopy for Windows x64 (http://www.oracle.com/us/products/tools/index-090165.html).
2. Extract the downloaded zip file to the Downloads folder.
3. Follow the readme file instructions to install. Refer to the following bulleted list for further details.
   Note: Simply double-clicking the install.bat does not install Oracle.

   • From Windows, start a Command Prompt window, running as administrator, and browse to the directory where you have unzipped the archive.
   • Run the command, "install.bat all <PATH> odac" at the prompt.
   • Add <PATH> and <PATH>\bin to the Path environment variable
   • Provide your specific data source information for the Spotfire Metrics connection string (example format: Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wavdevoracle01.my.companyserver.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl.my.companyserver.com)));User Id=MyDBTest;Password=pass@word1;).
4. Running the query, Select ID,name from sample to test the connection.