InterSystems Caché is
an advanced database management system and rapid application development
environment which can be integrated and synchronized codeless with SharePoint
on-premises using the Layer2 Business Data List Connector. Please take a look here for more supported systems and applications. In case you are looking for Online data integration, you will find the right tool here.
Benefits of InterSystems Caché Integration in SharePoint
Very easy to setup in a few
minutes: Create a SharePoint list, click "Connect to external data
source" in the list settings, select the data provider, enter connection
settings and data query as shown below. That's it.
No changes or installation in Notes or Domino: No
programming, no changes in the external data source, no additional tools. Users
are working with current data in native SharePoint lists.
Connected data always up-to-date: The connected Notes or
Domino data updates automatically in background (via SharePoint Timer Job), or
alternatively, on-demand (Action Menu / Ribbon Button, URL, via workflow, API).
One-way and optional two-way connection: You can write-back
the changes made in SharePoint to the external Notes or Domino data source
automatically with full CRUD (Create / Update / Delete) functionality. The
SharePoint list can act as a full-featured front-end for external systems.
Well-known BCS "external list" issues and limitations are completely
solved: ALL list features are to you. Views, sorting and grouping,
filters, calculated fields, search, managed metadata. Lookups, additional
columns and attachments can be created as normal. All kind of lists can be used,
e.g. contacts, tasks, calendar, or custom lists. You can take external data
offline via Outlook.
Workflows and notifications on external data change: List
workflows and change notifications per RSS or email can be used to take business
actions in SharePoint, when external Notes or Domino data records are
Application logging, reporting, and notifications: A
SharePoint list is used to store settings and log information. SharePoint item
versioning and workflows can be used to manage reporting and notifications.
Direct notification per email in case of errors is supported as well.
Highest Security, best performance, easy to maintain:
SharePoint Secure Store can be used to store security relevant
configuration information safely in one central place. Users are
working with the SharePoint lists as an external data cache with highest
security and performance.
100+ external systems supported: Layer2 Data Providers
included (e.g. for SharePoint/Office 365, Exchange, Dynamics, OData, XML/RSS,
SOAP), vendor specific data providers can be used (e.g. SQL Server Oracle, mySQL
etc.), 3rd party data providers also supported, e.g. for ERP/CRMs, Facebook or
Twitter. See here for supported systems and
InterSystems Caché Specific SharePoint Configuration Settings
In the Layer2 Business Data List Connector the data source must be configured
as follows to connect:
Figure 1: Sample connection
configuration to connect to InterSystems Caché via Layer2
Please note the following specific settings.
Select the ODBC Data Provider to
connect. The provider is part of the Windows Operating System and should be
You need the InterSystems Caché ODBC driver installed (64-bit version). This
comes usually with the Caché implementation.