Stonebond's
Enterprise Enabler for SharePoint Business Data List Connector comes with a rich-client easy to use interface to select, relate, transform and map ANY data source in the enterprise resulting in a simple virtual ADO.NET based record set. This record set can be connected to any existing SharePoint list, e.g. contacts, tasks or events using Stonebond's .NET Connectivity Driver as an additional provider for the Business Data List Connector. You simply have to enter connection string and select statement to connect your modeled record to any existing SharePoint list. All list features are available, e.g. notifications and workflows on data change and full write back (CRUD).
Fig.: Complex relationships between different data sources can be built without any coding by drag & drop in Enterprise Enabler for SharePoint Business Data List Connector.
Stonebond's
Enterprise Enabler for SharePoint Business Data List Connector adds the following features and benefits to the
SharePoint Business Data List Connector:
- Easy-to-use codeless drag-and-drop graphical user interface:
As a next-generation data analyst’s assistant, Enterprise Enabler has a rich-client easy-to-use graphical user interface that guides the analyst through data selection and building business rules, notifications, special run time error handling, and many other functions all in a drag-and-drop manner. The connector debugs architects and constructs the appropriate reusable integration components behind the scenes as the design is underway. Programming is unnecessary - but possibly without any limitations in C# and VB.NET. The same environment is used to test and deploy the connectivity. No staging system required.
- Connectivity to ANY system in the enterprise:
While Business Data List Connector comes with ODBC/OLEDB/.NET-based connectivity to widely used data sources out-of-the-box, Enterprise Enabler provides additional connectivity features to systems such as 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.
- Advanced mapping features and virtual relationships across multiple backend systems:
Relationships can be built between different data sources; data filtering and cleansing can be configured from within the client. Then, the metadata can be graphically mapped to or from other applications or data stores, providing semantic alignment of data across multiple applications. In other words, if you have data coming from a web service, some from a spreadsheet, and other data from a database, you can define relationships and mapping, as complex as needed, and the adapter will resolve them at run time when the data is transferred.
- Bi-directional data-integration:
Stone Bond’s Enterprise Enabler allows creating bi-directional data connections. That means you can optionally modify backend data directly using SharePoint lists, if required.
- Microsoft .Net Framework based re-usability:
Stone Bond’s Enterprise Enabler is built on the Microsoft .Net Framework and leverages all the features and enhancements of the Framework. In addition, EE supports the reuse of any libraries written in .net/com outside of the adapter, so that they become reusable components accessible through the standard adapter development environment.
Fig.: Complex data sets, e.g. across multiple backend systems, that are configured with Enterprise Enabler can easily be connected to SharePoint lists using the Business Data List Connector. Simply select ".NET Framework Data Provider for Enterprise Enabler" as Connection Provider followed by your connection string and select statement.
Enterprise Enabler for SharePoint Business Data List Connector as an add-on additionally requires SharePoint Business Data List Connector to directly connect data to SharePoint lists.
Enterprise Enabler for SharePoint Business Data List Connector is available for Microsoft Office SharePoint Server 2007 (MOSS, all editions) and also for the free Windows SharePoint Services 3.0 (WSS). Software versions for Microsoft SharePoint Server 2010 and Microsoft SharePoint Foundation 2010 are also currently available. Solutions based on Enterprise Enabler for SharePoint Business Data List Connector work in the same way with SharePoint 2007 and 2010 technology and are very simple to migrate. There is a free upgrade available for EE for BDLC from MOSS/WSS to SharePoint 2010 for all customers with Software Assurance (SA).