DESIGN AND IMPLEMENT OF REST API FOR DATA INTEGRATION

Prepared by: Mohd Kamir Yusof

DATA INTEGRATION

Data integration to combine data residing at different sources, and to provide the user with a unified view of these data

DATA INTEGRATION MODEL

Data Integration System

Unified View

Figure 1. Data Integration Model

EXISTING MODEL

PROBLEM?

• Less practical - data integration - two different system using different platform or programming language
• Any solution?

REST API

• Application programming interface that conforms to the constraints of REST architecture.
• Replace a Simple Object Access Protocol (SOAP) or Remote Procedure Call (RPC)
• Used by Google, Facebook and Twitter

DATA REPRESENTATION

Use JSON (JavaScript Object Notation) data

{

"name":"John", "age":30, "car":null

}

​

METHODOLOGY

REST API has been developed to allow other system/application send/receive data to another system/application

System A

System B

REST API

Data source

Data source

METHODOLOGY…

EXTRACT DATA

Data from database will be extract and convert into JSON format.

​

Definition 1:

Assume B represent dataset of JSON format, B = {D₁, D₂, D₃, D_n} where D₁ until D_n is element of B.

​

Definition 2:

Assume C represent dataset of D, C = {a1, a2, a3, an} where a1 until an is element of C.

​

SEND DATA

​

Input: Data in JSON format, B

Process:

Step 1: Assign a new end point of URL, EP Step 2: Map R = B → EP

Step 3: Response message from EP

Output: Response message (MSG) and set of JSON data (R)

​

Figure 2. Send data using REST API algorithm

RECEIVED & DUMP DATA

Input: R and MSG

Process:

Step 1: Fetch the data in JSON format, R

Step 2: Explode the data in array format

Step 3: Assign data to item set, I = {data₁, data₂, data_n}

Step 4: Dump I into database

Step 5: Repeat Step 1 until Step 5

Step 6: Assign MSG equal to S if success (S) Else assign MSG equal to fail (F)

Step 7: Response message to SAP system

Output: MSG

Figure 3. Send data using REST API algorithm

IMPLEMENTATION

Communication between SAP and FEMS via REST API

SAP

FEMS

REST API

Data source

Data source

EXTRACT DATA…

Extract Data:-

Data from SAP will be extracted and convert into JSON format

B = {Purchase Order, Sales Order, …}

Purchase Order = {EBLEN, LIFNR, BEDAT, ….}

Sales Order = {VBELN, KUNNR, BSTD_E, …}

​

JSON FORMAT

SEND DATA

• JSON will transfer to FEMS system by declaration of end point (specified URL).
• Let end point (EP) of URL in FEMS system is https://myfems.net/get-data.php.
• Assign data in JSON format, R = B → EP.
• Then data set of data, R will be transferred automatically to end point of FEMS system

RECEIVED & DUMP DATA

RESULT

Response time

RESULT

Response time

CONCLUSION

• REST API is one the alternative solution can be used to data exchange between two different system using different platform.
• In future work, this research will extend to compared with another REST API using different data format such as XML, TEXT, etc.