Here you can know the process of SharePoint Migration and Synchronization without the need of migrating SharePoint 2010 to 2013 as you will be able to do it with any version of SharePoint. No matter whether you want to conduct SharePoint 2010 to SharePoint 2013 migration, or you are after Oracle to SharePoint Migration and Synchronization, you should always seek a service provider who can make the task easy and secure.
To connect native SharePoint list like news, tasks, contacts, custom or events, with an Oracle database, query as an external data source, you need to follow these simple steps.
The first step is to install Oracle Data Provider for SharePoint. You might have to download Oracle Data Access Components for .NET (64-Bit) because it is vital for connecting from SharePoint, install and setup process. Here’s the download link-
The second step is to create a new list and enter all the necessary list settings. If you want to connect to Oracle, you should click on Connect to External Data Source. In case this link is unavailable, the Business Data List Connector won’t be installed on SharePoint or not activated in SharePoint Site Collection as a Site Collection feature.
The third step is to enter Oracle connection data which should be done as per the image posted below. Then you need to select Oracle Data Provider for .NET. In the case where it’s not on the list, you should install it and configure it like its noted above.
The next step is to enter the Oracle connection string for SharePoint. Some sample connection strings for Oracle databases are
With integrated security- Data Source=MyOracleDB;Integrated Security=yes;
If you go for this option, you need to take care of the double hop issue in integrated security. You should also note that the users and SharePoint timer service account need to have access to external data.
Via .NET Provider selected – Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no
Via OLEDB Provider
In order to open a connection to Oracle database with standard security, you need to use this –
“Provider= OraOLEDB.Oracle; Your_Oracle_Database; UserId=Your_Username; Password=Your_Password;”
“Provider=MSDAORA; Data Source=Your_Oracle_Database; UserId=Your_Username; Password=Your_Password;”
In order to open a trusted connection to Oracle database, you should use this connection string- “Provider= OraOLEDB.Oracle; DataSource=Your_Oracle_Database; OSAuthent=1;”
The next step is to enter your Oracle query to connect to SharePoint. To do that, you can use select statements and primary keys as usual with Oracle, for instance, select * from myTable.
Another step is to enter your Oracle table primary key(s) to update the SharePoint list safely. When primary keys are available, you can also use list alerts and workflows that start business actions in SharePoint when external Oracle data is changed in the database.
By now, you would be ready to create list structure automatically. You can now modify data types and column titles at any point in time.
Be sure to check mapping. You are also free to enable background update or optional write-back. Full CRUD will be provided. See the figure below for more.
A Potential Problem
If the specified DSN has an architecture mismatch between application and driver, it might be a problem.
This potential problem can be resolved by installing a 64-bit SharePoint to have access rather than a 32-bit client software.
For more about migrating SharePoint 2010 to 2013 and sharepoint migration tools