Write back to database

NavinReddy · ‎2014-01-16

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 · ‎2014-01-16

Hi,

Check this threads

Write Back to database

Regards,

Jagan.

NavinReddy · ‎2014-01-17

Hi Jagan,

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

Thanks In Advance

Niranjan

rajeshvaswani77 · ‎2014-01-17

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

Report Inappropriate Content · ‎2014-01-17

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