Setting Up Oracle ODP.Net Connectivity in Astera
Last updated
Last updated
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, follow the steps below to install the driver.
Visit the Oracle website www.oracle.com and navigate to the 32-bit/64-bit Oracle Data Access Components (ODAC) downloads page.
For installing the 32-bit driver, click .
For installing the 64-bit driver, click .
Accept the Terms and Conditions and select the ODTwithODAC121024.ziparchive.
Unpack the contents of the archive downloaded in the previous step and run Setup.exe.
This opens the Oracle Universal Installer. Keep the default selections in Step 1 through Step
In Step 4, select to install Oracle Data Provider for .NET, as shown in the screenshot below.
In Steps 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.