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

guest2874
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
sharepoint business data catalog (bdc) vs. sharpoint bdlc PowerPoint Presentation
Download Presentation
sharepoint business data catalog (bdc) vs. sharpoint bdlc

play fullscreen
1 / 14
Download Presentation
sharepoint business data catalog (bdc) vs. sharpoint bdlc
701 Views
Download Presentation

sharepoint business data catalog (bdc) vs. sharpoint bdlc

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

  1. 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 | sales@layer2.de | www.layer2.de/en/

  2. 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/

  3. 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/

  4. 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/

  5. 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/

  6. 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/

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

  8. 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/

  9. 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/

  10. 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/

  11. 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/

  12. 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/

  13. 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/

  14. 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 sales@layer2.de 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/ | Sales@layer2de