IBM Security SOAR

Expand all | Collapse all

Using ODBC QUERY APP with Oracle DB

  • 1.  Using ODBC QUERY APP with Oracle DB

    Posted Tue February 16, 2021 11:13 AM
    I am wondering if anyone has setup the ODBC Query to work with Oracle DB. We have an Oracle DB that we pull user information from, and I see that it supports MariaDB, PostgreSQL and MySQL out of the box, but I am not sure what exactly I need to do to get it to work with Oracle. Anyone get this to work or know what needs to be done to get this to work. I am not a DB person so other than simple select, delete, and update commands I don't know much about getting these to work within the new app environment.

    Thanks!

    ------------------------------
    Nick Mumaw
    ------------------------------


  • 2.  RE: Using ODBC QUERY APP with Oracle DB

    Posted Tue March 09, 2021 04:12 PM
    Hello Nick,

    I sincerely apologize for the delay here. Hopefully I can help provide the information you need and/or set you in the right direction. You are correct that OracleDB is not supported out-of-the-box with the ODBC Query app. However, it is possible to configure. The ODBC query app depends on unixODBC and a corresponding driver for each supported flavor of database. If you wish to work with a database that is not initially supported, you will need to install the driver for that database and update the `sql_connection_string` value in your app.config file accordingly.

    This is a more straightforward process on an integration server than AppHost. It sounds like you are running AppHost, so in your case this would mean a change to the application image (container) to install and configure additional ODBC drivers in order to successfully use them in your connection string.

    Sorry for the long-winded answer, but hopefully that at least gives you a better idea of what you would need to configure to get Oracle running. You are welcome to submit an RFE to the team regarding this as well.

    unixODBC documentation: http://www.unixodbc.org/

    ------------------------------
    Brian Reid
    ------------------------------