topic Re: QlikView sql insert query to SQL Server in QlikView

QlikView sql insert query to SQL Server

medlarayedh — Thu, 14 Dec 2017 09:53:19 GMT

Hi All,

Can you please give some examples or scenarios how can we use SQL INSERT queries from qlikview to SQL Server.

How to insert data into SQL Table.

Thx

Re: QlikView sql insert query to SQL Server

omkarvamsi — Fri, 15 Dec 2017 08:20:28 GMT

Could you please be clear in scenario.

Re: QlikView sql insert query to SQL Server

Anil_Babu_Samineni — Fri, 15 Dec 2017 08:38:03 GMT

Your assumption is true, The same way in DB like

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

In QlikView, Here we go..

SQL INSERT INTO Table (Field, Field1, Field2) values (2, 'textA', 'textB');

Re: QlikView sql insert query to SQL Server

medlarayedh — Fri, 15 Dec 2017 09:11:44 GMT

Thank you guys

I am wondering how to insert a table from QlikView into a sql table. Is it through macro or not? If so, what would the script look like?

Re: QlikView sql insert query to SQL Server

Anil_Babu_Samineni — Fri, 15 Dec 2017 09:16:03 GMT

I've tested with this?

// Connection String for DB

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=ServerName;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False];

SELECT field, Field1, Field2 From Table_Test;

To insert stuff from Qlikview directly we need below one. And this works as Request and Response process

SQL INSERT INTO (Field, Field1, Field2) values ('Anil', 'Babu', 'Samineni');

Does this make clear?

Re: QlikView sql insert query to SQL Server

its_anandrjs — Fri, 15 Dec 2017 09:20:59 GMT

Before try why not go with some of the documents

There are many threads related to this.

Inserting data into Database through Qlikview

SQL Insert from QlikView.qvw

Re: QlikView sql insert query to SQL Server

big_dreams — Fri, 15 Dec 2017 09:21:33 GMT

There is no direct way to do it in qlik

You can do like

export that table in excel and then import it into sql Server.

or if you want to automate the process then try like

1: Write macro to export table output in excel.

2: Create qv app to load excel and write insert statement after load statement to upload that data into sql server.

Regards,

Re: QlikView sql insert query to SQL Server

medlarayedh — Fri, 15 Dec 2017 09:29:43 GMT

I will try Anil thx

Re: QlikView sql insert query to SQL Server

medlarayedh — Fri, 15 Dec 2017 09:30:06 GMT

Thank you Anand

Re: QlikView sql insert query to SQL Server

medlarayedh — Mon, 18 Dec 2017 09:10:28 GMT

How could i do it max? , i mean by using the macro to automate the process

Re: QlikView sql insert query to SQL Server

big_dreams — Mon, 18 Dec 2017 09:59:57 GMT

This is just rough idea. We have to check how we can implement it.

step 1 : we can write macro to table data in excel sheet.

step 2 : create another qvw which load that excel and then using sql operation as suggested by anil we can insert it into db.

Regards,