November 9, 2017 at 10:02 am
I would like to know the best way to get data from a SQL view/Table into a SharePoint Online list .
November 9, 2017 at 10:28 am
I would like to INSERT/UPDATE and DELETE the list ( SharePoint Office 365)
November 9, 2017 at 11:01 am
PSB - Thursday, November 9, 2017 10:28 AMI would like to INSERT/UPDATE and DELETE the list ( SharePoint Office 365)
One option would be to use SharePoint Designer and create an external content type pointing the the SQL Server instance and table. The following blog has step by step instructions:
SharePoint List From SQL Server Table
Sue
November 9, 2017 at 12:09 pm
I am currently using access DB to do the work . But as it is a manual process , users are not very happy . Is there any solution where we can automate the process ? Can it be done using SSIS ?
November 9, 2017 at 12:53 pm
PSB - Thursday, November 9, 2017 12:09 PMI am currently using access DB to do the work . But as it is a manual process , users are not very happy . Is there any solution where we can automate the process ? Can it be done using SSIS ?
I don't know anything about using Access with Sharepoint. There is a SharePoint list adapter for SSIS you could try:
SharePoint List Source and Destination
You could also look at synchronizing the list and access table - I don't have the details have seen some discussions on using this before. I think there is a way to link the two somehow but I have no idea what functionality you have where.
In terms of automating, It depends on your environment, what resources are available and what is online vs on premise. You could run a job from SQL Server if you are using that. You could schedule something using a batch job and job scheduler.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply