The SharePoint Business Data List Connector offers a SharePoint External List connecting a real SharePoint list (no Web Part) to external business data using a very simple browser-based list settings dialogue. No additional tools are required. It can be configured easily with 3 simple settings only. The desired data can be populated to the list and presented without any restrictions, with the full read-only functionality of common SharePoint lists made available: views, sorting and grouping, filters, calculated fields, search, lookups can be created as usual.
- To connect to your data source please choose from the installed connection providers and enter the appropriate connection string (e.g. OLEDB, ODBC or custom) and validate it.
- To select the desired data, please enter a select statement that is supported by your external data source and validate it. Check the result in preview mode and select primary key(s), to make use of advanced features.
- Create the SharePoint list structure and update it using the command buttons with one click. If a primary key is available, only modified data is updated in the list with high performance (background batch update possible).