Import Single CSV ke Database menggunakan Pentaho Data Integration

Untuk menjalankan tutorial ini, dibutuhkan beberapa hal :

  1. RDBMS engine, (yang digunkan pada tutorial ini adalah SQLSERVER 2012)
  2. Pentaho Data Integration ( http://community.pentaho.com/projects/data-integration/ )
  3. Data .CSV
  4. Kesabaran 😀

Langkah2 :

[tahap persiapan]

  1. Buatlah database untuk menyimpan hasil import

 

This slideshow requires JavaScript.

[tahap pembuatan step]

  • Buka spoon pada Pentaho Data Integration (PDI)

Screenshot_4

  • Buat Transformation baru

Screenshot_5

  • Buat Input dan Output

This slideshow requires JavaScript.

  • Atur Input CSV

This slideshow requires JavaScript.

  • Atur Output Database

This slideshow requires JavaScript.

  • Jalankan Transformasion

This slideshow requires JavaScript.

itu saja, semoga membantu

happy coding : D

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s