Discussion Board for collaboration related to QlikView App Development.
Is it possible that two different sources (ie, oracle and db2) data in different servers can be inserted,
updated,deleted or writeback to another database server (say DB2) using the Qlikview ETL?
If so, please let me know the method or procedure. Thanks
Connecting to differnet sources using ODBC/OLEDB will never eb a problem with QV.
I would sugegst for the following :
Bring the data into a staging (Stored QVDs) using ODBC/OLEDB connection to the respective sources.
From the stored QVD's load the data as per your wish (merge if requird) into your aQV application.
Now the applcationc an ponit to a specific source for read/write/update.
The application can point to a specific source (ie DB2) for read/write/update (write-back) through a macro or is there another way? Do you have a sample qvw application like this? i would really appreciate if you have one.
Thanks in advance.
Qlikview is not really strong in writing back to ODBC in the scenario you have outlined, but it is possible. If you search the forum, you'll find some macros that will update a database from a QV table (ADO I think). There is also a sqlvalue() function available which may work for small updae activity.
Depending on your flow, another possibilty would be to export the data to XLS or CSV and do a batch update of the database.
We recently created an interesting utility that can push QVDs into a database. We are in the process of integrating it along with the Publisher using the EDX capabilities. It helped us meet the need to use QlikView as the ETL layer. Like Rob mentioned, of course, it works in batch mode only - atleast as of now!
As alternative you may consider using our ETL-Tools QlikView connector. It works directly with 23 data sources has more than 300 data transformation and validation functions plus it has powerful GUI which makes it it easy to design complex data transformations even for new user.
The trial has no limitations and can be downloaded today
We are constantly adding new functions and data sources
Writing into the datasource is typically not a BI job. Anyway, QV script allows it. Tecnically, you can write any SQL command after the keyword SQL, not only SELECT. Just make sure that your open connection in the read/write mode. And the connection credentials must have write permission.
(As for my expereince, I only had to create indexes in the database while executing the script, never had to insert or update.)
Let us know if you have any questions or problems.
We will be happy to assist.
Also if you have any suggestions on how to improve our ETL software please let us know and we will implement them for you. As you can see from our support forum we do listen to our customers