Requirements

Do you want to connect a custom SharePoint list directly with an Oracle database as external LOB data source?

Subnavigation

Logos

Citation

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

Frank Daske, Business Development Manager, Layer 2 GmbH

Related Content

News

SharePoint Codeless Bi-Directional List Connectivity Powered by Enterprise Enabler and Business Data List Connector

Stone Bond Technologies, provider of the world’s only codeless connectivity software and eco-system, today announced a strategic alliance with Layer2 a leading publisher of SharePoint Web Parts and solutions.

New Sharepoint 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 BDLC connects SharePoint lists directly with external data.

Enterprise Enabler for SharePoint Business Data List Connector

While the BDLC for SharePoint 2007 and 2010 connects any type of SharePoint list to external data sources via ODBC, OLEDB and .NET out-of-the-box, Stonebond's Enterprise Enabler for SharePoint Business Data List Connector provides advanced features.

SharePoint Business Data List Connector

The fast, easy and complete integration of external data, eg from databases, is a common requirement in the use of Microsoft SharePoint technology. The SharePoint Business Data List Connector offers this with full list features.

2009-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.

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

From SQL Server or Oracle tables and Excel files to web services, .NET objects, COM+ objects and ANY other data sources - connect it simply to any existing SharePoint 2007 / 2010 lists now.

Layer2 Flyer: Microsoft SharePoint 2010 Web Parts and Solutions

Related Links

Rate and discuss Layer2 SharePoint Web Parts and solutions on Microsoft Pinpoint

Pinpoint is a dynamic technology marketplace and the largest directory of qualified IT providers and their software built on Microsoft technologies. Microsoft Pinpoint helps business customers like you find experts, software applications, and professional services to meet your specific business needs and build on your technology investments.

You are looking for Layer2 product resellers and implementation partners?

V-WORK (Malaysia)
Corporate Power (USA, New York)
ITSD BV / IT Services & Development (NL)
PP Systems (North of England, Scotland and Ireland)
www.corus360.com (USA, Georgia)

Aptrio Download Store

Did you know? You can connect SharePoint lists directly to almost any external data source with BDLC to have a "SharePoint External List" today.

You can connect SharePoint lists directly to databases, such as:

SQL Server 2008
SQL Server 2005
SQL Server 2000 / 7.0
Oracle
IBM DB2
MySQL
Sybase Advantage Database Server
Sybase Adaptive Server Enterprise
Informix
Postgre SQL
IBM UniData
IBM UniVerse
AS/400 (IMB iSeries)
Progress
FireBird
Interbase
Paradox
Ingres
Mimer SQL
Lightbase
Pervasive
SQLBase (Gupta/Unify)
Cache
Teradata
VistaDB
DBMaker
Netezza DBMS
Valentina

and more. You can pull data to SharePoint lists directly from data files, e.g.

Microsoft Office Excel 2007
Microsoft Office Excel (other versions)
Microsoft Office Access 2007
Microsoft Office Access (other versions)
Visual Foxpro
DBF / Foxpro
SQLite
Filemaker
Textfiles (csv) with delimited columns or fixed length columns
HTML-tables

and more. You can also link SharePoint lists directly to server and services, e.g.

OLAP, Analysis Services - to provide Business Intelligence data in a real SharePoint list for further processing
Microsoft SharePoint - to pull list data from another SharePoint site collection or installation
Microsoft Project - to access project management data via a SharePoint list
Active Directory - to provide user or device data in a custom SharePoint list
Microsoft Exchange - to access contacts, events, tasks or other Exchange data
Microsoft Index Server - to access Index Server queries via a custom SharePoint list
IBM Lotus Notes - to connect a custom SharePoint list to Notes data
Intuit Quickbase - to access online application data
Composit Information Server - a Java-based application server
ODBC DSN - to connect further data sources via ODBC Data Source Names
UDL - to connect SharePoint lists via the Universal Data Link protocol with external data sources

You can use Enterprise Enabler for SharePoint BDLC to additionally connect SharePoint lists directly to

Web Services
XML
EDI
HL7
Virtual Store
Microsoft .Net Objects
COM+ Objects
MS Dynamics CRM
MS Dynamics AX
SAP
Salesforce
Journyx
Quickbooks
PeachTree
and other

Enterprise Enabler for SharePoint BDLC additionally automates complex bi-directional aggregation, transformation and manipulation of entities among multiple Line Of Business applications.

FREE Affiliate Registration for Layer 2 GmbH

Register as an affiliate with Layer 2 GmbH. As an affiliate, you can market the publisher's products by placing links on your Web site to the relevant product pages on the publisher's Web site. You will receive 20% commission for each sale of these products via your Web site.

How to integrate Microsoft CRM into SharePoint 2007/2010 lists in just 15 minutes?

The video shows step-by-step, how MS-CRM / SharePoint data integration can be done in just minutes with BDLC and Enterprise Enabler.

SharePoint BDLC has been awarded "5 stars" at x64bitdownload.com

SharePoint BDLC has been awarded with 5 stars at bestvistadownloads.com

SharePoint BDLC has been awarded with 5 stars at Kingdownloads.com

SharePoint BDLC has been awarded with 5 stars at SoftTester.com.

SharePoint BDLC has been awarded with 5 stars at www.download3k.com

SharePoint BDLC has been awarded with 5 stars at www.soft321.com

SharePoint BDLC has been awarded with 5 stars at www.softwarelode.com

SharePoint BDLC has been awarded with the Reviewers' Choice Winner in 2009

SharePoint BDLC is listed at ZDNet

SharePoint BDLC reviewed and rated 5 stars on SharePointReviews.com

"Uncountable possibilities to work with these lists further on ... just like an ordinary SPList (so, it IS an ordinary SPList)"
Reviewed by Brazzuk

SharePoint BDLC was awarded with EDITOR'S CHOICE at getabest.com

SharePoint Business Data List Connector is listed on www.brothersoft.com

Software choice at www.softforall.com:

Software Downloads at FileGuru

This solution is listed on Place77

This solution is listed on softpicks.net

This solution is rated 5 stars at www.4pcsoft.com

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).

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;"

"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.

Top Navigation