topic Re: etl in QlikView

etl

Sat, 15 Nov 2014 12:43:43 GMT

how to retrieve data from etl tools to qlikview?

Re: etl

Sat, 15 Nov 2014 12:45:26 GMT

can u come up with little bit clear ?

retrive means what ? or u want how to load data in qlikview?

Re: etl

jagan — Sat, 15 Nov 2014 13:03:27 GMT

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.

Re: etl

deepakqlikview_123 — Sat, 15 Nov 2014 13:07:12 GMT

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

Re: etl

morgankejerhag — Sat, 15 Nov 2014 18:16:33 GMT

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.

Re: etl

jagan — Mon, 17 Nov 2014 02:42:14 GMT

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.

Re: etl

Anonymous — Mon, 17 Nov 2014 03:00:58 GMT

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