Itgenase294: The connection requires Invantive application authentication, but that is not supported

Questions (nl)
, , ,
1

When loading Supabase PostgreSQL via Invantive Credentials Server on Invantive Cloud, I receive the following error message:

09:13:27.193 itgenlom019: itgenase294: Could not connect to the database 'acme\acme-exact-online-acme'.
09:13:27.210 Error itgenase294: Could not connect to the database 'acme\acme-exact-online-acme'.
The connection requires Invantive application authentication, but that is not supported.
Switch to database authentication or use a different connector. Database authentication can be configured in your settings*.xml file.
09:13:27.215 Prompt itgencun002: Show details? Prompt? [y/N]

The settings*.xml is:

<?xml version="1.0" encoding="utf-8"?>
<settings version="5">
  <group name="acme">
    <connection name="acme-exact-online-acme" authentication="Application" >
      <credentials
       order="10"
        database="acme-exact-online-acme"
        datacontainers="*"
        userLogonCodeMode="Hidden"
        passwordMode="Hidden"
        defaultUserLogonCode="john.doe@acme.eu"
        defaultPassword="secret"
       />
    </connection>
  </group>
</settings>

The Exact Online connection is established, but PostgreSQL returns the error. Connection string:

Server=aws-0-eu-central-1.pooler.supabase.com;Port=5432;Database=postgres;SslMode=Require;Trust Server Certificate=true
2

This database connection uses “Application” authentication mode. This is a historical facility for use with Invantive Producer on Oracle RDBMS. However, in this case, the data containers are entered through the Invantive Credentials Server instead of through a direct definition, and then it is checked whether the database connection is addressed correctly.

An analyst will study the problem.

As a workaround, it is advised not to request specifically PostgreSQL through the Invantive Credentials Server. This can be done by specifying only the necessary data containers, as shown, for example, in:

...
    <connection 
     name="sample" 
     authentication="Database"
    >
      <!-- 
           Connect to Exact Online data container with token received via
           Invantive Credentials Server. 
      -->
      <credentials
       order="10"
       database="database-url-segment"
       datacontainers="eol"
       userLogonCodeMode="Hidden"
       passwordMode="Hidden"
       defaultUserLogonCode="john.doe.service.user@acme.eu"
       defaultPassword="secret"
      />
      <!-- 
           Connect to Supabase with local definition. 
      -->
      <database
       order="20"
       alias="pg"
       provider="PostgreSql"
       userLogonCodeMode="Hidden"
       passwordMode="Hidden"
       connectionString="Server=1.2.3.4;Port=12345;Database=getmyreport;User Id=user;Password=secret;Trust Server Certificate=true;SSL Mode=Require;Include Error Detail=true"
       AllowConnectionStringRewrite="false"
      />
    </connection>
...