topic Re: Creating QVD files or Connecting straight to SQL server in QlikView

Creating QVD files or Connecting straight to SQL server

davidvikings198 — Wed, 25 Nov 2020 16:16:04 GMT

Can someone give me their thoughts on:

1. Creating QVD files.

2 Or straight connection to SQL DB.

I Want the pros and the cons. Better yet best practices. I know some myself but want to here from the community.

DAvid‌

Re: Creating QVD files or Connecting straight to SQL server

Anil_Babu_Samineni — Wed, 31 Jan 2018 00:03:00 GMT

I am going to start from second one

2) Or straight connection to SQL DB

- You need to create ODBC Driver (From Administrative Tools (Under Control Panel), You need to pick either 32-bit or 64-bit)

- And you have to connect DB via Created ODBC Driver

- You have to provide more inputs - Follow How to pull data from PostgreSQL to Qlik

1) Creating QVD files

- Once your load success from Any DB

- Use STORE Command to store QVD's from All directories

- STORE DirectoryName into YourPath\FileName..qvd (qvd);

Re: Creating QVD files or Connecting straight to SQL server

davidvikings198 — Wed, 31 Jan 2018 00:08:28 GMT

‌Thank you Anil. Do you have an opinion on which one you like over the other. Seems connecting to the server would create load time where weds would not.

DAvid

Re: Creating QVD files or Connecting straight to SQL server

Anil_Babu_Samineni — Wed, 31 Jan 2018 00:11:00 GMT

Your 2 question are 2 different questions not similar one. Not sure, I followed about this?

Re: Creating QVD files or Connecting straight to SQL server

davidvikings198 — Wed, 31 Jan 2018 00:14:53 GMT

‌Sorry about that. What I was asking is when loading data is it better to pull it straight from the sql db or create qvds of your data and load the data from them.

DAvid

Re: Creating QVD files or Connecting straight to SQL server

Anil_Babu_Samineni — Wed, 31 Jan 2018 00:28:35 GMT

Yes, There is 2 approaches

1) Maintain Another QVW which Transaction work file like to generate QVD's (Which means QVD generator)

2) Again, Without load data There is no concept QVD in QIX. So, You can work load the data and Store into QVD's then Load QVD's into Qlik (This is more optimized and will work 1:10 ratio).

3) So, finally Even if your server(DB) gets down you don't worry about Data load because STORE command runs internally inline memory for Qlik.

Does this helps?

Re: Creating QVD files or Connecting straight to SQL server

Chamini2020 — Fri, 21 Aug 2020 10:14:03 GMT

anyone give an example for this