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