Optim - Test Data Management and Archiving

Expand all | Collapse all

Tools or software than xan be used to query archive file

  • 1.  Tools or software than xan be used to query archive file

    Posted Wed July 21, 2021 11:06 AM
    Hi,

    i'm currently working on a project using optim archive. Any tools that the users can use to access or query optim archive?
    they are currently using sap bobi, but there seems to be limitation using this.

    any other tools which can be used?
    would appreciate the help.

    thanks.

    ------------------------------
    Archibald Gaw
    ------------------------------


  • 2.  RE: Tools or software than xan be used to query archive file

    Posted Thu July 22, 2021 02:16 PM
    Hi Archibald - the tool to access and query the Optim Archive File (AF) is the Open Data Manager (ODM).

    Another option would be to use the Optim Archive product itself to query the Archive Files.
    I hope that this answers your question.

    Baha Majid
    Executive Technical Specialist - Thought Leader
    Financial Services Market - z Systems Analytics
     
    Mobile: 443-306-5039 
    E-mail: bmajid@us.ibm.com
     







  • 3.  RE: Tools or software than xan be used to query archive file

    Posted Mon July 26, 2021 01:00 PM

    Hi Archibald,

    As suggested by Baha, you can use ODM to connect to the exposed ODBC/JDBC or can use Optim Connect Studio query feature.

    To provide the access to clients who do not have access to Optim Infra, we use ODM + DB Visualizer (as query tool) as it supports ODBC connections.

    Regards,
    Rohit



    ------------------------------
    Rohit Jain
    ------------------------------



  • 4.  RE: Tools or software than xan be used to query archive file

    Posted Thu July 29, 2021 07:59 AM
    Thank you very much for the help.

    Sent from my iPhone




  • 5.  RE: Tools or software than xan be used to query archive file

    Posted Thu July 29, 2021 11:41 AM
    Hi Archibald,

    Use "Optim Connect Driver for ODBC 3.5 " and create ODBC connection on your local.
    You can access that ODBC connection on any Tools which accepts ODBC connection. I am using "Toad Data Point" Tool to access Archive files via ODBC.

    Let me know if you need more details.


    ------------------------------
    Harshavardhan Peddireddy
    ------------------------------