I have never used a JDBC connection before, and I am only familiar with the ODBC connection. We have a vendor who will only support JDBC. They consider ODBC 'open source', and therefore do not support connection to their DB through the ODBC connection. Does anyone know that it is possible to make SSIS connections through JDBC? My initial research has not found any hits on this. No, SSIS does not have the required Java interface to do this for you ADOnate or OLDB Driver or ODB Provider.
You have to connect to the database.
You can write a Java program that extract data into a file, and then read data from that file you can execute a process from SSIS, which can be used to run Java programs .
Comments
Post a Comment