InterSystems Caché Integration with Office 365, SharePoint and 100+ more

 

InterSystems Caché is an advanced database management system and rapid application development environment which can be integrated and synchronized with 100+ widely used local and cloud-based IT-systems like SQL/ERP/CRM codelessly using the Layer2 Cloud Connector

 

To connect to InterSystems Caché data the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

 

Configuration Settings for Caché Integration

 

Fig.: Example connection configuration to connect to InterSystems  Caché data. 

InterSystems Caché Specific Configuration Settings

 

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 already installed.
  • You need the InterSystems Caché ODBC driver installed (64-bit or 32-bit version depending on architecture and installed Cloud Connector). This comes usually with the Caché implementation.
  • Follow the vendor instructions to setup and configure. See here for an example to setup an ODBC data source.
  • Use a System DSN (not User or File DSN) to setup your connection and to refer to in the connection string. Verify your setup directly in the ODBC Connection Manager, if supported.
  • You can use a connection string like this to connect:
    DSN=Trycache64samples
    Please find more details about ODBC options at www.connectionstrings.com.
  • You can make use of ODBC to query your data as supported by the data provider and source system. For any specification of query language supported see vendor documentation.
  • You can map your data fields to specific external source fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • Please enter an appropriate primary key (column with unique values), depending on query (see data preview for this).

Specific InterSystems Caché Data Integration Scenarios

 

​​​​Just some ideas what to connect next: 

 

 

Can't find what you are looking for? Take a look here or contact [email protected] for any help.

 

 

InterSystems Caché Data Integration - Known Issues and Workarounds

 

  • You can generally use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems please take care of the primary key.
  • No programming required to setup a connection. No need to open your local network for access from outside. No need to modify the connected systems.
  • For more detailed setting options please take a look at the Layer2 Cloud Connector User's Guide.

FIND RELATED SOLUTIONS HERE.

Learn more about similar solutions for data migration, backup, integration, and synchronization by vendor and topic.

Ready to go next steps?

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.