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.