PEMANFAATAN ALTOVA SERVER DAN ADVANCED MESSAGE QUEUE PROTOCOL (AMQP) PADA SISTEM TERINTEGRASI MENGGUNAKAN KONSEP ENTERPRISE SERVICE BUS (ESB)
Disusun sebagai salah satu syarat untuk kelulusan Program Strata 1, Program Studi Teknik Informatika, Universitas Pasundan Bandung oleh : Fina Frimierviana Nrp. 12.304.0438
PROGRAM STUDI TEKNIK INFORMATIKA FAKULTAS TEKNIK UNIVERSITAS PASUNDAN BANDUNG SEPTEMBER 2014
DAFTAR ISI ABSTRAK ............................................................................................................................ i ABSTRACT .......................................................................................................................... ii KATA PENGANTAR ........................................................................................................... iii DAFTAR ISI ......................................................................................................................... iv DAFTAR TABEL.................................................................................................................. vi DAFTAR GAMBAR ............................................................................................................. vii DAFTAR SIMBOL ............................................................................................................... ix BAB I PENDAHULUAN ...................................................................................................... 1-1 1.1 Latar Belakang ................................................................................................................. 1-1 1.2 Identifikasi Masalah ......................................................................................................... 1-2 1.3 Tujuan.............................................................................................................................. 1-2 1.4 Lingkup Penelitian ........................................................................................................... 1-3 1.5 Metodologi Penelitian ...................................................................................................... 1-3 1.6 Sistematika Penulisan....................................................................................................... 1-4 BAB II LANDASAN TEORI................................................................................................. 2-1 2.1 Arsitektur Integrasi........................................................................................................... 2-1 2.2 Enterprise Service Bus (ESB)........................................................................................... 2-5 2.2.1 Message-Oriented Middleware (MOM).................................................................... 2-7 2.2.2 Advanced Mesage Queuing Protocol (AQMP) ......................................................... 2-9 2.2.3 RabbitMQ .............................................................................................................. 2-10 2.3 Altova Mapforce .............................................................................................................. 2-10 2.4 Altova Flowforce Server .................................................................................................. 2-13 2.5 Bagan Alir (Flowchart) .................................................................................................... 2-15 BAB III ANALISA MASALAH ............................................................................................ 3-1 3.1 Permasalahan yang Dihadapi ............................................................................................ 3-1 3.1.1 Gambaran Mengenai Lingkungan TI yang Sedang Berjalan ..................................... 3-1 3.1.2 Gambaran Aliran Data yang Sedang Berjalan .......................................................... 3-2 3.1.3 Analisis Terhadap Permasalahan yang Terjadi ......................................................... 3-3 3.1.3.1 Proses Otomatisasi Tanpa Melakukan Integrasi ............................................ 3-3 3.1.3.2 Proses Otomatisasi Dengan Melakukan Integrasi ......................................... 3-5 3.2 Rancangan Sistem Baru.................................................................................................... 3-6 3.2.1 Rancangan Arsitektur Sistem Baru........................................................................... 3-6 3.2.2 Gambaran Aliran Data Sistem Baru ......................................................................... 3-9 3.2.3 Kebutuhan Perangkat Lunak .................................................................................... 3-10 3.2.4 Perancangan Pengambilan Data dengan Altova Mapforce ........................................ 3-11 iv
3.2.5 Perancangan Scheduler dengan Altova Flowforce .................................................... 3-12 3.2.6 Perancangan Pengiriman Data dengan Advanced Message Queue Protocol .............. 3-13 BAB IV IMPLEMENTASI PERANCANGAN DAN SKENARIO PENGUJIAN................... 4-1 4.1 Proses Mapping menggunakan Mapforce ......................................................................... 4-1 4.1.1 Pengaturan Koneksi dengan Database ...................................................................... 4-1 4.1.2 Pembuatan Tujuan Data ........................................................................................... 4-7 4.1.3 Melakukan proses mapping sumber data ke tujuan data ............................................ 4-10 4.1.4 Melakukan deploy mapping ke flowforce server ...................................................... 4-11 4.2 Proses Pengaturan Job menggunakan Flowforce Server .................................................... 4-13 4.3 Proses Pembuatan Middleware Oriented Message menggunakan Rabbit MQ .................... 4-16 4.4 Skenario Pengujian........................................................................................................... 4-19 4.5 Hasil Pengujian ................................................................................................................ 4-20 4.5.1 Hasil Proses Pemetaan ............................................................................................. 4-20 4.5.2 Hasil Pengecekan Output dari Pemetaan .................................................................. 4-21 4.5.3 Hasil Proses Pengiriman dengan command line (manual) ......................................... 4-22 4.5.4 Hasil Proses Penerimaan dan Pengiriman E-mail dengan command line (manual) .... 4-23 4.5.5 Hasil Proses Penarikan, Penerimaan data, Pengiriman e-mail dengan scheduler ....... 4-24 BAB V KESIMPULAN DAN SARAN.................................................................................. 5-1 5.1 Kesimpulan ...................................................................................................................... 5-1 5.1 Saran................................................................................................................................ 5-1 DAFTAR PUSTAKA ............................................................................................................ 6-1
v
DAFTAR TABEL Tabel 3.1. Kebutuhan data............................................................................................................. 3-8 Tabel 4.1. Tabel Pengujian............................................................................................................ 4-19
vi
DAFTAR GAMBAR Gambar 1.1 Diagram Metode Penelitian..................................................................................................................... 1-1 Gambar 2.1 Integrasi level data [JUR07] ...................................................................................... 2-1 Gambar 2.2 Integrasi aplikasi [JUR07] .......................................................................................... 2-2 Gambar 2.3 Integrasi proses bisnis [JUR07] .................................................................................. 2-3 Gambar 2.4 Arsitektur Message Oriented Middleware [JUR07] .................................................... 2-7 Gambar 2.5 Pengiriman pesan dengan MOM [BAR08] ................................................................. 2-8 Gambar 2.6 Library [ALT14B] ..................................................................................................... 2-11 Gambar 2.7 Contoh Fungsi [ALT14B] .......................................................................................... 2-11 Gambar 2.8 Contoh Item [ALT14B].............................................................................................. 2-12 Gambar 2.9 Contoh Icon Input dan Output [ALT14B] ................................................................... 2-12 Gambar 2.10 Arsitektur Flowforce Server [ALT14A].................................................................... 2-13 Gambar 2.11 Stuktur Job [ALT14A] ............................................................................................. 2-14 Gambar 3.1 Arsitektur sistem yang sedang berjalan....................................................................... 3-1 Gambar 3.2 Gambaran aliran data yang sedang berjalan ................................................................ 3-2 Gambar 3.3 Gambaran yang akan terjadi tanpa melakukan integrasi .............................................. 3-3 Gambar 3.4 Gambaran yang akan terjadi dengan melakukan integrasi ........................................... 3-5 Gambar 3.5 Perancangan arsitektur infrastuktur ............................................................................ 3-6 Gambar 3.6 Bagian stuktur tabel yang digunakan .......................................................................... 3-7 Gambar 3.7 Perancangan aliran data sistem baru ........................................................................... 3-8 Gambar 3.8 merupakan rancangan dari pengambilan data menggunakan altova mapforce. ............. 3-9 Gambar 3.9 Mapping data dengan altova mapforce ....................................................................... 3-11 Gambar 3.10 Trigger dalam job..................................................................................................... 3-12 Gambar 3.11 Perancangan proses pengiriman data ........................................................................ 3-13 Gambar 4.1 Altova Mapforce ........................................................................................................ 4-1 Gambar 4.2 Klik icon database...................................................................................................... 4-2 Gambar 4.3 Pemilihan tipe koneksi database ................................................................................. 4-2 Gambar 4.4 SQL Server Native Client 10.0 ................................................................................... 4-3 Gambar 4.5: Connection ............................................................................................................... 4-4 Gambar 4.6 Pop-up dari Test Connection ...................................................................................... 4-5 Gambar 4.7: Connect .................................................................................................................... 4-6 Gambar 4.8: Memilih table yang digunakan .................................................................................. 4-6 Gambar 4.9 Hasil dari konfigurasi koneksi dengan database .......................................................... 4-7 Gambar 4.10 Icon ‘insert text file’................................................................................................. 4-7 Gambar 4.11 Insert Text Component ............................................................................................. 4-8 Gambar 4.12 Component Setting................................................................................................... 4-8 vii
Gambar 4.13 Hasil akhir dari pembuatan tujuan data ..................................................................... 4-9 Gambar 4.14 Mapping data dengan altova mapforce ..................................................................... 4-10 Gambar 4.15: Membuka file mapping ........................................................................................... 4-11 Gambar 4.16 Memilih file mapping............................................................................................... 4-11 Gambar 4.17 Deploy to flowforce server ....................................................................................... 4-12 Gambar 4.18 Deploy to flowforce server ....................................................................................... 4-12 Gambar 4.19 Penggunaan Altova Flowforce.................................................................................. 4-13 Gambar 4.20 Login ....................................................................................................................... 4-14 Gambar 4.21 Menu configuration .................................................................................................. 4-14 Gambar 4.22 Create Job ................................................................................................................ 4-14 Gambar 4.23 Execution Steps ....................................................................................................... 4-15 Gambar 4.24 Trigger dalam job..................................................................................................... 4-16 Gambar 4.25 Penggunaan RabbitMQ ............................................................................................ 4-16 Gambar 4.26 Channel tugas_akhir di proses pengiriman ................................................................ 4-17 Gambar 4.27 Channel tugas_akhir di proses penerimaan ............................................................... 4-17 Gambar 4.28 Parameter channel tugas_akhir ................................................................................. 4-18 Gambar 4.29 Hasil pengecekan jumlah baris database ................................................................... 4-20 Gambar 4.30 Validate Mapping .................................................................................................... 4-20 Gambar 4.31 Hasil Output............................................................................................................. 4-21 Gambar 4.32 Pengecekan jumlah baris database ............................................................................ 4-21 Gambar 4.33 Pengecekan jumlah baris di text file ......................................................................... 4-22 Gambar 4.34 Pengiriman dengan command line ............................................................................ 4-23 Gambar 4.35 Penerimaan data dan pengiriman dengan command line ........................................... 4-23 Gambar 4.36 Mengubah waktu...................................................................................................... 4-24 Gambar 4.37 Log di Altova Flowforce .......................................................................................... 4-24 Gambar 4.38 Rincian Gaji berhasil diterima .................................................................................. 4-26
viii
DAFTAR SIMBOL SIMBOL
NAMA SIMBOL
FUNGSI SIMBOL Simbol yang menyatakan awal dan akhir dari suatu
Simbol titik
proses.
Simbol input/ouput
Simbol yang mewakili data input/output.
Simbol proses
Simbol yang menyatakan proses dari suatu proses.
Simbol yang menyatakan input/output menggunakan
Simbol hard disk
hard disk. Simbol yang menyatakan suatu operasi yang rinciannya
Simbol keputusan
ditunjukkan di tempat lain.
ix
