Synchronise SharePoint List
This article describes how to Synchronise a SQL Server Table to a SharePoint list with Data Synchronisation Studio.
Overview
In this example we will Synchronise the Products table from the popular Northwind database to a List in SharePoint.
This example with use a table with a Schema as below.
CREATE TABLE [dbo].[Products] (
[ProductID] int IDENTITY(1, 1) NOT NULL,
[ProductName] nvarchar(40) NOT NULL,
[SupplierID] int NULL,
[CategoryID] int NULL,
[QuantityPerUnit] nvarchar(20) NULL,
[UnitPrice] money DEFAULT(0) NULL,
[UnitsInStock] smallint DEFAULT(0) NULL,
[UnitsOnOrder] smallint DEFAULT(0) NULL,
[ReorderLevel] smallint DEFAULT(0) NULL,
[Discontinued] bit DEFAULT(0) NOT NULL
)
GO
Step 1 - Connect to the SQL Database
Choose the Connect Data Source link in the Datasource A window to open the Data Source Connection Dialog.
-
Connect Data Source
-
Select the Products table on the Data Source
Step 2 - Create SharePoint List
Use the SharePoint List Wizard to Create a SharePoint List from the Schema loaded by Data Synchronisation Studio.
Start the Wizard
Step through the Wizard
-
Select SharePoint Server
-
Select SharePoint Site
-
Select List Name
Step 3 - Compare A->B and Synchronise
Run an initial compare to look for the new records that need to be added to SharePoint in this case we should see all records as the SharePoint list contains no records.
-
Compare Results
-
Start a Synchronisation
-
Product List in SharePoint Populated
Need Help?
We have a dedicated support team available to help you with your queries.
If you have a support enquiry please e-mail us at
support@simego.com.
If you have a sales enquiry please e-mail us at
sales@simego.com.