Query definition and data on different servers?

[baylor2016]

Hi,

I am planning to develop a dynamic Qlik reporting site which allows the user to define the query in a website and the query definition is stored in SQL server. However, the data to be queried is stored on Oracle server. Can this be done?

Thanks

Longmatch

[maxgro]

If I understand your request

I think you can load in qlik a query from a db (sql server)

and then load the data from another db (oracle) using that query

pseudo code

connect to sql

load one query definition (first one) from sql to qlik

set a variable with the query

connect to oracle

load data from oracle using the query definition stored in the variable

connect to sql

load one query definition (second one) from sql to qlik

etc.........

but

- you have no control on the associations between the tables you load from oracle in your qv db (as the user define the query)

- you have no charts, report, nothing to use to show the data you load from Oracle