topic Re: How to connect SQL server and Oracle in the same application? in QlikView https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355110#M131802 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is no problem as long as you have different CONNECT strings to the different data sources. If that keeps throwing errors, upload some example script so we can check further.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13425946751543089" jivemacro_uid="_13425946751543089"><P>ODBC CONNECT TO Source1; // sample dummy string</P><P></P><P>Customers:</P><P>LOAD *;</P><P>SQL SELECT *</P><P>FROM Source1.Customers;</P><P></P><P>ODBC CONNECT TO Source2; // This disconnects from Source1 and connects to Source2</P><P></P><P>Vendors:</P><P>LOAD *;</P><P>SQL SELECT *</P><P>FROM Source2.Vendors;</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 18 Jul 2012 06:58:26 GMT Miguel_Angel_Baeyens 2012-07-18T06:58:26Z How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355107#M131799 <HTML><HEAD></HEAD><BODY><P>I&nbsp; wanted to display data from SQL Server and Oracle Server without success. I tried to put machine generated syntax on different tab, and put into one tab, still does not work. Is this possible to connect to different servers in Qlikview? Thanks</P></BODY></HTML> Tue, 17 Jul 2012 22:03:40 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355107#M131799 2012-07-17T22:03:40Z Re: How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355108#M131800 <HTML><HEAD></HEAD><BODY><P>You can connect to one data source at a time. So connect to SQL server and load data into Qlikview. Then connect to Oracle and extract data from there.</P><P></P><P>After getting data from both sources, you can display your charts/tables fromm the in-memory data in Qlikview.</P></BODY></HTML> Tue, 17 Jul 2012 22:21:10 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355108#M131800 nagaiank 2012-07-17T22:21:10Z Re: How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355109#M131801 <HTML><HEAD></HEAD><BODY><P>I seems like that I can get the data from individual source, but I got error message when reload both data into Qlikview.</P></BODY></HTML> Wed, 18 Jul 2012 03:41:02 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355109#M131801 2012-07-18T03:41:02Z Re: How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355110#M131802 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is no problem as long as you have different CONNECT strings to the different data sources. If that keeps throwing errors, upload some example script so we can check further.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13425946751543089" jivemacro_uid="_13425946751543089"><P>ODBC CONNECT TO Source1; // sample dummy string</P><P></P><P>Customers:</P><P>LOAD *;</P><P>SQL SELECT *</P><P>FROM Source1.Customers;</P><P></P><P>ODBC CONNECT TO Source2; // This disconnects from Source1 and connects to Source2</P><P></P><P>Vendors:</P><P>LOAD *;</P><P>SQL SELECT *</P><P>FROM Source2.Vendors;</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 18 Jul 2012 06:58:26 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355110#M131802 Miguel_Angel_Baeyens 2012-07-18T06:58:26Z Re: How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355111#M131803 <HTML><HEAD></HEAD><BODY><P>It works now. The only problem is that how to let Qlikview know which connection I use for query building. It uses the first connection in Mail tab as default. Can I change the default connection? Thanks!</P></BODY></HTML> Wed, 18 Jul 2012 11:55:23 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355111#M131803 2012-07-18T11:55:23Z Re: How to connect SQL server and Oracle in the same application? https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355112#M131804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>As Miguel's script shows, Qlikview uses the most recent connection for the load. So connect to the SQL source, run all the extracts from SQL Server. Then connect to the Oracle source (which automatically disconnects SQL Server), and run all the extracts from Oracle.</P><P></P><P>There is no 'default' connection, only the most recent connection.</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Wed, 18 Jul 2012 12:02:47 GMT https://community.qlik.com/t5/QlikView/How-to-connect-SQL-server-and-Oracle-in-the-same-application/m-p/355112#M131804 jonathandienst 2012-07-18T12:02:47Z