I have a requirement I need to create a list on load and its item dynamically based on SQL result

Hi,

Are you looking for something like this

Create external content types for SQL Server in SharePoint 2013

Hi,

We can create an External Content Type and a External List to achieve your requirement.

The following blogs for your reference:

How to Create an External List Including a Database from SharePoint Designer 2013

http://community.bamboosolutions.com/blogs/sharepoint-2013/archive/2013/01/07/how-to-create-external-list-including-database-from-sharepoint-designer-2013.aspx

SharePoint 2010 External Content Type to read data from SQL Server using SQL Authentication and Secure Store Service

http://blogs.msdn.com/b/mvpawardprogram/archive/2012/04/12/sharepoint-2010-external-content-type-to-read-data-from-sql-server-using-sql-authentication-and-secure-store-service.aspx

Best Regards,

Dennis

I need to read from oracle database but would like to maintain what ever is saved to sql server can we do it using external content type

actually from a timer job I am retrieving data from oracle and filling it in a sharepoint list

I need to read the data from this list having filter by user id and when I want to save add some additional columns and save it in SQL database

Hi,

If you are using Oracle Database, we can create a Linked Server in SQL server and create a view to get data from Oracle database, then use the external content type.

Or we can create BCS External Content Type using Visual Studio, here is a blog with the steps for your reference:

How to connect to the Oracle database using Business Connectivity Services (BCS) in SharePoint 2010

https://dotnetfinder.wordpress.com/2012/08/27/how-to-connect-to-the-oracle-database-using-business-connectivity-services-bcs-in-sharepoint-2010/

Best Regards,

Dennis