{"id":4207,"date":"2012-06-01T14:25:51","date_gmt":"2012-06-01T06:25:51","guid":{"rendered":"http:\/\/www.sharepointboost.com\/blog\/?p=4207"},"modified":"2023-07-31T11:39:52","modified_gmt":"2023-07-31T03:39:52","slug":"how-to-connect-data-between-external-data-and-sharepoint-lists","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/how-to-connect-data-between-external-data-and-sharepoint-lists\/","title":{"rendered":"How to Connect Data between External Data and SharePoint Lists"},"content":{"rendered":"

As a database administrator, I manage a table named “Employee_Info<\/strong>” in database1<\/strong> on our SQL Server. Meanwhile, my colleague Tom, a department manager, manages a SharePoint list named “brain-employee<\/strong>.” Now, we want to create a connection between the two different data sources and merge the data. Additionally, I want to customize the data connection profile to protect some sensitive data, like Salary<\/strong> for example. However, how do I do this?<\/p>\n

Luckily, I found a simple and useful tool called SharePoint Data Connector<\/strong>, which provides a secure and convenient way to transfer and manage business data between SharePoint lists and external data sources.<\/p>\n

Now, let’s see how it works<\/span><\/strong>:<\/p>\n

1. First of all, create a profile on the Settings Page.<\/p>\n

\"\"<\/a><\/p>\n

2. Then, specify the SharePoint list and the connection direction (List -> Data or vice versa).<\/p>\n

3. Connect the external data sources (I selected the list “brain-employee<\/strong>,” the direction – “From list to external data<\/strong>,” connect to SQL Server<\/strong> –database1 – <\/strong>“Employee_Info<\/strong>” table.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>4. Enter your conditions, including filter settings using SQL statements and column mapping (My SQL statements is —where Depart = ‘brain’<\/strong> to filter brain department data. Setting these values to columns, except that sensitive column data “Salary<\/strong>“).<\/p>\n

\"\"<\/p>\n

5. We have now completed our profile settings.<\/p>\n

6. Now, click the “Run Now<\/strong>” button to connect the data.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>7. If you don’t want to delete records that only exist in the target, set “Run Options” function, which provides three options: Enable ADD<\/strong>, Enable UPDATE<\/strong>, and Enable DELETE<\/strong>.<\/p>\n

8. I don’t want to delete any data, so I unchecked the Enable DELETE<\/strong> option.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>9. If you want to run the profile in the background, enable Background update<\/strong>.<\/p>\n

10. Specify an email address to send notification emails to for each error that occurs while background update is enabled.<\/p>\n

11. Additionally, logging can be enabled in the same field.<\/p>\n

\"\"<\/a><\/p>\n

This is easy, right?<\/p>\n

Although this is only the initial release of Data Connector <\/strong>version 1.0, it can support SQL Server, My SQL and Oracle databases very well. Look forward to the next build to be compatible with many more data sources!<\/p>\n","protected":false},"excerpt":{"rendered":"

As a database administrator, I manage a table named “Employee_Info” in database1 on our SQL Server. Meanwhile, my colleague Tom, a department manager, manages a SharePoint list named “brain-employee.” Now, we want to create a connection between the two different data sources and merge the data. Additionally, I want to customize the data connection profile […]<\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[347],"tags":[388,390,389],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4207"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=4207"}],"version-history":[{"count":13,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4207\/revisions"}],"predecessor-version":[{"id":9221,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4207\/revisions\/9221"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=4207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=4207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=4207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}