database connectivity - Layer2 Business Data List Connector

Description: such as for Microsoft Office Excel, Access, SQL databases, ERP/CRM systems, and more. Enter your connection string- You don't need programming or additional tools to connect. No need to modify your external system. ... Connect SharePoint on-premises lists to 100+ external data sources. Layer2 Business Data List Connector solves many of the well-known issues that exist with SharePoint on-premises external data ... Data List Connector Features Close the gaps that still exist with SharePoint out-of-the-box external data integration- While Microsoft SharePoint Business Connectivity Services (BCS) some external data ...

Release Notes: Updates in 6.3.1 New: Additional link / help text for Layer2 Data Provider for SOAP Web Services added. Fix: Using an ODBC connection, too short DSN names cause a validation error ("Index ... into an error page. Improved impersonation handling enables the use of local SQL databases like Microsoft SQL Server or Oracle with integrated security enabled. Please note the documentation for configuration ... details. Adding events from connected calendars in Outlook now in correct time zone. ...

Release Notes: to load one or more of the requested types. Retrieve the LoaderExceptions property for more information." that prevented the connection-string validation while using the DynamicsCrmOnline ...

Release Notes: Activate an individual timer job for a single connection. Activate an individual timer job for a single connection. Issue in the BDLC Configuration List when migrating from earlier SP versions. ...

Release Notes: Updates in 7 Now supports SharePoint Server 2016. 100+ systems now can be connected to SharePoint. The internal SharePoint fields "Modified", "Modified By"," Created" ... and "Created By" are now supported. Bug Fix: If a workflow or an API call inserted a DateTime value into a BDLC connected list, the DateTime was handled as UTC instead of local time. ...

Release Notes: with the system or SharePoint service account for Modified by/Created By. Connections in SharePoint 2013 using ODBC need local administration permissions. All ODBC connections are running now under the given web ... application pool account, which needs to be given local admin permissions. Unspecified Error when validating Excel/Access OLEDB connection as normal user account. All OLEDB connections are running now under ...

Release Notes: Fixes OData connection error. Fixed error when using the Layer2 Data Provider for OData against an OData v4 service. Error message: "An invalid request URI was provided. The request URI must ...

Release Notes: 'Microsoft.SharePoint.Library.ISPRequest'. Now fixed. Event receivers are now correctly removed while deleting a BDLC connection directly in the BDLC Settings Dialog. Invalid or corrupted site collections caused the BDLC Timer Service ... Changes: The validation of the connection settings on save was removed to allow save of incomplete settings or settings that do not validate in dialog mode (but possibly for background update). The input ...

Release Notes: into the "unspecified error" anymore when connecting to Excel or Access via OleDB ACE Provider. Please note that the "Claims to Windows Token Service" has to be enabled for that at SharePoint. BDLC 2010 ...

Release Notes: source, if SharePoint list items are created, updated or deleted. In this way any SharePoint list, e.g. contacts, tasks, events, KPI-lists could be used as "front-end" to LOB data, e.g. databases ...