Search code examples
wso2wso2-data-services-serverwso2-esb

WSO2 ESB DSS Integration, sending multiple records to DSS

i have requirement where in i have to insert multiple values from ESB 4.8.1 into Oracle Database table via WSO2 DSS.

Oracle DB table (Student) consists of below fields

1) Id
2) Name
3) Class
4) School Name

  • ESB will receive a SOAP request which consists of 200 student records with above fields, here range is 200 which may vary.

  • In ESB i will extract the 200 record values(200 student details), let say 200 insert statements.

  • From ESB how i can send these 200 record values to DSS in a single SOAP request, so that DSS will take care of inserting 200 records into DB.

Can DSS receive SOAP Request which contains multiple records (200 students details) and insert into DB.?

Looking forward for the necessary help

Solution

  • Yes, it´s possible. In the data service configuration just add: enableBatchRequests="true".

    Take a look at https://dzone.com/articles/wso2-dss-batch-insert-sample