To connect to an Oracle database using ODP.Net drivers, you need to have the appropriate Oracle driver installed. This article explains the steps needed to install the driver.
- If the ODP.Net driver is not already installed on the target machine, please follow the steps below to have it installed.
Note: Only 32 bit driver is supported at this time. 64 bit drivers are not supported. This applies even if the OS is 64 bit, in which case you still need to install the 32 bit driver.
- Visit the Oracle website www.oracle.com and navigate to the 32-bit Oracle Data Access Components (ODAC) downloads page.
Note: You may use the link below. This link is provided for your convenience. It is working as of the time of writing this article. However, please note that Oracle may change their website structure in the future.
- Accept the Terms and Conditions and select the ODTwithODAC121024.zip archive.
Note: This archive has the 12c version of ODAC, which has been verified to work with Centerprise. Optionally, you may download an earlier version of the driver, such as 11.2, which has been verified to work with Centerprise as well.
- Unpack the contents of the archive downloaded in the previous step, and run Setup.exe.
Important Note: It is strongly recommended that you run the Setup under an Administrator account. One of the ways to accomplish this is to right-click the executable and select Run as Admin.
- This opens the Oracle Universal Installer. Keep the default selections in Step 1 through Step 3. In Step 4, select to install Oracle Data Provider for .NET, as shown in the screenshot below.
- In Step 5 and Step 6, keep the default selections as shown in the screenshots below (if your environment requires setting up TNSNAMES.ORA file, you will need to set the values accordingly. Please contact your Oracle DBA for details).
- Finally, confirm the desired configuration as shown below, and click Install:
This installs the ODP.Net drivers.
It is recommended that you restart the OS after the installation is complete.
- To test ODP.Net connectivity in Centerprise, create a new dataflow and add a database source object. In the list of providers, select Oracle ODP.Net as shown below:
Enter the connection information for your target Oracle database, and click Test Connection… to verify that the connection is successful: