The Business Layer2 Data List Connector for SharePoint (BDLC) can be used to connect SharePoint to 100+ external data sources, even to text / csv files via ODBC. This could be especially helpful in case your external system does not allow direct connections or you want to connect more complex query results. Please also note the option to connect via XML.​​​​​

How to connect LOB text / csv file data sources to native SharePoint lists via ODBC and BDLC

Sometimes a direct connection to any system is not available. In this case you can export text files and pull this data into a SharePoint list on a regular base, e.g. once a day. If a primary key is available in your text file, then changed data is updated only.

Here is our sample data source:

Sample Text File to integrate into SharePoint List

Fig.: Sample text file with a text column and some quantity at fixed positions.

First you have to configure your ODBC data source:
  1. Run ODBC Manager 64-Bit (or 32-Bit on a 32-Bit SharePoint)
  2. Run it as Administrator (otherwise no access to System DSN)
  3. Create new System DSN
  4. Add a new Data Source based on Microsoft Access Text Driver named “Textsample”
  5. Select Options, specify *.txt
  6. Disable “Use Current Directory”
  7. Select your Directory
  8. Define Format
  9. Select your Text File, e.g. myfile.txt
  10. Select Format Fixed Length
  11. Define your Columns by Name (min 4 letters), Data Type and Width
  12. Name one column Title to be the primary key later on (or use any other column for that)
  13. Close all Dialogs

ODBC Settings to integrate a text file into SharePoint list

Fig.: ODBC settings to define a text data source with fixed column length

Then you can access this data source in the BDLC Settings Dialog:

  1. Create a custom list and go to list settings
  2. Select “Connect to External Data Source”
  3. Select ODBC as Connection Provider
  4. Enter “DSN=Textsample” without “  as Connection String and validate
  5. Enter “select * from myfile.txt” without “ as select statement and validate
  6. Show preview of your first lines and check
  7. Correct ODBC configuration if required
  8. Enter primary key Title and Validate
  9. Add Columns
  10. Check Mapping – All fields should be mapped to columns
  11. Update – All items should be created
  12. Update again – There should be no changes if primary key works
  13. Enable Background updates if required (by default every hour)
  14. Close with OK

BDLC Settings to integrate a text file into SharePoint list

Fig.: BDLC Settings to connect a text data source seamlessly to a SharePoint list

And thats the result list:

  1. Display the result list
  2. Update list manually or in background
  3. write-back changes to data source (if supported by driver) 
  4. Create views
  5. Add additional columns and attachements if required
  6. Rename column titles if required
  7. Modify column types, e.g. text to numbers, long text etc. if required
  8. Create subscriptions per RSS or E-Mail if required
  9. Add business workflows on data change, if required
  10. Use search feature as usual
  11. Tag or auto-tag the content for use with Knowledge Management and  Social Networking
  12. ... Just do ALL what you can do with native SharePoint lists ;-) ...

 Text file as native SharePoint List

 Fig.: That's the resulting native SharePoint list - connected to a text file via BDLC

This sample is with SharePoint 2010. You can do the same with SharePoint 2007 or 2013 / 2016. The Business Data List Connector for SharePoint shareware you find here.

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

"The BDLC connects any external data source directly to SharePoint lists, even text files, e.g. exported by LOB host-based systems."


 Download & Evaluation

Please register now to receive your free personal download link via email to your valid company email address.
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited amount of list items. To order a license for the full version please click the shopping cart.

Business Data List Connector for
SharePoint 2007/2010/2013/2016
License List Price
Free Shareware Edition $0.00
1 Single Server
$1,065.00 Add to Shopping Card
1 Annual Software Assurance
$225.00 Add to Shopping Card
Prepaid Remote Support
1 Hour
$176.00 Zum Warenkorb hinzufügen


You can also order by phone or fax:

Order Service USA
(Language: English)

Share-it c/o Digital River, Inc.
10380 Bren Road West
Minnetonka, MN 55343, USA

Phone from outside the U.S.:
+1 952 646-5747
Phone from within the U.S.:
+1 800 903-4152

Fax: +1 952 646-4552
[email protected]


Order Service Europe
(Languages: German, English,
French, Italian, Spanish,

Share-it - Digital River GmbH
c/o Digital River Ireland Ltd.
Unit 153
Shannon Free Zone West
Shannon Co. Clare

Phone: +49 221 31088-20
Fax: +49 221 31088-29

More about how to buy see here. For more information about licensing please check FAQs or contact [email protected] directly.​

Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

SharePoint 2016 Data Integration

The Layer2 Business Data List Connector (BDLC) closes many gaps that still exists with Microsoft SharePoint 2016 out-of-the-box external data integration via Business Connectivity Services (BCS).

Layer2 Business Data List Connector V7 Released to Close Gaps with SharePoint External Data Integration

​Layer2 has announced version 7 of their top-rated Business Data List Connector (BDLC) that connects 100+ external data sources with SharePoint lists codeless and closes many gaps that still exist with out-of-the-box SharePoint external data integration.
Related Downloads
NoDoc Image

Business Data List Connector PAD File

This XML-based PAD file offers a product description for resellers to download and publish.
PDF Image

Customer Solution Case Study: WealthVest Marketing Benefits From SharePoint Data Integration Using Layer2 Business Data List Connector

"By using the Layer2 Business Data List Connector for SharePoint app we can provide native SharePoint lists as a simple, easy-to-use, and familiar interface to manage mission critical business data."
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

How to connect ANY external data source directly to native SharePoint lists?

Download this step-by-step introduction of the Layer2 Business Data List Connector (BDLC) for SharePoint on-premise.
PDF Image

How to integrate SAP data with SharePoint via NetWeaver & OData

You simply have to enter an URL to the data collection to integrate and sync SAP data with native SharePoint lists.
PDF Image

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (PDF) in English for download.
PDF Image

Testimonial: How the US Defense Contract Management Agency (DCMA) integrates SharePoint with Oracle using BDLC

"Layer2 Business Data List Connector (BDLC) software provides a powerful mechanism for surfacing external data through lists, and drastically improves platform stability and development cycles."
Related Links

Are you looking for partners in your region?

Please find a local partner here.

Layer2 BDLC for SharePoint Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join our group to share your experience.

Purchase Layer2 Business Data List Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.