I have a csv file which has the below mentioned data of Table names in a sql server instance in ubuntu. Tables TableName1 TableName2 TableName3 . . . I want to read this csv file and I want to get…
It is hard to explain this in word, so sorry if the title is mismatch. So I have a file text like this: Header A Header B Header C Header D Apple Red A 100 B 200 B 300 Green…
I want to export csv file to postgresql db using pentago data integration CE. Which data type should i choose both in pentaho and in postgresql to export data correctly? I am using Pentaho CSV file input. Especially I have…
As the questions says, i needed to execute the .ktr file but in via linux in windows i usually just do this : "C:Program FilesPentaho Data Integration - Kettle 6.1.0.1kitchen.bat" -file:"C:/Users/Username/Documents/Pentaho Projects/Job - System Integration.kjb" But i'm still confused on…
i wanted to try to run the pentaho from Linux Centos 7. In the server there are no GUI for it, so i can't open the Spoon GUI where we usually drag and drop the components. If we use the…