Langsung ke konten utama

MEMPERSIAPKAN PENTAHO DATA INTEGRATION


https://help.pentaho.com/Documentation/5.2/0F0/0G0/020

Prepare Environment


Image of the DI installation steps.
To prepare the computer on which you plan to install the BA design tool and plugins, complete these tasks.

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.
  1. Check the supported technologies list to see which version of the JRE or JDK is needed for the software.
  2. If you have not done so already, log into the computer on which you plan to install the software. Ensure that you have the appropriate permissions to install software.
  3. Open a Terminal or a Command Prompt window. Enter this command.
    java -version
  4. If the version of Java does not match the version needed to run Pentaho software, check your system to see if there are other versions of Java installed.
  5. If the version of Java that you need to run Pentaho software is not on your system, download it from the Oracle site and install it.

Set Environment Variables

Set the PENTAHO_JAVA_HOME variable to indicate the path to the Java JRE or JDK that Pentaho should use. If you do not set this variable, then Pentaho will not start correctly.
To set environment variables, you should be logged into an account that has administrator-level privileges. For Linux systems, you must be logged into the root user account.

Set Windows PENTAHO_JAVA_HOME Variable

  1. From the Start menu, right-click Computer, then select Properties from context menu.
  2. Click Advanced System Settings. The System Properties window appears.
  3. In the System Properties window, click the Advanced tab, then click Environment Variables.
  4. To set the PENTAHO_JAVA_HOME variable do this.
    1. In the System Variable section, click New.
    2. In the window that appears, type PENTAHO_JAVA_HOME in the name field.
    3. In the value field, enter the directory where your Oracle JDK or Oracle JRE is stored. For example your Java JRE is in the Program Files\Java\jre7 directory, type this.
      C:\Program Files\Java\jre7
    4. Click OK.
  5. Click Apply Changes.
  6. Log out, then log back in.
  7. To verify that the variables have been properly set, open a Command window and type this.
    echo %PENTAHO_JAVA_HOME%

Set Linux PENTAHO_JAVA_HOME Variable

  1. Open a terminal window and log in as root.
  2. Open the /etc/environment file with a text editor. Note:The vi and gedit text editors are available on most Linux machines. For example, to open the /etc/environment file with gedit, type this.
    gedit /etc/environment
  3. Indicate where you installed Java in your /etc/environment file by typing this. Note: Substitute /usr/lib/jvm/java-7-sun with the location of the JRE or JDK you installed on your system.
    export PENTAHO_JAVA_HOME=/usr/lib/jvm/java-7-sun
  4. Save and close the file.
  5. Log out, then log back in for the change to take effect.
  6. Verify that the variables are properly set by opening a Terminal window and typing this.
    env | grep PENTAHO_JAVA_HOME

Komentar

Posting Komentar

Silakan dikomen...

Postingan populer dari blog ini

CREATE CROSS TAB QUERY IN MYSQL

MySQL Multi-Aggregated Rows in Crosstab Queries MySQL’s crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis. Today’s topic of discussion is crosstabs, which contain multiple aggregate functions in the row axis of a tabular resultset. Recall from the the  All About the Crosstab Query  article that an aggregate function is one that summarizes a group of related data in some way. Examples of aggregate functions include COUNT, SUM, AVG, MIN, and MAX. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to two or more fields. Today we’ll create a query...

Mysql Import data from CSV File

  Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\PSI011>cd C:\xampp\mysql\bin C:\xampp\mysql\bin> mysqld 2017-08-22 14:24:49 15428 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 16352 ... C:\xampp\mysql\bin> mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.1.25-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use pkh; Database changed MariaDB [pkh]> LOAD DATA LOCAL INFILE 'D:/2017/PKH_FOR_BPKP/PKH_FOR_BPKP_01.csv' -> INTO TABLE pkh_bpkp -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '"' -> ESCAPED BY '"' -> LINES TERMINATED BY '\n...

Pentaho Data Integration: Membuat Koneksi ke database MSSQL Server 2008 R2

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.