newodbcdev
Programmer
I need advice/direction on whether I need to develop a custom ODBC driver. I am currently working with an application that requires an ODBC driver to access a third party database (e.g. Oracle) for raw metrics. 80% of the time, additional calculations must be performed on the data before returning the data back to the application. Unfortuately, using the a standard ODBC driver for the database, requires me to write very complex SQL statements to handle the calculations. I try avoid placing any additional tables or stored procedures on the source database to handle the calculations.
I was wondering if it is possible to create a custom ODBC driver where I could control the backend processing of the metric? Or are there ODBC drivers where you can plug-in backend commands to further process the data? Any advice would be greatly appreciated!
I was wondering if it is possible to create a custom ODBC driver where I could control the backend processing of the metric? Or are there ODBC drivers where you can plug-in backend commands to further process the data? Any advice would be greatly appreciated!