- Pentaho Etl Process Download For Mac Pro
- Pentaho Etl Process Download For Mac Free
- Music Download For Mac
In this tutorial we are going to see how to install Pentaho Data Integration 5. PDI 5 (called Kettle) is one of the most powerful tool of the Pentaho Suite that develop a pure (and complete) ETL tool. This tutorial is an extraction of the complete wiki section dedicated to this amazing tool. The latest stable releases of the downloads you are most likely to want if you are new to Pentaho or BI in general. Data Integration (Kettle) - delivers powerful Extraction, Transformation and Loading (ETL) capabilities.
I need to install just about any version that will work for some simple ETL jobs. I'm quite new to the mac world as I got one from my employer. I got pentaho 7.1 or 8.1 'installed' by unzipping the file to Applications and this seems to work at the first glimpse, but there are several follow up issues like crashing the whole application on right click in the sidebar.
I guess I need a clean installation/troubleshoot documentation for mac. I'm running the latest version of Java available for Mac which is 10.0.2 which might be the problem...
Is there any way I can test another Java Version without removing that one? I would be grateful for any documentation or help page that points me in the right direction.
2 Answers
Pentaho 7.1 and 8.1 run using Java 8, so the crashes are most definitely caused by version 10 of Java!
In regards to using another version, you can use a program called Jenv to switch between Java versions on your mac.
First install homebrew (a package manager) using the command
Then run the command
Next you need to install Java 8 JDK (Oracle website)
Once installed, add it to jenv using the command
Obviously replace {YOUR_JAVA_VERSION} with the actual directory of Java 8
Repeat for your Java 10 directory as well.
Run below command to view your added Java versions
You can change Java versions by running the following
Replace oracle64-1.8.0.60 with whatever Java you want (The output of the jenv versions command)
Hope that helps!
This question may be the same as this one. My answer (which was was not accepted as an answer, so I cannot flag your question as duplicate) was that the spoon.sh contains the following lines
So my recommendation was to either follow Pentaho's recommendation to switch to java 32 bits (you can do this for DPI only), either to use Pentaho 7.1.
To switch to Java 32-bit, get the java software as in this question and copy it in a directory nearby your PDI (I am using ../myPDI/Java). Then edit the set-pentaho-env.sh so that the _PENTAHO_JAVA_HOME points to that ../myPDI/Java and and _JAVA_HOME point to ~../MyPDI/Java/bin/java.exe`.
You will need a few (not many) trials before to get it. To ease your debug, you may adding the following lines at the end of the set-pentaho-env.sh, may be of a great help:
as well as replacing temporarily the line '$_PENTAHO_JAVA' $OPT -jar '$STARTUP' -lib $LIBPATH '${1+$@}'with '$_PENTAHO_JAVA' -version.
Not the answer you're looking for? Browse other questions tagged macospentahokettle or ask your own question.
Skip to end of metadataGo to start of metadataA guide to setting up Kettle for client-server style development in a (oh no!) Windows environment.
This information is scattered throughout the forum which made we wish I had a guide like thisso I thought it more newbies to have the information in one place.
Thanks to all the contributors on the forums that did all the ground work for the Windows environment.
Please feel free to edit/correct this guide as required.
Scenario:
Pentaho Etl Process Download For Mac Pro
Users need to use their own machines (desktops/notebooks) to develop but test/run their jobs/transformations on an ETL server.
In this scenario we will be using a central repository to store the ETL jobs. (Someone might want to add what to do differently when using svn).
What you'd need before you start...
- The latest JRE for the server and client
- The latest stable PDI (zip file)
- A kettle repository with a username and password for each developer
- The jobs/transformations logs are written to a database.
- Your .kettle and .pentaho directories containing the information about the repsoitories and db connections you will be using on this project. (Optional)
Setting up ETL Server:
Install the latest JRE if it's not already installed on the server.
Extract PDI to a directory of your choice.
(Note: For a 64-bit machine running the 64-bit JRE you will need to replace 'YourPentahoDirlibswtwin32swt.jar' with the 64-bit version.)
Now edit carte.bat as follows;
- the last line needs to change to allow it to be run in the background without needing parameters, i.e.
start /belownormal javaw %OPT% org.pentaho.di.www.Carte 0.0.0.0 8080
(The port 8080 can of course be changed to whatever you require)
- set it to work in a non-user directory (optional)
- set the memory to what you would require/have avilable
(the limit for 32-bit JVM is around 1583)
Now shedule carte.bat to be run every time the machine is started using Windows Task Scheduler.
Restart the machine and test access to http://yourservername/kettle/status
If the status page is loaded your server you're almost there
Now copy your .kettle and .pentaho directories into the directory you set up as your (kettle) home directory as this tells carte which db connections, etc to use.
(If you do not have these files yet remember to come back to this step once you have set up the first client.)
Finally map a drive on the local machine to the directory where all your (data and work) files will be stored which you need to process.
(This is the easiest way. It is possible to assign relative paths but I did not have the time to reseach this.)
The server should now be ready to work with clients.
Pentaho Etl Process Download For Mac Free
Setting up Client/Desktop machine(s):
Each user that wishes to develop/test PDI jobs/transformations utilising the server and respository needs to do the following.
Map a drive to the ETL server. (Make sure you assign the same drive letter to it that you did on the ETL server.)
Install JRE on your machine if it is not already installed on the client.
Unzip PDI to a directory of your choice.
Copy the .kettle and .pentho directories to C:Documents and SettingsUserUsingPDI
(If you do not have these files don't worry it will be setup when setting up the first client.)
Send a shortcut of spoon.bat to their desktop for convenience. (Optional)
Run spoon
If you had an existing .kettle directory with all the configuration settings, the user is not presented with a list of the available repositories then either it has not been setup or the .kettle directory is in the wrong place.
If not then you have to create a new repository or setup the connection to the repository.
I'm assuming the slave (ETL) server has not been setup as otherwise you would not be reading this guide. The first user/developer to log on would thus need to define the slave server.
Do this by opening a job/transformation from the repository or create a new job to be saved to the repository. A simple read from db to dummy step would be sufficient for a new job.
In the left-hand pane select the view mode, expand the tree and right click on slave server, select new and set up the slave server.
Test the slave server by running the transformation, selecting remote execution and choosing the slave server you have just defined. You will be taken to the monitor slave pane where you can test to see it the job has executed successfully.
Once the remote execution is working right click on the slave server and select share in order to make the slave server available to all the transformations/jobs in the repository.
Save the transformation and exit spoon.
The shared.xml file will now have been updated with the shared slave. Use this file to overwrite the one in the .kettle directory that is distributed to everyone on the project.
The next user would not have to set up the repository or slave server if the .kettle and .penthao directories are copied before spoon is started.
The developers will now be able to develop in a client-server style environment.
Music Download For Mac
Ps. remeber to have all the developers set their grid size to the same value, as the stages will always snap to the new points as soon as you do anything with it.