PEMBANGUNAN APLIKASI DATA INTEGRATOR BERBASIS WEB SERVICE ANTARA SAP FICO DENGAN LEGACY SYSTEM PT. POS INDONESIA (PERSERO)
TUGAS AKHIR
Disusun sebagai salah satu syarat untuk kelulusan Program Strata 1, Program Studi Teknik Informatika, Universitas Pasundan Bandung
oleh : Denny Ciska Arisandy NRP : 14.304.0248
PROGRAM STUDI TEKNIK INFORMATIKA FAKULTAS TEKNIK UNIVERSITAS PASUNDAN BANDUNG JULI 2016
LEMBAR PENGESAHAN LAPORAN TUGAS AKHIR
Telah diujikan dan dipertahankan dalam Sidang Sarjana Program Studi Teknik Informatika Universitas Pasundan Bandung, pada hari dan tanggal sidang sesuai berta acara sidang, tugas akhir dari :
Nama : Denny Ciska Arisandy Nrp : 14.304.0248
Dengan Judul : “PEMBANGUNAN APLIKASI DATA INTEGRATOR BERBASIS WEB SERVICEANTARA SAP FICO DENGAN LEGACY SYSTEM PT. POS INDONESIA (PERSERO)”
Bandung, 27 Juli 2016
Menyetujui, Pembimbing Utama,
Pembimbing Pendamping,
(DR. Ayi Purbasari, ST., MT.,)
(Ade Sukendar, S.T)
LEMBAR PERNYATAAN KEASLIAN TUGAS AKHIR Saya menyatakan dengan sesungguhnya bahwa : 1. Tugas akhir ini adalah benar-benar asli dan belum pernah diajukan untuk mendapatkan gelar akademik, baik di Universitas Pasundan Bandung maupun di Perguruan Tinggi lainnya 2. Tugas akhir ini merupakan gagasan, rumusan dan penelitian saya sendiri, tanpa bantuan pihak lain kecuali arahan dari tim Dosen Pembimbing 3. Dalam tugas akhir ini tidak terdapat karya atau pendapat orang lain, kecuali bagian-bagian tertentu dalam penulisan laporan Tugas Akhir yang saya kutip dari hasil karya orang lain telah dituliskan dalam sumbernya secara jelas sesuai dengan norma, kaidah, dan etika penulisan karya ilmiah, serta disebutkan dalam Daftar Pustaka pada tugas akhir ini 4. Kakas, perangkat lunak, dan alat bantu kerja lainnya yang digunakan dalam penelitian ini sepenuhnya menjadi tanggung jawab saya, bukan tanggung jawab Universitas Pasundan Bandung
Apabila di kemudian hari ditemukan seluruh atau sebagian laporan tugas akhir ini bukan hasil karya saya sendiri atau adanya plagiasi dalam bagian-bagian tertentu, saya bersedia menerima sangsi akademik, termasuk pencabutan gelar akademik yang saya sandang sesuai dengan norma yang berlaku di Universitas Pasundan, serta perundang-undangan lainnya.
Bandung, 27 Juli 2016 Yang membuat pernyataan,
Materai 6000,-
( Denny Ciska Arisandy ) NRP. 14.304.0248
i
DAFTAR ISI Halaman LEMBAR JUDUL LEMBAR PENGESAHAN LEMBAR PERNYATAAN KEASLIAN TUGAS AKHIR .................................................................... i ABSTRAK ........................................................................................................................................... iii ABSTRACT ........................................................................................................................................... v KATA PENGANTAR .........................................................................................................................vii DAFTAR ISI ......................................................................................................................................... ix DAFTAR SIMBOL .............................................................................................................................xiii DAFTAR TABEL ..............................................................................................................................xvii DAFTAR GAMBAR .......................................................................................................................... xix DAFTAR LAMPIRAN .....................................................................................................................xxiii BAB 1 PENDAHULUAN ..................................................................................................................1-1 1.1. Latar Belakang .......................................................................................................................1-1 1.2. Identifikasi Masalah ...............................................................................................................1-2 1.3. Tujuan Tugas Akhir ................................................................................................................1-2 1.4. Lingkup Tugas Akhir .............................................................................................................1-2 1.5. Metodologi Tugas Akhir ........................................................................................................1-2 1.6. Sistematika Penulisan Tugas Akhir ........................................................................................1-4 BAB 2 LANDASAN TEORI ............................................................................................................2-1 2.1. Legacy System PT. Pos Indonesia ...........................................................................................2-1 2.1.1. Remittance Service ......................................................................................................... 2-1 2.1.2. SAP (System Application and Product in data processing) ........................................... 2-2 2.1.2.1. SAP FICO ...............................................................................................................2-2 2.1.2.2. SAP Netweaver PI (SAP PI) ....................................................................................2-4 2.1.2.3. Implementasi SAP PI ..............................................................................................2-4 2.2. Web service ............................................................................................................................2-5 2.2.1. Arsitektur Web Service................................................................................................... 2-5 2.2.1.1. SOAP ......................................................................................................................2-5 2.2.1.2. UDDI.......................................................................................................................2-6 2.2.1.3. WSDL .....................................................................................................................2-6 2.2.2. Tipe Web Service ........................................................................................................... 2-6 2.2.3. Big Web Service ............................................................................................................. 2-7 2.2.4. Implementasi Web service dengan Jar Services ............................................................. 2-7 2.2.5. Format Pertukaran Data ................................................................................................. 2-8 2.2.5.1. XML........................................................................................................................2-8 ix
2.2.5.2. CSV ........................................................................................................................ 2-8 2.2.5.3. JSON ...................................................................................................................... 2-9 2.3. Web Service Implementation Methodology .......................................................................... 2-10 2.4. Kakas Penunjang Tugas Akhir............................................................................................. 2-12 2.4.1. Unified Modeling Language (UML) ............................................................................ 2-12 2.4.2. Netbean IDE 8.0........................................................................................................... 2-13 2.4.3. Bahasa Pemrograman Java .......................................................................................... 2-13 2.4.4. Microscroft SQL Server ............................................................................................... 2-13 2.4.5. WSO2 Application Server............................................................................................. 2-14 2.4.5.1. Deploying Jar Services ......................................................................................... 2-14 2.4.6. SOAPUI ....................................................................................................................... 2-14 2.5. Penelitian Terdahulu ............................................................................................................ 2-15 BAB 3 REQUIREMENT ANALISIS DAN DESAIN ....................................................................... 3-1 3.1. Kerangka Tugas Akhir, Skema Analisis dan Tabel Langkah Analisis ................................... 3-1 3.1.1. Kerangka Tugas Akhir ................................................................................................... 3-1 3.1.2. Skema Analisis............................................................................................................... 3-3 3.2. Profil Tempat Penelitian ........................................................................................................ 3-5 3.3. Requirement Web Service ...................................................................................................... 3-6 3.3.1. Identifikasi Proses Bisnis ............................................................................................... 3-6 3.3.1.1. Proses Bisnis Umum untuk Pelaporan Keuangan (Sebelum Integrasi) ................... 3-6 3.3.1.2. Interaksi Proses Bisnis ............................................................................................ 3-7 3.3.1.3. Proses Bisnis Pengumpulan Data Transaksi ........................................................... 3-7 3.3.1.4. Proses Bisnis Pengolahan Data Transaksi .............................................................. 3-8 3.3.1.5. Proses Bisnis Pencatatan Jurnal Transaksi.............................................................. 3-9 3.3.2. Identifikasi Sistem Berjalan ........................................................................................... 3-9 3.3.2.1. Arsitektur Legacy System Remittance Service ...................................................... 3-10 3.3.2.2. Proses Tutupan Legacy System Remittance Service (EOD) .................................. 3-10 3.3.2.3. Pengolahan Data Legacy Remittance Service menjadi Jurnal Transaksi ............... 3-11 3.3.2.3.1. Output Legacy System Remittance Service................................................... 3-13 3.3.2.3.2. Input Sistem SAP FICO (Manual) ............................................................... 3-15 3.3.2.3.3. Mapping Master Data .................................................................................. 3-15 3.3.2.4. Arsitektur Sistem SAP FICO ................................................................................ 3-16 3.3.2.5. Input dan Output SAP PI ...................................................................................... 3-17 3.3.3. Usulan Proses Bisnis .................................................................................................... 3-19 3.3.3.1. Usulan Proses Bisnis Umum untuk Pelaporan Keuangan (Setelah Integrasi) ....... 3-19 3.3.3.2. Usulan Interaksi Proses Bisnis.............................................................................. 3-20 3.3.3.3. Usulan Proses Bisnis Pengumpulan Data Transaksi ............................................. 3-21 x
3.3.3.4. Usulan Proses Bisnis Pengolahan Data Transaksi .................................................3-21 3.3.3.5. Usulan Proses Bisnis Pencatatan Jurnal Transaksi ................................................3-22 3.3.3.6. Usulan Mekanisme Pemprosesan Data ..................................................................3-22 3.3.4. Identifikasi Kebutuhan Integrasi Data .......................................................................... 3-23 3.3.4.1. Usulan Koneksi dan Relasi antar Basis Data .........................................................3-23 3.3.4.2. Usulan Fungsi Legacy System dan SAP FICO untuk diintegrasikan .....................3-25 3.3.4.3. Usulan Mekanisme Integrasi Data .........................................................................3-26 3.3.4.4. Keuntungan yang diharapkan ................................................................................3-27 3.3.5. Requirement Functional Web Service .......................................................................... 3-28 3.3.5.1. Interaksi Fungsional Web Service .........................................................................3-28 3.3.5.2. Skenario ................................................................................................................3-29 3.3.6. Requirement Non-Functional ....................................................................................... 3-31 3.4. Analisis Web Service ............................................................................................................3-32 3.4.1. Kebutuhan Platform ..................................................................................................... 3-32 3.4.2. Arsitektur Web Service................................................................................................. 3-33 3.4.3. Kandidat Web Service .................................................................................................. 3-34 3.4.4. Identifikasi Web Service Interface ............................................................................... 3-34 3.5. Desain Web Service ..............................................................................................................3-35 3.5.1. Desain Web Service Interface ...................................................................................... 3-35 3.5.2. Desain Struktur Kontrol Service Penjadwalan ............................................................. 3-37 3.5.3. Desain Input Penjadwalan ............................................................................................ 3-37 3.5.4. Desain Pemrosesan data ............................................................................................... 3-38 3.5.5. Desain Jar Service ....................................................................................................... 3-38 3.5.5.1. Desain Kelas Diagram ...........................................................................................3-39 3.5.5.2. Desain Sequence Diagram ....................................................................................3-40 3.5.6. Desain Basis Data ........................................................................................................ 3-43 BAB 4 IMPLEMENTASI, PENGUJIAN DAN DEPLOYMENT........................................................4-1 4.1. Pengkodean Web Service ........................................................................................................4-1 4.1.1. Struktur Paket dan Kelas ................................................................................................ 4-1 4.1.1.1. Struktur Paket ..........................................................................................................4-1 4.1.1.2. Struktur Kelas..........................................................................................................4-1 4.1.2. Implementasi Kode Program .......................................................................................... 4-2 4.1.2.1. Service untuk Back-End Handling...........................................................................4-2 4.1.2.1.1. Copy Source Database To Destination Database ...........................................4-2 4.1.2.1.2. Copy SAPPI Md To Destination Database .....................................................4-6 4.1.2.1.3. Copy Source Database To SAPPI Transaction .............................................4-12 4.1.2.1.4. Query Execute...............................................................................................4-17 xi
4.1.2.1.5. Query Open.................................................................................................. 4-20 4.1.2.2. Fungsi Penjadwalan .............................................................................................. 4-22 4.1.2.3. Service untuk Front-End Handling....................................................................... 4-29 4.1.2.3.1. Get Konfigurasi Database ........................................................................... 4-29 4.1.2.3.2. Set Konfigurasi Database ............................................................................ 4-31 4.1.2.3.3. Get Konfigurasi WS Master Data ................................................................ 4-33 4.1.2.3.4. Set Konfigurasi WS Master Data................................................................. 4-35 4.1.2.3.5. Get Konfigurasi WS Transaction ................................................................. 4-36 4.1.2.3.6. Set Konfigurasi WS Transaction ................................................................. 4-38 4.1.2.3.7. Get Status Job .............................................................................................. 4-40 4.1.2.3.8. Kontrol Penjadwalan .................................................................................... 4-41 4.1.2.3.9. Reload Koneksi Database............................................................................ 4-43 4.2. Pengujian ............................................................................................................................. 4-45 4.2.1. Rencana Pengujian ....................................................................................................... 4-45 4.2.1.1. Pendekatan Pengujian ........................................................................................... 4-45 4.2.1.2. Pengujian Fungsional ........................................................................................... 4-45 4.2.1.3. Perangkat Pengujian ............................................................................................. 4-45 4.2.1.4. Skenario Pengujian ............................................................................................... 4-45 4.2.2. Proses dan Hasil Pengujian .......................................................................................... 4-47 4.3. Deployment .......................................................................................................................... 4-60 4.3.1. Spesifikasi Perangkat Pendukung................................................................................. 4-60 4.3.1.1. Spesifikasi Perangkat Keras ................................................................................. 4-60 4.3.1.2. Spesifikasi Perangkat Lunak................................................................................. 4-60 4.3.2. Proses Deployment ....................................................................................................... 4-60 BAB 5 KESIMPULAN DAN SARAN .............................................................................................. 5-1 5.1. Kesimpulan ............................................................................................................................ 5-1 5.2. Saran ...................................................................................................................................... 5-2 DAFTAR PUSTAKA
xii
DAFTAR SIMBOL UML (Unified Modelling Language) Simbol
Keterangan Aktor / actor Orang, proses, atau sistem lain yang berinteraksi dengan sistem informasi yang akan dibuat diluar sistem informasi yang akan dibuat itu sendiri. Aktor Bisnis / business Actor Orang, proses, atau sistem lain diluar organisasi yang berinteraksi atau terlibat dengan proses bisnis Pekerja Bisnis / business worker Seorang pelaku usaha yang ditugaskan untuk satu atau lebih peran bisnis dan berinteraksi didalam proses bisnis
Use Case Fungsionalitas yang disediakan sistem sebagai unit-unit yang saling bertukar pesan antar unit atau aktor. Business Use Case Peran bisnis pada suatu business process sebagai unit-unit yang berinteraksi dengan business worker. Kelas / Class Kelas pada struktur sistem.
Objek dengan garis hidup / object with lifeline Menyatakan objek yang berinteraksi dengan pesan pada sequence diagram.
xiii
Pesan tipe kirim / Send Message Menyatakan bahwa suatu objek mengirimkan data / masukan / informasi keobjek lainnya, arah panah mengarah pada target objek yang dituju. Pesan tipe respon / return Message Menyatakan bahwa suatu objek yang telah menjalankan suatu operasi atau metode menghasilkan suatu balikan ke objek tertentu, arah panah mengarah pada target objek penerima respon.
Status awal / initial state Status awal aktifitas sistem, digunakan pada setiap diagram aktifitas. Aktifitas / Action Aktifitas yang dilakukan sistem atau business worker, biasanya diawali kata kerja. Percabangan / decision Asosiasi percabangan jika ada pilihan aktivitas lebih dari satu.
Penggabungan / merge Asosiasi penggabungan jika ada pilihan aktivitas lebih dari satu.
Penggabungan / join Asosiasi penggabungan dimana lebih dari satu aktivitas digabungkan menjadi satu. Pemecahan / fork Asosiasi pemecahan dimana satu proses dipecah menjadi lebih dari satu.
xiv
Status Akhir / end state Status akhir yang dilakukan sistem, digunakan pada setiap diagram aktivitas. Swimline Memisahkan organisasi bisnis yang bertanggung jawab terhadap aktivitas atau memisahkan grup proses tertentu.
Antarmuka / interface Menunjukan interface dari suatu objek atau kelas, agar tidak mengakses langsung objek sebenarnya. Asosiasi / assosiasion Relasi antar objek dengan makna umum, asosiasi biasanya disertai dengan multiplicity. Asosiasi berarah / directed association Relasi antar kelas dengan makna kelas yang satu digunakan oleh kelas yang lain, asosiasi biasanya disertai dengan multiplicity. Generalisasi / generalization Relasi antar objek dengan makna generalisasi-spesialisasi (umum-khusus). Agregasi / aggegation Relasi antar kelas dengan makna semua-bagian.
xv
DAFTAR TABEL Tabel 2.1 Istilah dalam SAP FICO[SAP05] ........................................................................................2-3 Tabel 2.2 Perbandingan Implementasi “Big” web service dengan RESTful web service[NUG12] .....2-6 Tabel 2.3 Format tabel dari contoh data XML ....................................................................................2-8 Tabel 2.4 Format tabel dari contoh data CSV .....................................................................................2-9 Tabel 2.5 format tabel dari contoh data JSON .....................................................................................2-9 Tabel 2.6 Aktivitas tahap web services requirement [OAS05] ..........................................................2-10 Tabel 2.7 Aktivitas tahap web services analysis[OAS05] .................................................................2-11 Tabel 2.8 Aktivitas tahap web services design[OAS05] ....................................................................2-11 Tabel 2.9 Aktivitas tahap web services coding [OAS05] ..................................................................2-11 Tabel 2.10 Aktivitas tahap web services testing[OAS05] ..................................................................2-12 Tabel 2.11 Aktivitas tahap web service deployment[OAS05]............................................................2-12 Tabel 2.12 Penelitian Terdahulu........................................................................................................2-15 Tabel 3.1 Tabel kerangka Tugas Akhir ...............................................................................................3-1 Tabel 3.2 Langkah analisis ..................................................................................................................3-4 Tabel 3.3 Deskripsi pencatatan jurnal transaksi ..................................................................................3-7 Tabel 3.4 Contoh perbandingan master data antara remittance service dengan SAP FICO...............3-11 Tabel 3.5 Aturan transaksi untuk remittance service pada SAP FICO ..............................................3-11 Tabel 3.6 Aturan global untuk transaksi remittance service pada SAP FICO ...................................3-12 Tabel 3.7 Data dari Backsheet RS-3 (kiri) dan RS-4 (kanan) .............................................................3-13 Tabel 3.8 Field data yang dibutuhkan untuk input aplikasi data integrator ......................................3-14 Tabel 3.9 Field data untuk output aplikasi data integrator ...............................................................3-15 Tabel 3.10 Daftar transformasi data antara format remittance service dengan format SAP FICO. ...3-15 Tabel 3.11 Input dan output WSDL SAP PI jalur transaksi...............................................................3-17 Tabel 3.12 Input dan output WSDL SAP PI jalur master data ..........................................................3-18 Tabel 3.13 Deskripsi pencatatan jurnal transaksi ..............................................................................3-20 Tabel 3.14 Parameter input / output store procedure legacy system ..................................................3-25 Tabel 3.15 Requirement fungtional web service ................................................................................3-28 Tabel 3.16 Definisi use case..............................................................................................................3-28 Tabel 3.17 Definisi aktor ...................................................................................................................3-29 Tabel 3.18 Skenario pengolahan data ................................................................................................3-29 Tabel 3.19 Skenario kofigurasi koneksi ............................................................................................3-30 Tabel 3.20 Skenario pengontrolan penjadwalan ................................................................................3-31 Tabel 3.21 Requirement non-functional - interface requirement .......................................................3-31 Tabel 3.22 Requirement non-functional - performance requirement .................................................3-32 Tabel 3.23 Kebutuhan platform .........................................................................................................3-32 Tabel 3.24 Kandidat web service .......................................................................................................3-34 xvii
Tabel 3.25 Identifikasi web service interface ................................................................................... 3-34 Tabel 3.26 Web service interface...................................................................................................... 3-35 Tabel 3.27 Daftar Variable-code dan replacement-nya .................................................................... 3-38 Tabel 3.28 Gambaran basis data ....................................................................................................... 3-43 Tabel 4.1 Struktur Paket ..................................................................................................................... 4-1 Tabel 4.2 Struktur Kelas ..................................................................................................................... 4-2 Tabel 4.3 Fungsi – fungsi web service.............................................................................................. 4-46 Tabel 4.4 Skenario Pengujian ........................................................................................................... 4-47 Tabel 4.5 Dokumentasi hasil pengujian ............................................................................................ 4-48
xviii
DAFTAR GAMBAR Gambar 1.1 Metodologi Tugas Akhir ..................................................................................................1-3 Gambar 2.1 Gambaran transaksi SAP PI melalui Web Service[FAT14] .............................................2-4 Gambar 2.2 Service-oriented architectures[NAS13]...........................................................................2-5 Gambar 2.3 Web Service Implementation Lifecycle[OAS05] ............................................................2-10 Gambar 2.4 Gambaran alur pembuatan jar service. ..........................................................................2-14 Gambar 3.1 Skema Analisis ................................................................................................................3-4 Gambar 3.2 Proses bisnis umum untuk pelaporan keuangan (sebelum integrasi)................................3-6 Gambar 3.3 Proses bisnis pencatatan jurnal transaksi .........................................................................3-7 Gambar 3.4 Aktifitas pengumpulan data transaksi ..............................................................................3-8 Gambar 3.5 Aktifitas pengolahan data transaksi .................................................................................3-8 Gambar 3.6 Aktifitas Pencatatan Jurnal Transaksi ..............................................................................3-9 Gambar 3.7 Arsitektur legacy system remittance service nasional[TIM10] ......................................3-10 Gambar 3.8 Contoh transaksi wesel dalam negeri (penerimaan) .......................................................3-12 Gambar 3.9 Contoh transaksi wesel dalam negeri (pembayaran) ......................................................3-13 Gambar 3.10 Scann Backsheet RS-3 (kiri) dan RS-4 (kanan) ............................................................3-13 Gambar 3.11 Arsitektur sistem SAP FICO Nasional .........................................................................3-16 Gambar 3.12 Proses bisnis umum untuk pelaporan keuangan (setelah integrasi) ..............................3-19 Gambar 3.13 Usulan proses bisnis pencatatan jurnal transaksi .........................................................3-20 Gambar 3.14 Usulan aktifitas pengumpulan data transaksi ...............................................................3-21 Gambar 3.15 Usulan aktifitas pengolahan data transaksi ..................................................................3-21 Gambar 3.16 Usulan aktifitas pencacatan jurnal transaksi ................................................................3-22 Gambar 3.17 Usulan integrasi data....................................................................................................3-23 Gambar 3.18 gambaran koneksi basis data remittance service dengan basis data perantara .............3-24 Gambar 3.19 Gambaran koneksi basis data remittance service dengan basis data perantara .............3-24 Gambar 3.20 Mekanisme aliran data transaksi ..................................................................................3-26 Gambar 3.21 Mekanisme aliran master data .....................................................................................3-27 Gambar 3.22 Interaksi Fungsional web service .................................................................................3-29 Gambar 3.23 Arsitektur web service .................................................................................................3-33 Gambar 3.24 Detail arsitektur web service ........................................................................................3-33 Gambar 3.25 Desain struktur kontrol service penjadwalan ...............................................................3-37 Gambar 3.26 Kelas Diagram .............................................................................................................3-39 Gambar 3.27 Sequence diagram copy source db to destination db ...................................................3-40 Gambar 3.28 Sequence diagram copy SAPPI md to destination db...................................................3-40 Gambar 3.29 Sequence diagram copy source db to SAPPI trans ......................................................3-41 Gambar 3.30 Sequence diagram query execute .................................................................................3-41 Gambar 3.31 Sequence diagram query open .....................................................................................3-42 xix
Gambar 3.32 Gambaran relasi bagian basis data .............................................................................. 3-43 Gambar 3.33 Gambaran basis data untuk data config ...................................................................... 3-44 Gambar 3.34 Gambaran basis data untuk data feeder remittance service......................................... 3-45 Gambar 3.35 Gambaran basis data untuk data feeder SAP FICO .................................................... 3-46 Gambar 3.36 Gambaran basis data untuk mapping data .................................................................. 3-47 Gambar 4.1 Web service interface copy source db to destination db .................................................. 4-3 Gambar 4.2 Alur proses service copy source db to destination db ..................................................... 4-3 Gambar 4.3 Web service interface copy SAPPI md to destination db ................................................ 4-6 Gambar 4.4 Alur proses service copy SAPPI md to destination db .................................................... 4-7 Gambar 4.5 Web service interface copy source db to SAPPI trans .................................................. 4-12 Gambar 4.6 Alur proses service copy source db to SAPPI trans ...................................................... 4-13 Gambar 4.7 Web service interface query execute ............................................................................. 4-18 Gambar 4.8 Alur proses query execute ............................................................................................. 4-18 Gambar 4.9 Web service interface query open ................................................................................. 4-20 Gambar 4.10 Alur proses query open ............................................................................................... 4-20 Gambar 4.11 Web service interface get konfigurasi database .......................................................... 4-29 Gambar 4.12 Alur proses get konfigurasi database .......................................................................... 4-29 Gambar 4.13 Web service interface set konfigurasi database .......................................................... 4-31 Gambar 4.14 Alur proses set config db............................................................................................. 4-32 Gambar 4.15 Web service interface get konfigurasi ws master data ................................................ 4-33 Gambar 4.16 Alur proses get konfigurasi ws master data ................................................................ 4-34 Gambar 4.17 Web service interface set konfigurasi ws master data................................................. 4-35 Gambar 4.18 Alur proses set konfigurasi ws master data ................................................................. 4-35 Gambar 4.19 Web service interface get konfigurasi ws transation ................................................... 4-36 Gambar 4.20 Alur proses get konfigurasi ws transaction ................................................................. 4-37 Gambar 4.21 Web service interface set konfigurasi ws transaction ................................................. 4-38 Gambar 4.22 Alur proses get konfigurasi ws master data ................................................................ 4-39 Gambar 4.23 Web service interface get status job ............................................................................ 4-40 Gambar 4.24 Alur proses get status job ............................................................................................ 4-40 Gambar 4.25 Web service interface untuk service-service kontrol penjadwalan .............................. 4-41 Gambar 4.26 Alur proses kontrol job ............................................................................................... 4-42 Gambar 4.27 Web service interface reload koneksi database .......................................................... 4-43 Gambar 4.28 Alur proses reload koneksi database .......................................................................... 4-43 Gambar A.1 Setting environment variable (windows) ....................................................................... A-1 Gambar A.2 Test konfigurasi JAVA_HOME menggunakan command prompt ................................ A-2 Gambar A.3 Situs WSO2 AS (download page) ................................................................................. A-2 Gambar A.4 Extract file zipped wso2as ............................................................................................ A-2 xx
Gambar A.5 executable file WSO2 AS ..............................................................................................A-2 Gambar A.6 Login page WSO2 AS Management Console ................................................................A-3 Gambar A.7 Download SQL Server Express 2012 .............................................................................A-3 Gambar A.8 Pilih file installer sesuai kebutuhan ...............................................................................A-3 Gambar A.9 Setting protokol TCP/IP - SQL Server Express 2012 .....................................................A-4 Gambar A.10 Setting IP Addresses - SQL Server Express 2012.........................................................A-4 Gambar A.11 Setting IP Addresses IPALL – SQL Server Express 2012 ............................................A-4 Gambar A.12 Testing login SQL Server Express dengan SQLCMD ..................................................A-5 Gambar A.13 Create user SQL Server dengan SQLCMD ..................................................................A-5 Gambar A.14 Assign role user dengan SQLCMD ..............................................................................A-5 Gambar A.15 Attach basis data dengan SQLCMD .............................................................................A-5 Gambar A.16 Test Login ke SQL Server dan akses basis data dengan SQLCMD ..............................A-5 Gambar B.1 WSO2 AS - Add jar service page .................................................................................. B-1 Gambar B.2 WSO2 AS - Select clases page ...................................................................................... B-1 Gambar B.3 WSO2 AS – Deployed services page ............................................................................. B-2 Gambar B.4 Generate WSDL ............................................................................................................. B-2 Gambar B.5 Isi file WSDL ................................................................................................................. B-2 Gambar B.6 Extract file AAR ............................................................................................................ B-3 Gambar B.7 Upload file AAR ............................................................................................................ B-3 Gambar C.1 Sequence diagram get konfig db .................................................................................... C-1 Gambar C.2 Sequence diagram set konfig db ..................................................................................... C-1 Gambar C.3 Sequence diagram get konfig ws md .............................................................................. C-2 Gambar C.4 Sequence diagram set konfig ws md ............................................................................... C-2 Gambar C.5 Sequence diagram get konfig ws trans ........................................................................... C-3 Gambar C.6 Sequence diagram set konfig ws trans............................................................................ C-3 Gambar C.7 Sequence diagram get status job .................................................................................... C-4 Gambar C.8 Sequence diagram start job ............................................................................................ C-4 Gambar C.9 Sequence diagram pause job .......................................................................................... C-5 Gambar C.10 Sequence diagram resume job...................................................................................... C-5 Gambar C.11 Sequence diagram stop job .......................................................................................... C-5 Gambar C.12 Sequence diagram reload connections ......................................................................... C-6 Gambar C.13 Sequence diagram get system state .............................................................................. C-6 Gambar C.14 Sequence diagram convert output ................................................................................ C-7
xxi
DAFTAR LAMPIRAN
LAMPIRAN A INSTALASI SERVER WEB SERVICE .....................................................................A-1 A. Instalasi .................................................................................................................................A-1 A.1. Instalasi Java Development Kit (JDK) ...........................................................................A-1 A.2. Instalasi WSO2 ..............................................................................................................A-2 A.3. Instalasi SQLServer Express ..........................................................................................A-3 LAMPIRAN B DEPLOYMENT JAR SERVICE ................................................................................. B-1 B.
Proses Deployment ................................................................................................................ B-1 B.1. Deployment Jar Service ................................................................................................. B-1 B.2. Generate WSDL dan AAR ............................................................................................ B-2
LAMPIRAN C SEQUENCE DIAGRAM JAR SERVICE.................................................................... C-1 C.1. Sequence Diagram Get Konfig Db ................................................................................. C-1 C.2. Sequence Diagram Set Konfig Db .................................................................................. C-1 C.3. Sequence Diagram Get Konfig Ws Md ........................................................................... C-2 C.4. Sequence Diagram Set Konfig Ws Md............................................................................ C-2 C.5. Sequence Diagram Get Konfig Ws Trans ....................................................................... C-3 C.6. Sequence Diagram Set Konfig Ws Trans........................................................................ C-3 C.7. Sequence Diagram Get Status Job ................................................................................. C-4 C.8. Sequence Diagram Start Job .......................................................................................... C-4 C.9. Sequence Diagram Pause Job ........................................................................................ C-4 C.10. Sequence Diagram Resume Job ..................................................................................... C-5 C.11. Sequence Diagram Stop Job .......................................................................................... C-5 C.12. Sequence Diagram Reload Connections ........................................................................ C-6 C.13. Sequence Diagram Get System State .............................................................................. C-6 C.14. Sequence Diagram Convert Output ............................................................................... C-7
xxiii
