Qlik Replicate: Retrieve Zero Records from Avaloq Banking Suite (Oracle Database)

[DesmondWOO]

For the Oracle database that integrates with the Avaloq Banking Suite, Qlik Replicate retrieves zero records from the source table during full load (without a warning or error messages). This occurs because the following PL/SQL procedure must be executed to obtain the data:

exec k.session#.open_session();

No mechanism exists to instruct Qlik Replicate to execute the above procedure before sending the query statement to the database.

Resolution

On the Oracle Database, create a trigger that fires after logon and embeds the PL/SQL procedure within it. For example, 

CREATE OR REPLACE TRIGGER AFTER_LOGON_TRIGGER_REPLICATE
　 AFTER LOGON ON DATABASE WHEN (USER = 'QR_ACCOUNT')
　 BEGIN
　　 execute immediate 'call k.session#.open_session()';
　 COMMIT;
END;

Where QR_ACCOUNT is the account name used to access the Oracle database.

Environment

Qlik Replicate all versions