-2

I remember that SharePoint list can lookup to SQL table directly (load table content to SP list), but what is this?

  • 1
    External content type using Business Connectivity Services? – Christoffer Jun 19 '17 at 8:55
  • Please clarify the Question on what is needed? – John Zachariah Jun 19 '17 at 13:39
0

The only way is not to use a usual SharePoint List for looking up SQL data. You could use the app External List which can connect to a SQL Server view or table over Business Data Connectivity Service.

First of all enter Secure Store Service in Central Administration and add a credential with a user allowed to connect to the database. Remember the given name of the Secure Store Service object.

Then connect to SharePoint Central Administration with SharePoint Designer. Go to External Data and create a connection to the SQL table. You can choose the columns and filter values here. Please enter your Secure Store Object name when prompted.

After saving the changes to SharePoint you can find the connection in Business Data Connectivity Service in Central Administration.

Now switch to the site where you want to display the external data. Add an app for external list. Here you can select the Business Data Connectivity object. After a short loading time the external data will be displayed.

Having troubles? First attempt to troubleshoot should be the permissions.

0

The external list is a key building block solution on external data sources. This allows administrators to configure external sources to perform read, write, and delete operations from the SharePoint familiar list interface.

You can connect to 3 different data sources.

  1. .Net Type
  2. SQL Server
  3. WCF Service

Here are the key steps involved in the process.

  • Prepare the external data source
  • Configure SharePoint services and accounts
  • Configure Secure Store Services
  • Configure Business Data Connectivity Services
  • Create an external content type
  • Create an External List
  • Create a view of external list

Here is a link to an MSDN article which explains all the steps above.

Configure External Data Sources

0

You can use Business Connectivity Services. Check below article:

Overview of Business Connectivity Services in SharePoint Server.

  • 1
    Hi @Radityo Ardi Could you please provide more details in your answer to be helpful for future visitors! – Mohamed El-Qassas MVP Jun 19 '17 at 10:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.