Oracle to SharePoint Integration and Synchronization
The Layer2 Business Data List Connector for SharePoint
solves many issues that still exist with the SharePoint out-of-the-box external
data integration with Oracle. It makes it as easy as possible
to connect native SharePoint lists to Oracle tables
and queries, codeless and bi-directional. All native SharePoint list
features are available for the connected lists, including search, change
notifications and workflows. Microsoft SharePoint 2019, 2016, 2013 (Server / Foundation) is
supported as well as SharePoint 2010.
You can connect a native SharePoint
list (e.g. contacts, news, tasks, events or custom) directly with an Oracle
database query as external data source with the following steps:
Install Oracle Data Provider for SharePoint:
Please find the Oracle Data Access Components for .NET (64-Bit) download that
is required to connect from SharePoint, install and setup:
a new list and enter list settings:
Please click "Connect to External Data Source" to connect to Oracle. If this
link is not available, the Business Data List Connector is not installed on
SharePoint or not activated in the current SharePoint Site Collection as a Site
Fig.: To connect to Oracle simply
enter list settings and click "Connect to external data source".
Enter Oracle connection
To connect your SharePoint list directly to Oracle enter the connection data
as shown below.
Fig: Enter connection data to connect the current list to Oracle.
Select the Oracle Connection
Provider "Oracle Data Provider for .NET":
If its not shown in the list, please install and configure as noted
Enter the Oracle Connection String for
Here are some sample connection strings for Oracle
via .NET Provider selected (preferred):
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated
Or with integrated security:
Data Source=MyOracleDB;Integrated Security=yes;
Please take care about the double hop issue in case of integrated security.
Also note that the users and the SharePoint
timer service account must have access to your external data in this case.
via OLEDB Provider selected (not preferred)
To open a connection to Oracle database with
standard security use this one:
"Provider= OraOLEDB.Oracle; Your_Oracle_Database; UserId=Your_Username;
To open a trusted connection to Oracle database please use this connsction
"Provider= OraOLEDB.Oracle; DataSource=Your_Oracle_Database;
Enter your Oracle query to connect to SharePoint:
You can use select statements and primary key(s) as usual with Oracle, e.g.
select * from myTable.
Enter your Oracle table primary key(s) to savely update the
If primary keys are available, you can use list alerts and workflows to start
business actions in SharePoint, when external Oracle data is changed in
Now you are ready to create the list structure automatically. You can modify
column titles and data types at any time. Please check mapping. You can also
enable background update or optionally write-back. Full CRUD (create, update,
delete) is provided.
Fig.: You can update your list on
demand using the ribbon button or URL. Alternatively you can update
automatically using the background update (via timer job).