Installing Oracle client for Statistica
Article ID: KB0072278
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and higher |
Description
There are a couple of options to install Oracle client on a machine to access from Statistica. Install Oracle client that matches the bit-width of your Statistica installation (64 bit drivers for 64 bit Statistica and 32-bit Oracle for 32-bit Statistica). Note SDMS is a 32-bit application and it would need the 32-bit version of Oracle for the same.
Issue/Introduction
Oracle client needs to be installed to access data from Oracle into Statistica
Environment
Windows
Resolution
Option 1:
1. Download Oracle client from the Oracle site (either version 11g, 12c, 19 or 21 from https://edelivery.oracle.com/) and choose the Oracle database client for Windows.
2. Extract the contents of the zip file and choose the custom installation type (alternatively, you may choose Administrator to install the Oracle client fully, see option 2 )
3. Select the components : Oracle ODBC driver, Oracle objects for OLE, Oracle provider for OLEDB,Oracle Data Provider for .NET
4. In a database connection or while querying an oracle database or while installing Statistica to Oracle, Oracle OLEDB provided for Oracle should now be listed. Connect by specifying the hostname /Service name or specify the name of the connection in tnsnames.ora (if your Oracle DBA has provided one)
Option 2:
1. Install Oracle client for windows (10,11g or 12c) depending on the client compatible with your Oracle server version by choosing the Administrator option
2. This installation will include all configuration tools for connecting to the server. If your oracle provider has provided you with a tnsnames.ora then you may place the file in : [Oracle_HOME]\version\client_1\network\admin
3. Use the Oracle OLEDB provider for Oracle and connection information in tnsnames.ora or direct host name and service name as indicated in Option 1, Step 4
Option 3:
1. You may install the Oracle client (basic) or instant client.
2. Download and install Oracle Data Access Components (ODAC) for Windows to see the OLEDB provider for Oracle from Statistica.
3. Refer to Option 1, Step 4 for connecting to Oracle.
1. Download Oracle client from the Oracle site (either version 11g, 12c, 19 or 21 from https://edelivery.oracle.com/) and choose the Oracle database client for Windows.
2. Extract the contents of the zip file and choose the custom installation type (alternatively, you may choose Administrator to install the Oracle client fully, see option 2 )
3. Select the components : Oracle ODBC driver, Oracle objects for OLE, Oracle provider for OLEDB,Oracle Data Provider for .NET
4. In a database connection or while querying an oracle database or while installing Statistica to Oracle, Oracle OLEDB provided for Oracle should now be listed. Connect by specifying the hostname /Service name or specify the name of the connection in tnsnames.ora (if your Oracle DBA has provided one)
Option 2:
1. Install Oracle client for windows (10,11g or 12c) depending on the client compatible with your Oracle server version by choosing the Administrator option
2. This installation will include all configuration tools for connecting to the server. If your oracle provider has provided you with a tnsnames.ora then you may place the file in : [Oracle_HOME]\version\client_1\network\admin
3. Use the Oracle OLEDB provider for Oracle and connection information in tnsnames.ora or direct host name and service name as indicated in Option 1, Step 4
Option 3:
1. You may install the Oracle client (basic) or instant client.
2. Download and install Oracle Data Access Components (ODAC) for Windows to see the OLEDB provider for Oracle from Statistica.
3. Refer to Option 1, Step 4 for connecting to Oracle.
Additional Information
Feedback
Yes
No
Powered by
