{"id":4293,"date":"2012-06-11T17:37:49","date_gmt":"2012-06-11T09:37:49","guid":{"rendered":"http:\/\/www.sharepointboost.com\/blog\/?p=4293"},"modified":"2023-07-31T11:39:51","modified_gmt":"2023-07-31T03:39:51","slug":"how-to-setup-a-business-data-transfer-from-an-external-database-to-sharepoint-in-five-minutes","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/how-to-setup-a-business-data-transfer-from-an-external-database-to-sharepoint-in-five-minutes\/","title":{"rendered":"How to Import Business Data from External Database to a SharePoint List in a Few Minutes"},"content":{"rendered":"<p>As SharePoint is being used in more and more organizations than ever before, it makes sense for it to be the place where you can access external data, see a KPI dashboard, reuse the data within SharePoint, or use SharePoint as the main interface to edit or add to your external data, etc.<\/p>\n<p>There is now a secure and convenient way to transfer and manage business data between SharePoint lists and external data sources. In this blog, I will show you the benefits and advantages of using this extremely simple method.<\/p>\n<p><span style=\"text-decoration: underline;\">Scenario<\/span>: Importing data from SQL server to a SharePoint list.<\/p>\n<p>Step 1. Add a profile.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC1.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4294\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC1.jpg\" alt=\"\" width=\"1238\" height=\"408\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC1.jpg 1238w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC1-300x98.jpg 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC1-1024x337.jpg 1024w\" sizes=\"(max-width: 1238px) 100vw, 1238px\" \/><\/a><\/p>\n<p><!--more-->Step 2. Name the profile, select a list and specify the direction.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC2.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4295\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC2.jpg\" alt=\"\" width=\"817\" height=\"79\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC2.jpg 817w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC2-300x29.jpg 300w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC3.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4296\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC3.jpg\" alt=\"\" width=\"805\" height=\"88\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC3.jpg 805w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC3-300x32.jpg 300w\" sizes=\"(max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>Step 3. Specify the external data you want to connect to.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC4.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4297\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC4.jpg\" alt=\"\" width=\"1038\" height=\"280\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC4.jpg 1038w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC4-300x80.jpg 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC4-1024x276.jpg 1024w\" sizes=\"(max-width: 1038px) 100vw, 1038px\" \/><\/a><\/p>\n<p>Step 4. Set filter Settings. You are allowed to enter a SQL Where Clause.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC5.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4298\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC5.jpg\" alt=\"\" width=\"1039\" height=\"218\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC5.jpg 1039w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC5-300x62.jpg 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC5-1024x214.jpg 1024w\" sizes=\"(max-width: 1039px) 100vw, 1039px\" \/><\/a><\/p>\n<p>Step 5. Build the mapping between database fields and list columns.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC6.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4299\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC6.jpg\" alt=\"\" width=\"1038\" height=\"260\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC6.jpg 1038w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC6-300x75.jpg 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC6-1024x256.jpg 1024w\" sizes=\"(max-width: 1038px) 100vw, 1038px\" \/><\/a><\/p>\n<p>Step 6. Select the operations you want to enable.<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC7.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4300\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC7.jpg\" alt=\"\" width=\"938\" height=\"133\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC7.jpg 938w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC7-300x42.jpg 300w\" sizes=\"(max-width: 938px) 100vw, 938px\" \/><\/a><\/p>\n<p>Step 7. Click &#8220;Run Now.&#8221;<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC8.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4301\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC8.jpg\" alt=\"\" width=\"827\" height=\"44\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC8.jpg 827w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC8-300x15.jpg 300w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<p>And we are done!<\/p>\n<p><a href=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC9.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4302\" src=\"http:\/\/www.BoostSolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC9.jpg\" alt=\"\" width=\"506\" height=\"367\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC9.jpg 506w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2012\/06\/How-to-Import-Business-Data-from-External-Databases-to-SharePoint-in-Five-Minutes-PIC9-300x217.jpg 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p>With this<strong><a href=\"http:\/\/www.BoostSolutions.com\/data-connector.html\" target=\"_blank\" rel=\"noopener noreferrer\"> out-of-box solution<\/a> for SharePoint,<\/strong> users can not only import business data from Microsoft SQL Servers, Oracle Databases and My SQL, but export SharePoint lists to these external data sources.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As SharePoint is being used in more and more organizations than ever before, it makes sense for it to be the place where you can access external data, see a KPI dashboard, reuse the data within SharePoint, or use SharePoint as the main interface to edit or add to your external data, etc. There is [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[347],"tags":[389,393,394],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4293"}],"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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=4293"}],"version-history":[{"count":8,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4293\/revisions"}],"predecessor-version":[{"id":9218,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4293\/revisions\/9218"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=4293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=4293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=4293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}