InfoSphere Optim

 View Only
Expand all | Collapse all

MySQL Community Connection with ODBC/JDBC ?

  • 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 ?

    IBM Champion
    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