# How to create Oracle Destination Connection in CData Sync - .NET Edition ?

**URL:** <https://community.cdata.com/t/how-to-create-oracle-destination-connection-in-cdata-sync-net-edition/447>\
**Category:** CData Sync\
**Tags:** discussion, oracle, cdata-sync, net, cdata-sync-destination\
**Created:** [October 10, 2023, 7:44am UTC](https://community.cdata.com/t/how-to-create-oracle-destination-connection-in-cdata-sync-net-edition/447 "2023-10-10T07:44:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nandini\_Bagga](https://avatars.discourse-cdn.com/v4/letter/n/e99b99/32.png) [@Nandini\_Bagga](https://community.cdata.com/u/Nandini_Bagga)\
**Post date:** [October 10, 2023, 7:44am UTC](https://community.cdata.com/t/how-to-create-oracle-destination-connection-in-cdata-sync-net-edition/447/1 "2023-10-10T07:44:26Z")

</div>

## 🎯 Purpose

Steps to create Oracle Destination Connection, which is the native Oracle Managed Data Access Client (Oracle.ManagedDataAccess.dll) in CData Sync .Net Edition.

**Step 1:** Download [ODP.NET](http://ODP.NET)\_Managed\_ODAC.zip from [64-bit Oracle Data Access Components (ODAC) for Windows](https://www.oracle.com/database/technologies/odac-downloads.html)

 ![6c0fa7c4-fcb0-4571-9ed6-2ff4143dcbc3.jpg](https://us1.discourse-cdn.com/cdata/original/1X/3809b6631f8062707eeba759c199f8f1c0f10f74.jpeg)

**Step 2:** Copy the Oracle.ManagedDataAccess.dll from D:\Downloads\ODP.NET\_Managed\_ODAC122cR1.zip\[odp.net](http://odp.net/)\managed\common

 ![511d67fd-8463-4328-a4e2-b476be26a189.png](https://us1.discourse-cdn.com/cdata/original/2X/8/87474c1dfb16753e47dbc62f7011334e4c41b4b1.png)

**Step 3:** Put it in www/bin folder

 ![f7b3caea-6374-4561-9776-c7d71a6f36aa.png](https://us1.discourse-cdn.com/cdata/original/1X/1d201e637e85592bf3bce49c19054c6552c63729.png)

**Step 4:** Add provider in web.config file

```xml
<remove invariant="Oracle.ManagedDataAccess.Client" /><add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>

```

 ![87235558-70a0-4302-9e71-f36b7a680a14.png](https://us1.discourse-cdn.com/cdata/original/1X/de26d5daeb0205c55035af19bb6a91d75f7691d5.png)

**Step 5:** Check the **Version** , **Culture** and **PublicKeyToken** to match your DLL’s.

### Steps to check **Version** , **Culture** and **PublicKeyToken** :

1. Open Visual Studio’s Developer Command Prompt

2. cd into www/bin directory

3. Use the **sn.exe** tool to extract the **public key token** : In the command prompt, run the following command:

4. Open www/bin directory in Visual Studio to open the Oracle.ManagedDataAccess.dll file.