Rajendra Ongole

How to extract data using SQL queries in Pentaho

Discussion created by Rajendra Ongole on Feb 14, 2018

Hi Pentaho Gurus-I have a sql queries with lot of joins with record count of  9 lakhs per day. i want to extract it from another server to my local server.

 

Will pentaho support to extract this huge data? if yes, what are the prerequisites that i have to install ?

 

Please support.

 

if it extracts how much time will it consume to extract the file as .txt?

 

Server configuration is 2 core 32 GB RAM.

 

Need you suggestions/support on this.

 

Regards,

Rajendra

Outcomes