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

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