topic Re: connect to QV from sql in QlikView https://community.qlik.com/t5/QlikView/connect-to-QV-from-sql/m-p/1285921#M869366 <HTML><HEAD></HEAD><BODY><P>You don't connect from sql to QV, you connect from QV to SQL or an RDBMS.</P><P></P><P>Start QV Desktop, create a new document and open the script editor. In the toolbar at the bottom, you'll find two buttons labeled "Connect" and "Select".</P><P></P><P>First click "Connect". The wizard will let you create script code to connect to your RDBMS, on condition that you already installed the proper drivers.</P><P>Once you configured a connection (the corresponding code will appear at the cursor position in your script editor window), you can click "Select". Using the currently open connection, a new wizard will let you browse the content of your RDBMS (as far as permissions will let you) and create various SQL statements to extract and process data from the relational DB.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Tue, 06 Dec 2016 10:02:25 GMT Peter_Cammaert 2016-12-06T10:02:25Z connect to QV from sql https://community.qlik.com/t5/QlikView/connect-to-QV-from-sql/m-p/1285920#M869365 <HTML><HEAD></HEAD><BODY><P>hi</P><P>how can I write query in script?</P><P>I could connect to QV from sql</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/connect-to-QV-from-sql/m-p/1285920#M869365 2020-11-25T16:16:04Z Re: connect to QV from sql https://community.qlik.com/t5/QlikView/connect-to-QV-from-sql/m-p/1285921#M869366 <HTML><HEAD></HEAD><BODY><P>You don't connect from sql to QV, you connect from QV to SQL or an RDBMS.</P><P></P><P>Start QV Desktop, create a new document and open the script editor. In the toolbar at the bottom, you'll find two buttons labeled "Connect" and "Select".</P><P></P><P>First click "Connect". The wizard will let you create script code to connect to your RDBMS, on condition that you already installed the proper drivers.</P><P>Once you configured a connection (the corresponding code will appear at the cursor position in your script editor window), you can click "Select". Using the currently open connection, a new wizard will let you browse the content of your RDBMS (as far as permissions will let you) and create various SQL statements to extract and process data from the relational DB.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Tue, 06 Dec 2016 10:02:25 GMT https://community.qlik.com/t5/QlikView/connect-to-QV-from-sql/m-p/1285921#M869366 Peter_Cammaert 2016-12-06T10:02:25Z