The Data Service SQL solution

To enable ANSI SQL access to mainframe data sources, configure IBM® z/OS® Platform for Apache Spark (Data Service).

Data Service provides a high-speed conduit between Spark and z/OS data sources and a highly-optimized data flow by increasing data agility between Spark and z Systems mainframe environments. Data Service also enables Spark clusters to consume data from mainframe and non-mainframe data sources while supporting simultaneous threads from Spark on IBM z Systems, Spark on Linux on z Systems, and Spark on Linux.

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

Configuring a solution can include one or more of the following tasks:

• Configure the started task JCL by modifying the AZKS (subsystem default ID) member that is in the hlq.SAZKCNTL library.

• Configure the server member that is included in hlq.AZKS.SAZKEXEC(AZKSIN00).

• Make definition changes in the data provider interface.

Before configuring the SQL solution, the Data Service server installation must be successfully completed.

After configuring the SQL solution, access SQL data in real-time by selecting the JDBC driver from Programs on Spark, or on the Spark shell.

You can also use the Data Service Studio to get SQL access to your data.

For information about configuring the IBM® z/OS® Mainframe Data Service for Apache Spark SQL solution, see the following topics.