I have been with working with Spoon client for quite sometime now, however, my only boundary was that it was always the Windows server. So what happens, when you pick those jobs and transformation you have written in the spoon client, and want to execute in the Linux environment?
Step 1: Panic mode on
Step 2: Extensive communities and articles to search(there are not many posts or links on it)
Step 3: Panic some more and then stumble upon the amazing documentation of Pentaho
Step 4: Relax and execute the jobs
Then, again I struggled a lot to get a consolidated information on the explanation exactly what needs to be done and where. So here, I have put few information from my experience on how it can be done, for the first timers.
The below steps are used for transforming CSV files into CMDB
Step 1: Open your spoon client installed on the windows machine, design the jobs and transformation (make sure once done with the testing of the job, to point the file source to the actual server location where the file will be read from)
Step 2: Place the files(Jobs and Transformation) in a specific repository. Again, this can be done from the Job setting.
Note: You can create a separate repository to store the jobs designed by you, or use the existing one.
Step 3: Login to the Linux remedy server, via Putty
Step 4: Navigate to the location, where the kitchen.sh or pan.sh file is present (usual location is /BMC/Arsystem/diserver/data-integration)
Step 5: Run the kitchen.sh command to execute the jobs with some parameters or run the pan.sh command to execute the transformations.
Below are the few command examples
- To run a Transformation job
./kitchen.sh -server=servername -port=portnumber -user=username -pass=password -dir="/repositoryname" -job="job name"
- To run a Transformation
./pan.sh -server=servername -port=portnumber -user=username -pass=password -trans="transformation name"
- List the Directory
./kitchen.sh -server=servername -port=portnumber -user=username -pass=password -listdir=Y
- List the jobs in the directory
./kitchen.sh -server=servername -port=portnumber -user=username -pass=password - listjobs=Y
- If the job names have a space in between them, enclose them in " "
- Always have the directory name preceded by a /