Connectors

Oracle ADO.net Connection

The ADO.NET connector uses the ADO.NET interface to connect to data sources that support the standard ADO.NET protocol.

The ADO.NET drivers will need to be installed on the machine and this usually requires the .NET assemblies to be registered in the Global Assembly Cache (GAC). The Installed providers are listed based on the result of the .NET static function DbProviderFactories.GetFactoryClasses().

The ADO.NET connector supports schema browsing via the ADO.NET Schema Tables, Connection Library, Lookups, Lookup Functions, Incremental Lookup, Incremental Data Load and INSERT/UPDATE/DELETE target actions. Some of these features are subject to the driver implementation.

Follow the guide below to show you how you can connect to Oracle .

Microsoft Driver

Download NuGet Package

To get started you first need to download the ManagedAccess NuGet Package from here : https://www.nuget.org/packages/oracle.manageddataaccess/

Download NuGet Package

Extract the driver from the NuGet download

Once the package has downloaded you need to change the file type to .zip so then we can locate and extract the driver.

File Type Change

The driver can be found within the folder at the following path : \oracle.manageddataaccess.19.5.0.zip\lib\net40 . The file to be copied is Oracle.ManagedDataAccess.dll.

Copy this and add this to the programs file for Data Synchronisation Studio (C:\Program Files\Simego\Data Synchronisation Studio 3.0).

Driver Location

Connecting

Open the connection window by clicking onto "Connect Data Source" in the data source window.

Then go to SQL Database > ADO.NET.

Now select the ODP.Net, Managed Driver from the dropdown menu. This is the dll file that we copied into our program files earlier.

Select Driver

You can either enter in the connection details into the connection fields or you can paste/edit the connection string in the white text box.

Your connection string should look similar to : Data Source=ORACLE01/XEPDB1;User ID=HR;Password=hr;

You can find other sample connection string examples here.

Connect to Oracle

Once you have added all the details your connection requires click Connect & Create Library Connection to save the connection to the Connection Library.

A tree view window will then open where you need to select the table you wish to connect to, once you have located and selected your table click OK to connect.

Connect to Oracle Table

Devart Driver

Download Driver

You will need to download the Devart dotConnect for Oracle driver from the Devart website : https://www.devart.com/dotconnect/oracle/download.html.

We recommend using the paid Professional version with the ADO.net connector. Otherwise you will need to download and install the Oracle Client Software from the Oracle website alongside the dotConnect for Oracle Express edition in order for the connector to work.

When installing dotConnect for Oracle please ensure that it is installed to the GAC. Otherwise it will not appear in the dropdown list of the ADO.net connector.

Connect

Open the connection window by clicking onto Connect Data Source in the data source window.

Then go to SQL Database > ADO.NET, and choose the dotConnect for Oracle driver from the dropdown list.

Select Driver

You can either enter in the connection details into the connection fields or you can paste/edit the connection string in the white text box.

Your connection string should look similar to: User Id=HR;Password=hr;Server=ORACLE01;Direct=True;sid=XE;service name=XEPDB1

We have set direct mode to True for this connection. If you set this to False you will need to have the Oracle Client Software installed.

You can find other sample connection string examples here.

Connect to Oracle

Once you have added all the details your connection requires click Connect & Create Library Connection to save the connection to the Connection Library.

A tree view window will then open where you need to select the table you wish to connect to, once you have located and selected your table click OK to connect.

Connect to Oracle Table

OracleClient Data Provider

This connection requires the Oracle Client Software to be installed which can be downloaded from Oracle directly.

This is the same driver as the inbuilt Oracle Connector.

Connect

Open the connection window by clicking onto Connect Data Source in the data source window.

Then go to SQL Database > ADO.NET, and choose OracleClient Data Provider (System.Data.OracleClient) from the dropdown list.

Select Driver

You can either enter in the connection details into the connection fields or you can paste/edit the connection string in the white text box.

Your connection string should look similar to : Data Source=ORACLE01/XEPDB1;User ID=HR;Password=hr;

You can find other sample connection string examples here.

Connect to OracleClient

Once you have added all the details your connection requires click Connect & Create Library Connection to save the connection to the Connection Library.

A tree view window will then open where you need to select the table you wish to connect to, once you have located and selected your table click OK to connect.

Connect to Oracle Table