Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Write Qlikview back to DWH

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.

6 Replies
Not applicable

Re: Write Qlikview back to DWH

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

Not applicable

Re: Write Qlikview back to DWH

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

Not applicable

Re: Write Qlikview back to DWH

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

Not applicable

Re: Write Qlikview back to DWH

Hi All,

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

Not applicable

Re: Write Qlikview back to DWH

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)

Not applicable

Re: Write Qlikview back to DWH

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

Community Browser