Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
baylor2016
Creator
Creator

Query definition and data on different servers?

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

1 Reply
maxgro
MVP
MVP

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