How to integrate InterSystems Cache in PostgreSQL

Discover how to integrate InterSystems Cache and PostgreSQL and instantly get access to your data.

WITH DATA VIRTUALITY PIPES
Replicate InterSystems Cache data into PostgreSQL and analyze it with your BI Tool.
How to integrate InterSystems Cache in PostgreSQL with Pipes


About InterSystems Cache

InterSystems Caché is a rapid application development environment and advanced database management system. It is a commercial operation Database Management System, used to develop software applications for financial services, banking, healthcare management, government, and other sectors. Caché allows developers to directly manipulate its hierarchical arrays known as M technology and underlying data structures.

About PostgreSQL

PostgreSQL is a powerful open-source object-relational database system. By supporting UNIX, Linux, BSD, AIX, SGI IRIX, HP-UX, Solaris, Mac OS X, Tru64, and Windows PostgreSQL runs on all major operating systems.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to InterSystems Cache, PostgreSQL and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.