InfoSphere Optim

 View Only
Expand all | Collapse all

Optim TDM connectivity through JDBC

  • 1.  Optim TDM connectivity through JDBC

    Posted Fri February 05, 2021 06:19 PM
    Hi Team,

    I would like to know does IBM Optim (Extract, Convert, Load)solution support for databases that can be connected through JDBC.
    If it can be done, kindly let us know how to achieve that goal.

    Thanks in Advance,
    Anand K


    ------------------------------
    Anand Kolappa Pillai
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim TDM connectivity through JDBC

    Posted Sun February 07, 2021 04:45 AM
    Hi,

    If, i am getting it correctly by how does  JDBC connection works for Extraction, Archive and Masking you meant to ask following :

    -  JDBC String Connectivity Establishment, this is like any JDBC connection let it be mssql or mysql all you need to make sure to have the right jdbc jar.
    - Extraction,Arhive and Masking; Source Database (which will be yours Optim Default DB) will be the place where you will extract the desired database and archive, Even your data masking techniques either via Column Map Procedures or the LUA scripts will also be at the source Database.
    However, after performing the masking activity you can put the masked data at the desired Destination Database.

    For further, information you can refer to Optim Knowledge Center

    Thanks,
    Nabeel.

    ------------------------------
    Nabeel Ahmed
    ------------------------------

    Original Message