Oracle like queries for Greenplum
psqlODBC odbc drivers are currently available for use in OBI for accessing greenplum database for reporting. The down side is that the database in the physical layer needs to be changed to ODBC basic or ODBC Advanced and then the user created DSN mentioned in teh connection pool. This, however, does not support the analytical functions like RANK, PARTITION BY which are supported by Oracle DB. Greenplum also supports a few such functions, but cannot be shipped to the database from the OBI Server via its built-in query generation logic.
Is there a way to make the OBI server generate Oracle like queries for ODBC databases, in this case the greenplum database?