How and which component to use for taking SQL as i... - Qlik Community

Anonymous · ‎2019-03-21

Hi All,

I have a client requirement to populate the output of SQL into table.

Already they have a ERP system and reports are accessible from ERP which use the SQL.

The ORACLE SQL used in the ERP system has many sub quires and db function and packages.

To achieve the requirement of taking this kind of SQL as a input and populate the output what is the process and component to be used.

akumar2301 · ‎2019-03-21

ideally in tOracleRow , you can run any query which runs in Other Oracle client.

Just that Query should be coverted as Java String

e;g; SELECT LabelState FROM us_state

should be in double quoted before used in tOracleRow : "SELECT LabelState FROM us_state"

How and which component to use for taking SQL as input , process and load the result to a table