Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export data to an external table using a odbc connection

Hi,
we created a qlikview-document that delivers Information for the usage of our online Portals like
registrations, Logins and retrievals per document. Now we need some of the Information for
the royality Management in our ERPSystem. The data for the ERP System is stored in DB2 tables
on an i5. Is there a way to Export data from a qlikview document to an external DB2 table via
ODBC Connection ?
Thanks for your help in advance.

2 Replies
Gysbert_Wassenaar

Yes, and if you can figure out how I wish you the best of luck with it. Personally I'd just export to csv and load the csv file into the database. As mama used to say: "If you don't know how to do that, that means you shouldn't."


talk is cheap, supply exceeds demand
jaimeaguilar
Partner
Partner

Hi,

take a look at this page http://www.etl-tools.com/ . It has some utilities than can help you in what you need. In particular, the ETL Processor can be very useful for you. With this tool you can load data from many different files (including QVDs) into virtually any database.

regards