InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  MySQL Community Connection with ODBC/JDBC ?

    Posted Thu June 11, 2020 10:53 AM
    Hi , 

    I need to archive data on MySQL Community Edition database , But I can not find out how to create a dbalias for it.
    Do you have any suggestions for me ? 

    PS: when i create a new dbalias there are only a few databases (at below) on the drill down list.
    • DB2
    • Hive
    • Informix
    • Netezza
    • Oracle
    • PostgreSQL
    • SQL Server
    • Sybase
    • Teradata


    Bests ,

    ------------------------------
    Gunes INAL
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: MySQL Community Connection with ODBC/JDBC ?

    Posted Thu June 11, 2020 10:57 AM
    Hello Gunes,

    You will have to use IBM Federation Server to mediate between Optim and MySQL Server database.

    It is similar to how you connect Optim with DB2 iSeries Database. 

    Thanks and regards,
    Vishwas Balakrishna
    Estuate, Inc. Princeton, NJ



    Original Message


Related Content