topic Re: Datasource in QlikView

Datasource

NavinReddy — Fri, 17 Jan 2014 03:22:30 GMT

Hi All,

I am loading data into Sql server then i created one QVD,is it possible to store same data into My Sql or Oracle

Yesterday one interviewer asking this Question

Could some one help me

Thanks In Advance

Niranjan

jagan — Fri, 17 Jan 2014 03:48:36 GMT

Hi,

Check this threads

Regards,

Jagan.

NavinReddy — Fri, 17 Jan 2014 05:33:54 GMT

Hi Jagan,

I am not getting anything ,could you please give me some other examples

Thanks In Advance

Niranjan

rajeshvaswani77 — Fri, 17 Jan 2014 05:41:09 GMT

Hi Niru,

You can create the QVD, next read this QVD and write to CSV file. import the CSV in to mySQL or any other database. Then it serves as an ETL.

thanks,

Rajesh Vaswani

Fri, 17 Jan 2014 08:11:00 GMT

Your answer should be YES.

you can migrate data from any tool to any data base engine. This is done by ETL tools i.e Extract Transform and Load.

For any BI application, we follow basic 3 steps:

1) Must have an OLTP data available.

2) Transform the data into DataWarehouse using ETL tools.

3) Using DataWarehouse to create BI applications.

Thanks,

Angad