You can translate the question and the replies:

Function 'current_setting' with arity 1 not found...

Hi all, 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.
user
24-01-2017 08:43:59 -0500
code

1 Answer

Hi! That error seems related to the PostgreSQL driver issuing a function not supported by VDP. I would use the JDBC driver to connect to VDP as this is the recommend way to connect as it is faster than the ODBC. The following KB article explains how to configure a JDBC connection from BO to VDP: https://community.denodo.com/kb/view/document/How%20to%20access%20VDP%20from%20SAP%20BusinessObjects?category=Northbound+Connections In case you still want to connect using the ODBC connection, I think you should use the Denodo ODBC driver that is located in the installation path DENODO-HOME/tools/client-drivers/odbc.
Denodo Team
31-01-2017 22:12:53 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here