Contents
With Microsoft SharePoint Designer 2010, you can connect to a variety of databases, including Microsoft SQL Server, Oracle, and other databases that are accessible by using the OLE DB protocol. By default, your Microsoft SharePoint site does not contain any database connections.
SharePoint to Oracle data conversion
- Use Oracle SQL Developer to copy the (“as-is”) data from SQL Server to Oracle.
- Create all the objects in the Oracle database schema.
- Run the scripts that will massage, transform and move the data.
- Rinse and repeat (Until testing and validations were successful).
How do I connect my SharePoint list to Oracle?
To connect to Oracle simply enter list settings and click “Connect to external data source”. 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.
Is the business data list connector installed on SharePoint?
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 Collection feature. Fig.:
How to connect to an Oracle database using business?
When you work with other databases such as Oracle, OLE DB, and ODBC, you must follow one of the following approaches, as these databases are not supported by Microsoft SharePoint Designer 2010: Create a Business Connectivity Services model from the beginning. For information, see Authoring BDC Models.
How to connect Oracle database to ASP.NET?
You can create a webpart in visual studio. Develop the webpart by Asp.Net in code. You can develop oracle database for CRUD operations the same as asp.net. Please remember to mark the replies as answers if they helped. You can use Business Data Connectivity Services to connect to external data.