topic Changing the db connection from MS SQL to Oracle in QlikView https://community.qlik.com/t5/QlikView/Changing-the-db-connection-from-MS-SQL-to-Oracle/m-p/1380657#M420879 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Qlikview dashboard which is using the SQL server as back end data source. We are generating the QVD files to store the data.</P><P></P><P>Now i want make a connection to oracle database in the same qlikview dashboard and remove the connection to SQL server.</P><P></P><P>Is that going to work provided the table structure in both Oracle and SQL server is same.</P><P></P><P>Attached is the screenshto for your referece. The current connection string gets the data from MS SQL and that needs to be replaced by oracle db connection.</P><P></P><P>waitig for your suggestions and feedback.</P><P></P><P>thank you</P><P></P><P>Regards,</P><P>Viresh</P><P></P><P><IMG alt="MS SQL to Oracle.PNG" class="jive-image image-1" src="/legacyfs/online/173047_MS SQL to Oracle.PNG" style="height: 300px; width: 620px;" /></P></BODY></HTML> Thu, 10 Aug 2017 11:21:32 GMT vireshkolagimat 2017-08-10T11:21:32Z Changing the db connection from MS SQL to Oracle https://community.qlik.com/t5/QlikView/Changing-the-db-connection-from-MS-SQL-to-Oracle/m-p/1380657#M420879 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Qlikview dashboard which is using the SQL server as back end data source. We are generating the QVD files to store the data.</P><P></P><P>Now i want make a connection to oracle database in the same qlikview dashboard and remove the connection to SQL server.</P><P></P><P>Is that going to work provided the table structure in both Oracle and SQL server is same.</P><P></P><P>Attached is the screenshto for your referece. The current connection string gets the data from MS SQL and that needs to be replaced by oracle db connection.</P><P></P><P>waitig for your suggestions and feedback.</P><P></P><P>thank you</P><P></P><P>Regards,</P><P>Viresh</P><P></P><P><IMG alt="MS SQL to Oracle.PNG" class="jive-image image-1" src="/legacyfs/online/173047_MS SQL to Oracle.PNG" style="height: 300px; width: 620px;" /></P></BODY></HTML> Thu, 10 Aug 2017 11:21:32 GMT https://community.qlik.com/t5/QlikView/Changing-the-db-connection-from-MS-SQL-to-Oracle/m-p/1380657#M420879 vireshkolagimat 2017-08-10T11:21:32Z