Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to retrieve data from etl tools to qlikview?
can u come up with little bit clear ?
retrive means what ? or u want how to load data in qlikview?
Hi,
ETL - Extract, Transform, Load
Generally ETL tools fetches the data from various sources like database, flat files etc, and transforms the data and loads this data into another destination databases/flat files.
So finally all this ETL tools stores data in some databases/flat files, so use this databases or flat files to your dashboards.
Regards,
Jagan.
if we can use etl for QV
1.U target DB(Oracle,Mysql etc)to fetching data from heterogeneous sources.
2,Use connectors line for informatica use informatica connecter
You can also trigger the reloads in QlikView using EDX tasks so that QlikView starts as soon as the job in the ETL tool is ready.
Hi,
To load data from database, we can use ODBC and OLEDB, and also we can load flat files by using the
Edit Script (Ctrl + E) -> Click Table Files Button and select the file to load.
Hope this helps you.
Regards,
Jagan.
Hey,
None of the ETL Tool holds any data. It just extract(from one or multiple soureces) , Transform(to a meaning ful structure of the data) and Load (to a small /large scale db or Flat files).
So ultimately, you have to extract data to our Qlikview from either of these BDs or flat files.
We have different syntax to load data from files and DBs using ODBC and OLEDB.
Hope this helps
Regards,
Chinna