Citation

       "Please support us to improve our products and solutions. Give us your feedback."

Frank Daske, Business Development Manager, Layer 2 GmbH

Related Content

Related Downloads

pdf Image2009-11-01: Layer2 Press Release

SharePoint – New Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0
Layer2, the SharePoint Experts from Hamburg (Germany) announced a new Microsoft SharePoint extension to unlock the value of enterprise data for SharePoint 2007 based portals. The Business Data List Connector (BDLC) for SharePoint directly connects SharePoint lists with external LOB data sources. Almost any data from databases, Office or even text data can be displayed in SharePoint lists without any programming. Workflows can be used to start business actions in SharePoint, if external data records are changed.

xml ImageBusiness Data List Connector PAD File

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

pdf ImageFlyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

Related Links

Are you looking for Layer2 product resellers and implementation partners?

United States:

Great Britain, Scotland and Ireland:

France:

Netherlands:

Switzerland:​

Poland:

Turkey:

South Africa:

Malaysia:

Aptrio Download Store

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Main Content

How to connect a custom SharePoint list directly with an Oracle database table as external LOB data source?

You can connect a custom SharePoint list (no Web part) directly with external data from Oracle database tables or views using the

SharePoint Business Data List Connector (BDLC).

Oracle SharePoint Connection

You can set the connection string, the select statement and the primary keys (if any) in the SharePoint list settings dialog. Here are some sample connection strings for Oracle databases.

To open a connection to Oracle database with standard security use this one:

"Provider=MSDAORA; Data Source=Your_Oracle_Database; UserId=Your_Username; Password=Your_Password;"

Or

"Provider= OraOLEDB.Oracle; Your_Oracle_Database; UserId=Your_Username; Password=Your_Password;"

To open a trusted connection to Oracle database please use this connsction string:

"Provider= OraOLEDB.Oracle; DataSource=Your_Oracle_Database; OSAuthent=1;"

If using trusted connections, please make sure, that your SharePoint users and (in case of automatic updates) the timer process account has proper access to the database.

You can use select statements and primary key(s) as usual with Oracle.

If primary keys are available, you can use list alerts and workflows to start business actions in SharePoint, if external Oracle data is changed.