Connecting to your Data Virtualization service instance
You can connect command-line interfaces, IBM® or third-party applications and tools, or apps that you create to your Data Virtualization instance.
Prerequisites
Before you try to connect to your Data Virtualization instance, verify the prerequisites.
- Step 1. Collect database details and credentials
-
To connect to your database, you need database details (such as the hostname), and credentials (such as a user ID and password.). You can collect this connection information from the Service credentials of the Data Virtualization service instance or from the Data Virtualization web console.
- Step 2. Verify that a supported driver is installed
-
-
If your application or tool already contains the Db2® v11.5 IBM Data Server Driver Package, your application or tool is able to connect to your Data Virtualization instance by using that driver.
-
Otherwise, install the Db2 driver package.
For more information, see the following resources:
-
- Step 3. Configure your environment
-
-
Add entries to the driver configuration file,
db2dsdriver.cfg
, for your database. -
Configure Secure Sockets Layer (SSL). Connection details, such as which port to use and the connection string, depend on whether you use SSL connections. SSL is the default connection method.
To use SSL connections, you need a CA certificate:
- If you use the most recent Data Virtualization driver package, the certificate file is bundled with the package and is used for connections.
- If you use the IBM Data Server Driver Package, you can download the SSL certificate from the Data Virtualization web console.
-
- Step 4. Confirm that ports are available
-
If your network is behind a firewall, confirm that communications are allowed on the port that is needed to connect to the Data Virtualization service. The port number can be found in the connection information from the Service credentials table of the Data Virtualization service instance or from the Data Virtualization web console.
Connectivity options
Data Virtualization offers multiple secure connectivity options that depend on your application connection requirements.
For more information, see Connectivity options in Data Virtualization.