Clinical.dk - Oracle Life Sciences

How to query study data in DMW from Visualisation tools like QlikSense or Oracle Analytics Clould (OAC)?

In order to read study data in DMW from visualisation tools like QlikSense or Oracle Analytics Cloud (OAC) you must first initialize read on Business Area (BA) in LSH database before you can issue a SELECT statement to query data in the business area. The problem is, that QlikSense and OAC only allows you to issue a SELECT statement, but not a procedure call, which is required to initialize read on BA via API procedure call in LSH database.

The problem can be resolved by use of a trigger solution, that automatically initialize read on selected BA’s after logon and connection to LSH database is established.

Please contact us if you would like to know more about this solution.

© Clinical.dk 2008 - All rights reserved