![pentaho data integration download pentaho data integration download](https://morannachum.files.wordpress.com/2015/02/post05-image03.png)
In the Database Connection dialog box, use the General option in the left pane, which is selected by default, to enter your database connection information:.Click the View tab, then right-click Database connections > New to create a connection to your Vertica database.If you are new to PDI and want to understand the difference between transformations and jobs, see the PDI documentation. On the left side of the screen, in the View tab, double-click Transformations to create a new Transformation or double-click Jobs to create a new Job.Double-click Spoon.bat to launch the PDI client.In this example: C:\PentahoCE\pdi-ce\data-integration Navigate to the path of your PDI installation.
![pentaho data integration download pentaho data integration download](https://www.hitachivantara.com/content/dam/public/en_us/image/test-images/screen.png)
Connect Pentaho Data Integration to Verticaįollow the steps below to create a connection to Vertica that can be used either as a source or as a target database: PDI supports both JDBC and ODBC connectivity. For information, see Pentaho software requirements for JRE.įirst check your current version of Java from the Windows command prompt:
#PENTAHO DATA INTEGRATION DOWNLOAD INSTALL#
Install and Configure a JREīefore you can connect PDI to Vertica, you must install and configure a Java Runtime Environment (JRE) that is compatible with your version of Pentaho. You can download the community edition of Pentaho Data Integration (PDI) from the Pentaho Community site.įor details about Pentaho Data Integration, see the Hitachi Vantara Pentaho Data Integration website.
#PENTAHO DATA INTEGRATION DOWNLOAD UPGRADE#
You can use the community edition free of charge and upgrade to the enterprise edition if required. Pentaho offers a community edition as well as an enterprise edition of their products. This guide focuses on the Data Integration component of the platform, which provides Extraction, Transformation, and Loading (ETL) capabilities.įor information about Pentaho Business Analytics, see Vertica Integration with Pentaho Business Analytics: Connection Guide. Pentaho is a platform that offers tools for data movement and transformation, as well as discovery and ad hoc reporting with the Pentaho Data Integration (PDI) and Pentaho Business Analytics products. Pentaho Data Integration Community Edition v.8.1