Connecting to IBM Cloud SQL Query

Basic Tab shows how to authenticate to IBM Cloud SQL Query and configure any necessary connection properties. Additional adapter capabilities can be configured using the available Connection properties on the Advanced tab. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.

Deploying the IBM Cloud SQL Query Adapter

To deploy the adapter, you can execute the server_util utility via the command line by

1. Unzip the tdv.ibmcloudsqlquery.zip file to the location of your choice.
2. Open a command prompt window.
3. Navigate to the <TDV_install_dir>/bin
4. Enter the server_util command with the -deploy option:
   

   server_util -server <hostname> [-port <port>] -user <user> -password <password> -deploy -package <TDV_install_dir>/adapters/tdv.ibmcloudsqlquery/tdv.ibmcloudsqlquery.jar

Note: When deploying a build of an existing adapter, you will need to undeploy the existing adapter using the server_util command with the -undeploy option.

server_util -server <hostname> [-port <port>] -user <user> -password <password> -undeploy -version 1 -name IBMCloudSQLQuery