topic Re: Connections to different databases? in QlikView https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315984#M408595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>something seems to not be right - I now have both SQL_SELECTs (from two different databases) on one sheet - but both have the same structure, so the LOAD statement is the same - when I load from the second database, the plant_key is that of the first one, so I'm not sure that works as expected ... when I deactivate the first half of the code and load only the table from the second database, it is correct.</P><P>Is there some statement I can use to close the connection after use so there can be no "misunderstanding"?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 10 Jul 2017 06:46:13 GMT datanibbler 2017-07-10T06:46:13Z Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315979#M408590 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I now have a rather big app to fetch from the database all the packing_plans which were valid for any given month in the past.</P><P>The issue is, we have two different database systems - one for this plant here and one for the other plant. There is an ODBC connection in every one of those apps. So I need three apps: One to get the data from this system, one to get the data from the other system and one to combine the two into one monthly file.</P><P>Is there any possibility to do all that in one app? That would be much more practical.</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 03 Jul 2017 12:47:28 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315979#M408590 datanibbler 2017-07-03T12:47:28Z Re: Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315980#M408591 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No problem. In the script, you need to establish a link with each of your databases and load data from them into QlikView, taking into account the correct organization of the data structure and field names.</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Mon, 03 Jul 2017 12:51:53 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315980#M408591 ahaahaaha 2017-07-03T12:51:53Z Re: Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315981#M408592 <HTML><HEAD></HEAD><BODY><P>Hi Andrey,</P><P></P><P>in every one of the apps I have an ODBC connect_string - so I could just take the first app and copy the connect_string from the second app in on a sheet when all is done for one database and all tables have been stored away and deleted?</P><P>That would make the whole thing much more manageable.</P><P>I'll try.</P></BODY></HTML> Mon, 03 Jul 2017 12:57:09 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315981#M408592 datanibbler 2017-07-03T12:57:09Z Re: Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315982#M408593 <HTML><HEAD></HEAD><BODY><P>Yes exactly. In one application in the script, I generally wrote the first two lines of the connection code to two different databases and then unloaded the necessary data from them in an arbitrary order.</P></BODY></HTML> Mon, 03 Jul 2017 13:02:27 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315982#M408593 ahaahaaha 2017-07-03T13:02:27Z Re: Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315983#M408594 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!</P><P></P><P>Well, I would probably connect to the second database only after everything on the data from the first one is done to avoid a timeout - the script contains some loops and runs for quite a while ...</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 03 Jul 2017 13:05:10 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315983#M408594 datanibbler 2017-07-03T13:05:10Z Re: Connections to different databases? https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315984#M408595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>something seems to not be right - I now have both SQL_SELECTs (from two different databases) on one sheet - but both have the same structure, so the LOAD statement is the same - when I load from the second database, the plant_key is that of the first one, so I'm not sure that works as expected ... when I deactivate the first half of the code and load only the table from the second database, it is correct.</P><P>Is there some statement I can use to close the connection after use so there can be no "misunderstanding"?</P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Mon, 10 Jul 2017 06:46:13 GMT https://community.qlik.com/t5/QlikView/Connections-to-different-databases/m-p/1315984#M408595 datanibbler 2017-07-10T06:46:13Z