Supported data sources

The Data Virtualization Manager server supports a broad range of data sources, including mainframe relational/non-relational databases and file structures, mainframe applications and screens, distributed databases running on Linux, UNIX, and Windows platforms, cloud-based relational and non-relational data, and NoSQL databases. IBM Data Virtualization Manager for z/OS solutions have a wide range of connectivity options for data consumers, including ANSI-92 SQL and ANSI-99 SQL (JDBC/ODBC), NoSQL (JSON/BSON), Services (SOAP/REST) and HTML.

Data Virtualization Manager supports the data source types listed in the following table.
Table 1. Supported data source types
Data support Data source type
Mainframe relational/non-relational databases
  • IBM® Db2 for z/OS
  • IBM® Information Management System (IMS)
  • IBM® MQ
  • CA IDMS
  • Software AG Adabas
Mainframe file structures
  • Sequential files
  • Native VSAM files
  • z/OS File System (zFS)
  • Virtual Tape
Mainframe applications and screens
  • IBM® CICS®
  • VSAM via IBM® CICS® Transaction Server
  • IBM® InfoSphere™ Federation Server
  • IBM® Query Management Facility (QMF)
  • IBM® System Management Facility (SMF)
  • Software AG Natural
  • z/OS system logging (SYSLOG)
  • Log streams
Distributed data stores running on Linux, Unix, and Windows platforms
  • IBM® BigInsights Hadoop
  • Cloudera
  • Apache Hive over HDP
  • IBM® dashDB
  • IBM® Db2 Big SQL
  • Microsoft SQL Server
  • Oracle
  • Teradata*
  • Postgres
  • Greenplum
Non-mainframe IBM databases
  • IBM® Db2
  • IBM® Netezza
  • IBM® Integrated Analytics System
  • IBM® Informix
Platform
  • IBM Cloud Pak for Data
  • GridGain systems
Note:
  • *Data Virtualization Manager supports DECIMAL data type's precision up to 31 digits only for all the data sources including Teradata database.