we're trying to get Denodo and Informatica PowerCenter to talk. We have a simple SELECT..FROM query which runs correctly in the VQL shell, but when run from PowerCenter, it fails with the following error: "Function 'current\_setting' with arity 1 not found". (Backslash added by me to escape the underscore.) Naturally, such function is completely unknown to us and our query does not reference it.
We're using Denodo Platform 6.0 and the ODBC PostgreSQL Wire Protocol driver.
Many thanks in advance for any advice pointing us in the right direction.