topic Query definition and data on different servers? in QlikView https://community.qlik.com/t5/QlikView/Query-definition-and-data-on-different-servers/m-p/918469#M318408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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?</P><P></P><P>Thanks</P><P></P><P>Longmatch</P></BODY></HTML> Tue, 28 Jul 2015 20:56:19 GMT baylor2016 2015-07-28T20:56:19Z Query definition and data on different servers? https://community.qlik.com/t5/QlikView/Query-definition-and-data-on-different-servers/m-p/918469#M318408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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?</P><P></P><P>Thanks</P><P></P><P>Longmatch</P></BODY></HTML> Tue, 28 Jul 2015 20:56:19 GMT https://community.qlik.com/t5/QlikView/Query-definition-and-data-on-different-servers/m-p/918469#M318408 baylor2016 2015-07-28T20:56:19Z Re: Query definition and data on different servers? https://community.qlik.com/t5/QlikView/Query-definition-and-data-on-different-servers/m-p/918470#M318409 <HTML><HEAD></HEAD><BODY><P>If I understand your request</P><P>I think you can load in qlik a query from a db (sql server)</P><P>and then load the data from another db (oracle) using that query</P><P>pseudo code</P><P></P><P><EM>connect to sql</EM></P><P><EM>load one query definition (first one) from sql to qlik</EM></P><P><EM>set a variable with the query</EM></P><P></P><P><EM>connect to oracle</EM></P><P><EM>load data from oracle using the query definition stored in the variable</EM></P><P></P><P><EM>connect to sql</EM></P><P><EM style="font-size: 13.3333330154419px;">load one query definition (second one) from sql to qlik</EM></P><P><EM>etc.........</EM></P><P></P><P></P><P>but</P><P>- you have no control on the associations between the tables you load from oracle in your qv db (as the user define the query)</P><P>- you have no charts, report, nothing to use to show the data you load from Oracle</P></BODY></HTML> Tue, 28 Jul 2015 22:14:06 GMT https://community.qlik.com/t5/QlikView/Query-definition-and-data-on-different-servers/m-p/918470#M318409 maxgro 2015-07-28T22:14:06Z