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.
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."
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.