# Setting Up Oracle ODP.Net Connectivity in Astera

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.

1. If the ODP.Net driver is not already installed on the target machine, follow the steps below to install the driver.
2. Visit the Oracle website *[www.oracle.com](http://www.oracle.com)* and navigate to the **3***2-bit/64-bit Oracle Data Access Components (ODAC)* downloads page.

{% hint style="info" %}
**Note**: You may use the links below. These links are provided for your convenience. They are working as of the time of writing this article. However, please note that Oracle may change their website structure in the future.
{% endhint %}

For installing the 32-bit driver, click [here](http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html).

For installing the 64-bit driver, click [here](https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html).

{% hint style="info" %}
**Note:** We have shown the steps to install the 32-bit driver in this article. The same steps will be followed to install a 64-bit driver.
{% endhint %}

* Accept the Terms and Conditions and select the *ODTwithODAC121024.zip*archive.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FIAS6ifxkGsNDENXD4ZK7%2F0.png?alt=media)

{% hint style="info" %}
**Note**: This archive has the 12c version of ODAC, which has been verified to work with Astera. Optionally, you may download an earlier version of the driver, such as 11.2, which has been verified to work with Astera as well.
{% endhint %}

* Unpack the contents of the archive downloaded in the previous step and run *Setup.exe.*

{% hint style="info" %}
**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*.
{% endhint %}

* 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.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FlFHovry9YK3U5l6ZeZVI%2F1.png?alt=media)

* 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).

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2Fu1FejtY312ZiDq4gfUG6%2F2.png?alt=media)

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FnT4kKFZlAjymXbkN0RKt%2F3.png?alt=media)

* Finally, confirm the desired configuration as shown below, and click *Install*:

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FHBAT2rb8k52LhEWtKMNh%2F4.png?alt=media)

This installs the ODP.Net drivers.

It is recommended that you restart the OS after the installation is complete.

3. 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:

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2Fn0kgrKCdPH2GcLhIf6NU%2F5.png?alt=media)

Enter the connection information for your target Oracle database, and click *Test Connection…* to verify that the connection is successful.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FDaqY8SiFvMdQEsuvjIyI%2F6.png?alt=media)