For version released prior to V3.0.2150 please see our old documentation.
The following page is our recommended connector to use when connecting to an Oracle Database. We recommend using the connector from our GitHub site to connect to your Oracle database.
To connect to Oracle you need to start by installing the Oracle connector from the Simego GitHub page. We have built a connector installer inside Data Sync that will download and install the relevant files for you.
To get to the installer go to File > Install Data Connector. This will open the Connector Installer Window, where all you need to do is select the connector you want to install from the drop down and click OK.
If you get an error saying it could not install the connector because it is "Unable to access folder", then this is because the folder is locked by Ouvvi. Please stop your Ouvvi services and try again.
If it was successful you should get a confirmation popup and you now need to close all instances of Data Sync and then re-start the program.
You can then access your Oracle connector under SQLDatabase > Oracle Managed Data Access. The numbers contained in the brackets are the driver version the connector is targeting. If you are after targeting a newer driver please contact us via firstname.lastname@example.org.
To use the connector you need to build out your connection string in order to connect to your Oracle Database.
You can either paste the connection string into the window at the bottom or you can build it out using the connection fields above.
Then click Connect & Create Library Connection to save the connection to the connection library. This means you can re-use the connection in future projects by going to the connection library window, then expanding the Database node and then your oracle connection so that you can select a table to connect to from your database.
It will first open a new window where you need to expand the tree to select a table to connect to, click OK once you have selected the table.
Then enter in a name for your connection and an optional description. Once it has been saved, you can refresh the connection library and under Databases you will now be able to see your Oracle database connection and expand it to select a table to connect to.
Some example connection strings you might have in order to connect can be seen below. For more guidance we recommend visiting ConnectionStrings.com.
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
For us this looks like:
data source=ORACLE01/XEPDB1;user id=username;password=myPassword
Data Source=myOracleDB;User Id=/;
For us this would look like:
data source=ORACLE01/XEPDB1;user id=/;
Data Source=TORCL;User Id=myUsername;Password=myPassword;
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Proxy User Id=pUserId;Proxy Password=pPassword;
For more details on how to connect please take a look at the ADO.net connector pages as this is what the connector is based upon.