0 Replies Latest reply: Jul 30, 2014 12:15 PM by 2723156 RSS

    Oracle Data Integrator: recommendation for connection to Sybase IQ

    2723156

      Good day.

       

       

      I wonder which way is more advisable to connect to Sybase IQ from ODI, I used JDBC and ODBC Connection, but the volume of data I'm moving (approximately 50,000,000 records) extraction of these data in JDBC is very slow but ODBC is not it.

       

       

      I've talked with experts in Sybase and they have recommended me to make the connection to the database through OpenClient, however as this type of connection is not available in the options data servers ODI I can not use and that I would mean creating some java pluging for this connection.

       

       

      According to his experience with sybase which units they would recommend for this case, and if they have a case scheduled successfully, I might post an example of this case.

       

       

      Thank you for your attention.