topic Consildating Data from Multiple Data Sources in QlikView https://community.qlik.com/t5/QlikView/Consildating-Data-from-Multiple-Data-Sources/m-p/195982#M56247 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have the following senario</P><P></P><P>There 4 severs on our network, on each server there could be anything from 1 to 6 databases in each server.</P><P>I am trying to get data from all servers all databases and then consolidate them.</P><P>I have a master database where we keep a list of each server,database etc....</P><P>We have a very limited window period to extract the data from the live databases.</P><P>In order to speed up the process i think i need to have 4 separate jobs so we can hit the production servers all in one go and then build one qvd which merges all the data.</P><P>I am looking for a way to</P><P>In each of the 4 Extractors</P><P>We will know which extractor is for which server,</P><P>I then load the data from my master database, which provides me with a list of the databases on that corresponding server.</P><P>I need some advise and help to put together a script</P><P>which will allow me to loop through the list and get data from each of the databases...</P><P>Any help will be appreciated.</P><P>thanks</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 10 Sep 2010 08:15:42 GMT 2010-09-10T08:15:42Z Consildating Data from Multiple Data Sources https://community.qlik.com/t5/QlikView/Consildating-Data-from-Multiple-Data-Sources/m-p/195982#M56247 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have the following senario</P><P></P><P>There 4 severs on our network, on each server there could be anything from 1 to 6 databases in each server.</P><P>I am trying to get data from all servers all databases and then consolidate them.</P><P>I have a master database where we keep a list of each server,database etc....</P><P>We have a very limited window period to extract the data from the live databases.</P><P>In order to speed up the process i think i need to have 4 separate jobs so we can hit the production servers all in one go and then build one qvd which merges all the data.</P><P>I am looking for a way to</P><P>In each of the 4 Extractors</P><P>We will know which extractor is for which server,</P><P>I then load the data from my master database, which provides me with a list of the databases on that corresponding server.</P><P>I need some advise and help to put together a script</P><P>which will allow me to loop through the list and get data from each of the databases...</P><P>Any help will be appreciated.</P><P>thanks</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 10 Sep 2010 08:15:42 GMT https://community.qlik.com/t5/QlikView/Consildating-Data-from-Multiple-Data-Sources/m-p/195982#M56247 2010-09-10T08:15:42Z