Keep your Sharepoint in sync. Download and try today.
InterSystems Caché Integration with Office 365, SharePoint and 150+ more
InterSystems Caché is an advanced database management system and rapid application development environment which can be integrated and synchronized with 150+ 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:
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:
- You will find 150+ more systems to connect to InterSystems Caché here.
Can't find what you are looking for? Take a look here or contact sales@layer2solutions.com 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.
Ready to go next steps?