- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
etl
how to retrieve data from etl tools to qlikview?
- Tags:
- new_to_qlikview
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can u come up with little bit clear ?
retrive means what ? or u want how to load data in qlikview?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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