IBM Data Virtualization Manager for z/OS connection

To access your data in Data Virtualization Manager for z/OS, create a connection asset for it.

Data Virtualization Manager for z/OS is to access data in your z/OS® mainframe environment.

Supported versions

IBM Data Virtualization Manager for z/OS 1.1.0

Create a connection to Data Virtualization Manager for z/OS

To create the connection asset, you need these connection details:

• Hostname or IP address
• Port number
• Username and password
• SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Choose the method for creating a connection based on where you are in the platform

In a project Click Add to project > Connection. See Adding a connection to a project.

In a catalog Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In a deployment space Click Add to space > Connection. See Adding connections to a deployment space.

In the Platform assets catalog Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

• See Add data from a connection in a project.
• See Add data from a connection in a catalog.

Where you can use this connection

You can use Data Virtualization Manager for z/OS connections in the following workspaces and tools:

Analytics projects

• Data Refinery (Watson Studio or Watson Knowledge Catalog)
• DataStage (DataStage service)
• Metadata import (Watson Knowledge Catalog)
• SPSS Modeler (SPSS Modeler service)

Catalogs

• Platform assets catalog
• Other catalogs (Watson Knowledge Catalog)

Data Virtualization service You can connect to this data source from Data Virtualization.

Restriction

The Data Virtualization Manager for z/OS connection discovers virtual tables, virtual views, and COBOL copybooks in a system Z environment that map to underlying file structures, such as IMS, VSAM, Sequential files, and other mainframe sources. Watson Knowledge Catalog cannot create a virtual asset using this connection. Virtual assets can be created on Cloud Pak for Data using Data Virtualization to combine other non-Z data assets with those discovered by the Data Virtualization Manager for z/OS connection.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Data Virtualization Manager for z/OS documentation for the correct syntax.

Parent topic: Supported connections