PT XYZ has an Enterprise Resource Planning application that is used by the Planning Department to view stocks and plan production materials. Currently calculation of production materials takes more than 30 seconds just to export to Excel then a few minutes to adjust the data format to the planning form and the data used is not real-time. Each item needs to be calculated one by one per period, then the size of the Excel file used varies according to the time period and requires more storage. To support real-time integration and process efficiency planning and storage reduction, an integration between Enterprise Resource Planning application and web applications has been made using a Service Oriented Architecture approach. The Web service uses RESTful and has been tested using Quality of Service and the Vulnerability Test. Based on the test results using the Jmeter simulation with 10 users, it is obtained Latency 1.2 seconds and Load Time 1.2 seconds with an average amount of data sent 1280.73 bytes. The test results using OWASP ZAP show vulnerability to the web service header made from the web server version used by PHP version 5.6.40. With the results of these tests, the web service is able to replace the export and import process as well as create real-time data connectivity and replace storage media with databases, thereby reducing the time needed for planning activities.