topic Re: Multiple QVD files Convert to SQL Server Database in QlikView

Multiple QVD files Convert to SQL Server Database

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

Hi Experts,

I'm wondering whether there is any way to convert multiple qvd files to SQL server database?

Thanks in advanced

Re: Multiple QVD files Convert to SQL Server Database

Anil_Babu_Samineni — Mon, 16 Oct 2017 02:11:29 GMT

The ways are following as i am having

1) Need to open QVD in text editor and then copy paste in SQL server table (Best way)

2) If you can save after open the QVD's, You need to store it as XLS / CSV format and then need to import while configurator

3) If above won't help, please describe more

Re: Multiple QVD files Convert to SQL Server Database

tomasz_tru — Mon, 16 Oct 2017 07:19:27 GMT

You can do it directly from the script using "SQL INSERT INTO..." in a loop that pass table row by row.

Tomasz

Re: Multiple QVD files Convert to SQL Server Database

Peter_Cammaert — Mon, 16 Oct 2017 07:41:54 GMT

A third option may be to check the original data sources of the QVDs. There may be a shortcut to import data from the original data sources into SQL Server tables by way of the Integration Services component or even the Import/Export feature in SQL Server Management Studio. Keep in mind that using a QVW document (the only tool to extract data from usually very large QVDs) to transfer data to an RDBMS may be extremely slow and as a result take an awful lot of time.

Peter

Re: Multiple QVD files Convert to SQL Server Database

katetsan — Mon, 16 Oct 2017 07:52:31 GMT

Hi Peter,

Thanks for your reminder. I do have the same concern as you mentioned.

I'm quite interested in "Integration Service" component as you mentioned, is that provided by Microsoft SQL server?

Thanks a lot

Re: Multiple QVD files Convert to SQL Server Database

Peter_Cammaert — Mon, 16 Oct 2017 08:11:10 GMT

Indeed, it's a SQL Server package that can be used to integrate and transform data streams/source in a SQL Server DBMS environment. Search for 'SQL Server Integration Services' and you'll find a lot of information.

Do not use it if it doesn't offer prebuilt solutions for your situation, or a quick path towards data integration for you sources. It's a complex product and the learning curve may be too steep for a one-off project. There are other ETL tools available for SQL Server as well.