DataStage - Data Integration

 View Only
  • 1.  DataStage JDBC drivers

    Posted Wed December 15, 2021 01:42 PM
    In the "... \ ASBNode \ lib \ java" folder are the jdbc drivers for a large number of market databases.
    These drivers are for IIS internal use or can be used in DS jobs ? Personally I have tried using the SQL Server one, but without success. Microsoft's JDBC driver works fine, this in the folder mentioned not at all.

    Is it possible to use it ? Where can we find an example ?

    ------------------------------
    Jerzy Konarski
    ------------------------------


  • 2.  RE: DataStage JDBC drivers

    Posted Mon January 17, 2022 07:20 PM
    Edited by HOW MING YONG Tue January 18, 2022 01:11 AM
    Yes, you can use it and the example is stored in the isjdbc.config in ..\DSEngine\isjdbc.config

    Link to documentation - https://www.ibm.com/docs/en/iis/11.7?topic=SSZJPZ_11.7.0/com.ibm.swg.im.iis.conn.jdbc.usage.doc/topics/jdbc_config_driver.html

    This is from my demo env -
    [root@iis-server DSEngine]# ls -la is*
    -rw-rw-r-- 1 dsadm dstage 437 Apr 27 2019 ishdfs.config
    -rwxrwxr-x 1 dsadm dstage 385 Mar 22 2019 ishdfs.config.biginsights
    -rwxr-xr-x 1 dsadm dstage 690 Apr 29 2019 isjdbc.config
    -rwxrwxr-x 1 dsadm dstage 113 Mar 22 2019 isjdbc.config.biginsights
    -rwxrwxr-x 1 dsadm dstage 690 Mar 22 2019 isjdbc.config.default
    [root@iis-server DSEngine]# pwd
    /opt/IBM/InformationServer/Server/DSEngine
    [root@iis-server DSEngine]# cat isjdbc.config
    CLASSPATH=$DSHOME/../../ASBNode/lib/java/IShive.jar:$DSHOME/../../ASBNode/lib/java/ISmongodb.jar:$DSHOME/../../ASBNode/lib/java/ISsqlserver.jar:$DSHOME/../../ASBNode/lib/java/IScassandra.jar:$DSHOME/../../ASBNode/lib/java/ISpostgresql.jar:$DSHOME/../../ASBNode/lib/java/db2jcc.jar:$DSHOME/../../ASBNode/lib/java/ISoracle.jar:$DSHOME/../../ASBNode/lib/java/ISredshift.jar
    CLASS_NAMES=com.ibm.isf.jdbc.hive.HiveDriver;com.ibm.isf.jdbc.mongodb.MongoDBDriver;com.ibm.isf.jdbc.sqlserver.SQLServerDriver;com.ibm.isf.jdbc.cassandra.CassandraDriver;com.ibm.isf.jdbc.postgresql.PostgreSQLDriver;com.ibm.db2.jcc.DB2Driver;com.ibm.isf.jdbc.oracle.OracleDriver;com.ibm.isf.jdbc.redshift.RedshiftDriver


    ------------------------------
    HOW MING YONG
    ------------------------------