How to store downloaded ODBC data

Thu, 26 Apr 2012 15:21:49 GMT

Hi to all,

I 'm connecting to an ODBC server to download data, I would like to know if there is a way to save the downloaded data in a local file in order to modify fields name without re-connecting to the server every time I modify something in the script.

Thanks

Francesco

Re: How to store downloaded ODBC data

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 15:32:55 GMT

Hi Francesco,

That's what QVD are for, among many other things. Take a look at the following script:

SET vQVDPath = 'C:\TempFiles\';
 
ODBC CONNECT64 TO [DSNNameHere];
 Table:
LOAD *;
SQL SELECT *
FROM Customers;
STORE Table INTO $(vQVDPath)Customers.qvd (qvd); // this will allow you to load from this file later on

Hope that helps.

Miguel

topic Re: How to store downloaded ODBC data in QlikView

How to store downloaded ODBC data

Re: How to store downloaded ODBC data