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.
Procedure
- Set up an SSL certificate. For information on setting up an SSL certificate, see File Connector SSL/TLS 1.2 Configuration.
-
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==
-
Copy the encrypted value to the file authenticate.properties in
/tmp with the following content:
password={iisenc}iLYAuVxNz+czFJCU267ANg==
- Copy /tmp/iis-ds-truststore_ssl.jks and /tmp/authenticate.properties to /opt/IBM/home/dsadm/DVM.
- 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.
- Unzip the file to the /opt/IBM/home/dsadm/DVM directory.
-
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. - 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:
For example:[root@ sysconfig]# nc -v <<DVM_server_host_name>> 12050
[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