Thread: Change the name of a function in the odbc-driver

we are using the Oracle Analytics Server to connect to a PostgreSql Database.

While this is generally working, the OAS sends some wrong function names.

(for example grouping_id instead of grouping).

We tried creating an "alias function", named grouping_id that would simply call grouping, but we failed as the number (and type) of arguments is just not predictable.

I then came up with the idea to change the method name in the ODBC Driver, like for some scalar functions. So far I have added another mapping in convert.c, recompiled the driver, but (of course ?) this is not working yet.

" {"GROUPING_ID",          "grouping"               },"

So my questions are:

Is this an approach that is worth following?

(Knowing Oracle support, a fix might be taking quite some time)

If yes, is there any advice you could give what else need to be changed?

If no - any other idea how to address this issue?

Any help or ideas will be very much appreciated.

many thanks

best regards

Karl