Connecting to an IBM Data Virtualization Manager (DVM) data source

You can connect to an IBM® Data Virtualization Manager (DVM) data source by using the JDBC connector.

1. Set up an SSL certificate. For information on setting up an SSL certificate, see File Connector SSL/TLS 1.2 Configuration.
2. Create an encrypted storepass password. If you use the storepass dsadm1, then you can encrypt the value by using the following command issued from the ASBNode/bin directory:

   [root@hydisfqawin01 bin]# pwd /opt/IBM/InformationServer/ASBNode/bin
   [root@hydisfqawin01 bin]# ./encrypt.sh dsadm1 
   {iisenc}iLYAuVxNz+czFJCU267ANg== 
    

3. Copy the encrypted value to the file authenticate.properties in /tmp with the following content:

   password={iisenc}iLYAuVxNz+czFJCU267ANg==
   

4. Copy /tmp/iis-ds-truststore_ssl.jks and /tmp/authenticate.properties to /opt/IBM/home/dsadm/DVM.
5. Download the JDBC driver by using the instructions in the Installing the JDBC driver topic. The supported version for use with InfoSphere® Information Analyzer is IBM Data Virtualization JDBC Driver 3.1.
6. Unzip the file to the /opt/IBM/home/dsadm/DVM directory.
7. Set up the Data Virtualization Manager JDBC driver by pasting the following content into the /opt/IBM/InformationServer/Server/DSEngine/isjdbc.config file:

   CLASSPATH=/opt/IBM/home/dsadm/DVM/dv-jdbc-3.1.201807261343
   /dv-jdbc-3.1.201807261343.jar:/opt/IBM/home/dsadm/DVM/dv-jdbc-3.1.201807261343
   /log4j-api-2.8.2.jar:/opt/IBM/home/dsadm/DVM/dv-jdbc-3.1.201807261343/log4j-core-2.8.2.jar
   CLASS_NAMES=com.ddtek.jdbc.shadow.ShadowDriver:com.rs.jdbc.dv.DvDriver.class 
   

   Your file names might have different versions. To verify your version, check the /opt/IBM/home/dsadm/DVM directory.
8. Optional: Open port 12050 by issuing the following command:

   sudo vi /etc/sysconfig/iptables 
   
   -A INPUT -i eth0 -p tcp --sport 12050 -m state --state NEW,ESTABLISHED -j ACCEPT
   -A INPUT -i eth1 -p tcp --sport 12050 -m state --state NEW,ESTABLISHED -j ACCEPT
   -A OUTPUT -o eth0 -p tcp --dport 12050 -m state --state NEW,ESTABLISHED -j ACCEPT
   -A OUTPUT -o eth1 -p tcp --dport 12050 -m state --state NEW,ESTABLISHED -j ACCEPT 
   
   sudo service itpables restart 

   Note: The -i option is input and -o is output. There is one entry for each Ethernet number (0 and 1) to allow (-i) and (-o).
   You should now be able to connect by navigating to the /etc/sysconfig folder and issuing the following command:

   [root@ sysconfig]# nc -v <<DVM_server_host_name>> 12050

   For example:

   [root@oran1 sysconfig]# nc -v zserveros.centers.ihost.com 12050
   Ncat: Version 6.40 ( http://nmap.org/ncat )
   Ncat: Connected to 129.33.196.89:12050