Connectivity overview

Data Service supports a broad range of data sources, including mainframe relational and non-relational databases, and distributed databases running on Linux, UNIX, and Windows platforms.

Data Service connectivity options for data consumers includes ANSI 92-SQL (JDBC).

Table 1. Partial list of supported data sources
Data support	Data source
Mainframe relational/non-relational databases and file structures	IBM® DB2 IBM® Information Management System (IMS/DB) Native VSAM files Sequential files Software AG Adabas
Mainframe applications and screens	IDMS IBM® Information Management System Software AG Natural
Distributed data stores running on Linux, UNIX, and Windows platforms	IBM® BigInsights Hadoop IBM® DB2 Apache Derby IBM® Informix Oracle Microsoft SQL Server

SQL connectivity

SQL connectivity provides ANSI 92-SQL access through mainframe data virtualization. You can use it to transform mainframe artifacts into a familiar, easy-to-use relational format. With industry standard ANSI 92-SQL access, IBM® z/OS® Mainframe Data Service for Apache Spark makes critical mainframe data readily available for analytic purposes.