Soepermen si "Super Hero"

https://stackoverflow.com/questions/49705813/pentaho-excel-file-creation-with-file-name-from-field-or-other-variable Not knowing what your existing solution does, or why, this is the best way I can think of solving your problem, given you want exactly the same data in a different file format: Create a new job. In that job start a new transformation called 'get locations'  In this 'get locations' transformation as below, have two steps a) Table input, with a query like 'select distinct locations from data' and b) copy rows to result. This should give you a list of your unique locations Create another new job called 'set variable and make excel'. This job will be run after your 'get locations' transformation, tick the 'execute once for every row' checkbox In the new job, you'll have two transformations. set variable, and make excel.  The set variable transformation has two steps, first 'gets rows from results' then 'set vari...

https://help.pentaho.com/Documentation/5.2/0F0/0G0/020 Prepare Environment To prepare the computer on which you plan to install the BA design tool and plugins, complete these tasks. Install Java JRE or JDK . Set environment variables . Install Java JRE or JDK Make sure that the version of the Java Runtime Environment (JRE) or the Java Development Kit (JDK) that Pentaho needs to run is installed on your system. You do not need to uninstall other versions of Java if you already have them running on your system. These instructions explain how to check for your default version of Java that is running on your computer and where to get the required version if you need one. Check the supported technologies list to see which version of the JRE or JDK is needed for the software. If you have not done so already, log into the computer on which you plan to install the software. Ensure t...

The JAVA_HOME and JRE_HOME environment variables The BI Server is written on the Java platform, and for the BI Server to work properly, you need to make sure that the JAVA_HOME or JRE_HOME environment variable has been set up properly. Follow the given steps: Set the JAVA_HOME variable pointing to your JDK installation folder, for example, C:\Program Files\Java\jdk1.6.0_45 . Set the JRE_HOME variable pointing to your JRE installation folder, for example, C:\Program Files\Java\jre6 . For example, if you set the JAVA_HOME variable in the Windows 7 environment, the Environment Variables dialog will look like the following screenshot:

http://pentaho-bi-suite.blogspot.co.id/2015/03/kettle-etl-basics-5-command-line.html In this post we will see the basics of how to schedule a Job in Windows environment using "Windows Task scheduler". Prior to scheduling jobs or transformations either in linux or windows one should know how to execute jobs/transformations from command line by passing arguments or parameters or variables. 1) Design & develop transformation or job. 2) Make transformation or job dynamic using parameters or variables. 3) Execute the transformation or job from command line by passing parameter or variables. 4) Prepare a list of commands in a batch file. 5) Schedule the .bat file in windows using "Task Scheduler" Tool. http://wiki.pentaho.com/display/EAI/Kitchen+User+Documentation#KitchenUserDocumentation-Scheduling

Untuk terhubung ke database SQL Server langkah-langkah berikut harus dilakukan:   Download Driver Microsoft JDBC di https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774  Tutup Spoon atau Kettle project  Unzip/extract paket dalam direktori temporer (bebas) Copy '<temp directory> \ sqljdbc_6.0\enu\auth\x64\ sqljdbc_auth.dll' ke 'C:\Program Files\Java\jre1.8.0_131' atau sesuaikan dengan path java runtime terinstall  Copy '<temp directory>\ sqljdbc_6.0\enu\jre8\sqljdbc42.jar' ke '<Kettle folder instalasi> \ data-integration \ lib' Buka Spoon atau Kettle project Uji koneksi dalam Spoon Hapus direktori temporer karena sudah tidak digunakan lagi Jika kita meng-upgrade Kettle, Java, JDBC Driver ke versi yang lebih tinggi, maka serangkaian langkah-langkah di atas harus diulang lagi.