What
Download
1 / 14

sharepoint business data catalog (bdc) vs. sharpoint bdlc - PowerPoint PPT Presentation


  • 669 Views
  • Uploaded on

The BDLC connects a real SharePoint list directly with almost any external LOB data using common list settings with 3 easy steps: 1. Enter connection string 2. Enter select statement 3. Enter primary keys. Fast background updates of changed data only: Alerts and workflows can be used, to take business actions, if external data records are changed. The feature comes with a robust installer and is available for WSS, MOSS and SharePoint 2010 with release.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'sharepoint business data catalog (bdc) vs. sharpoint bdlc' - guest2874


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

What is the SharePoint Business Data List Connector?

  • The SharePoint Business Data List Connector (BDLC) connects custom SharePoint lists (no Web Parts) directly with almost any external business data, simply in the list settings dialog with 3 steps only. All SharePoint list features are available as usual, e.g. alerts and workflows, to take business actions in SharePoint, if external data records are changed.

Fast batch update in background

(changed data only)

LOB

BDLC

External LOB data, e.g.- databases (e.g. SQL Server, Oracle)- office data (e.g. Excel, Access)- text files (e.g. csv) and more

Custom SharePoint List (No Web Part)

Layer 2 GmbH | Eiffestr. 664b | 20537 HamburgTel.: +49 40 28 41 12 30 | [email protected] | www.layer2.de/en/


Sharepoint bdlc why we made it
SharePoint BDLC – Whywemadeit?

  • Existing solutions such as the Business Data Catalog (BDC, MOSS 2007) or the Business Connectivity Services (BCS, SharePoint 2010) are not available for all SharePoint editions or for the Windows SharePoint Services (WSS). The BDLC works with all SharePoint editions and WSS.

  • BDC and BCS are not easy to configure. Tools, XML, customizing is required. The BDLC is easily configured in the list settings with 3 inputs only. Every admin can do it.

  • Existing solutions use Web Parts to display the data – not lists. That causes limitations compared to real SharePoint lists. With the BDLC all list features can be used, e.g. views, grouping, alerts, workflow. No problems with search at all.

  • SharePoint users are very familiar with lists. Lists are the common way to work with data in SharePoint.

  • With the BDLC list alerts and workflows can be used, to start business actions in SharePoint, if external data records are changed.

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc activation how does it work
SharePoint BDLC – Activation: How does it work?

  • Install the BDLC

  • Activate the BDLC Feature for the Site Collection

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc list creation how does it work
SharePoint BDLC List Creation – Howdoesitwork?

  • Goto Site Actions

  • Chose Create

  • Select Business Data List Connector in Custom Lists

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc list settings how does it work
SharePoint BDLC List Settings – Howdoesitwork?

  • Goto List Settings

  • Chose Business Data List Connector Settings in Custom Settings

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc list settings how does it work1
SharePoint BDLC List Settings – Howdoesitwork?

  • Enter the Connection String andvalidateit

  • Enter theselectstringandvalidateit

  • Enter theprimarykey(s)(ifany)

  • Create theliststructurewithoneclick

  • Update thedatawithoneclick

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc connection string how does it work
SharePoint BDLC Connection String – Howdoesitwork?

  • Connection stringsareavailableforvirtuallyanyexternaldatasources, e.g.

  • Databaseslike Microsoft SQL Server, Oracle, MySQL, Informix, DB2 etc.

  • Microsoft Office datalike Excel, Access etc.

  • Text datafiles.

  • Connection stringsareavailableforexternal SharePoint liststoo...

  • See FAQs to find yourconnectionstring

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc select statement how does it work
SharePoint BDLC Select Statement – Howdoesitwork?

  • Select statementsareavailableforvirtuallyanyexternaldatasources, e.g.

  • Databaseslike Microsoft SQL Server, Oracle, MySQL, Informix, DB2 etc.

  • Microsoft Office datalike Excel, Access etc.

  • Text datafiles.

  • Select Statements areavailableforexternal SharePoint liststoo...

  • See FAQs to find yourselectstatement

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc primary key s how does it work
SharePoint BDLC Primary Key(s) – Howdoesitwork?

  • In most cases your external data would have one or more primary key(s).

  • If a primary key is available, then the advanced update features can be used.

  • For more information about possible primary keys / field names please take a look into your result set using the Preview button.

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc list structure how does it work
SharePoint BDLC List Structure – Howdoesitwork?

  • To create the list structure required to display your external data, please press "Create”.

  • The fields of the result set of the given select statement are mapped to common SharePoint list fields automatically.

  • You can rename the fields afterwards manuallyor you can change field types as usual in SharePoint

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc data update how does it work
SharePoint BDLC Data Update – Howdoesitwork?

  • To update the data in your SharePoint list with your external data, please press "Update”.

  • If valid primary key(s) are given, modified data is updated only.

  • Updates can be done automatically in background (see next silde).

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


Sharepoint bdlc background update how does it work
SharePoint BDLC Background Update – Howdoesitwork?

  • You can optionally enable background updates.

  • The updates are done automatically, one time per hour by default.

  • You can modify this interval later on.

  • If primary key(s) are given, updates can be done very fast.

  • Modified data is transferred only with batch updates using a timer job

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


About Layer2

  • Layer2 is a specialist for creating custom components and solutions for Microsoft SharePoint Products and Technologies.

Hamburg

  • 1991: Formation as “Cords und Jacobi, EDV-Beratung und IT-Dienstleistungen” in Hamburg / Germany

  • 2001: Renamed to Layer2 GmbH

  • 2003: Focusing on Microsoft technologies, particularly .NET and SharePoint

  • 2007: Market entry Austria and Switzerland

  • 2008: Microsoft Certified Partner

  • 2009: Microsoft Gold Certified Partner

GERMANY

Nuremberg

Layer2 – The SharePoint Experts from Hamburg (Germany) – www.layer2.de/en/


What areyou waiting for?www.layer2.de

  • You can download an evaluation version of the SharePoint Business Data List Connector (BDLC) today at:

  • http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx

  • See FAQs or contact [email protected] for more information. Please note, that there are more SharePoint features and web parts available on www.layer2.de/en/.

Download

Layer 2 GmbH | Eiffestr. 664b | 20537 Hamburg | www.layer2.de/en/ | [email protected]


ad