chintan lakhavara · Mar 26, 2018

Integration with cache database

We have an application made in and want to make a integration for our client who is using cache database. So can any one suggest how to communicate with the database as we are new to this system.

3 0 6 437
Log in or sign up to continue


There are any number of ways to connect with the DB. ODBC, REST api, jdbc, nodejs,... It really comes down to your requirements.

Can we get any type of document for the implementation using the DB,ODBC,REST api

You can find online documentation here

If you need to make integration with the local instance you can connect directly to the database, using Caché eXTreme, or just ODBC

Add the reference to cache provider for .net

using InterSystems.Data.CacheClient;

CacheDataReader dr;

using (CacheConnection con = new CacheConnection())
             con.ConnectionString = "Server=" + Servername+ ";" + "Port=1972; Namespace=Namespace;" + "Password=" + Password + ";" + "User ID=" + UserName + ";";

             CacheCommand cmd;
             cmd = new CacheCommand("select * from table", con);
              dr = cmd.ExecuteReader();
             while (dr.Read()){ // do your stuff }