topic Re: Write Qlikview back to DWH in QlikView

Write Qlikview back to DWH

Thu, 12 Sep 2013 08:27:06 GMT

We can generates the Qlikview qvd file out put into csv files. Now we want to write back these csv files into DHW ( MS SQL Server). How it is possible by automation? Any advise, greatly appreciates.

Re: Write Qlikview back to DWH

Thu, 12 Sep 2013 08:28:12 GMT

If you write them back to CSV files, you could load them from SSIS, and hereby extracting them to a table.

Re: Write Qlikview back to DWH

Thu, 12 Sep 2013 09:01:14 GMT

Thank you Thomas Jensen. Is there any method to achieve the same?

Re: Write Qlikview back to DWH

Thu, 12 Sep 2013 09:07:58 GMT

Hello,

You can use any ETL tool to perform this. As mentioned SSIS, and open source tools like Talend etc.

And also you can use Macro to perform this. Check below links:

http://community.qlik.com/thread/61660

http://community.qlik.com/thread/25063

Thanks,

ASINGH

Re: Write Qlikview back to DWH

Sat, 14 Sep 2013 06:56:47 GMT

Hi All,

I did not get. please provide the steps or document for this.

Re: Write Qlikview back to DWH

Mon, 16 Sep 2013 13:47:56 GMT

Do like this if you do not know how to do it in SSIS:

http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

Then you can add a job to the SQL job agent, which can run this daily. (Remember to truncate table if you are doing a full load)

Re: Write Qlikview back to DWH

Mon, 16 Sep 2013 13:52:19 GMT

select flat file source instead of excel. Then you can choose csv files.