cancel
Showing results for 
Search instead for 
Did you mean: 

Question on JDBC Adapter

Former Member
0 Kudos

Hi,

Assume that i have a scenario where in I need to update some data in MS SQL from SAP.

For instance, some one pushed junk data from SAP,(but this data is matching to our XML structures) and before I update this data in MS SQL, i need to validate data by connecting through JDBC adapter.

Now when I connect to database using JDBC, is it possible for me to validate the data in the adapter and if data is invalid, how can I update the IDoc status in the adapter or notify Integration Engine that data is erroneous?

Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You can do that using BPM. First send the data from SAP, create a BPM to receive the data, make a synch call to your database and validate the message and either update the message or trigger an alert based on the response.

regards

Shravan

Former Member
0 Kudos

Hi Shravan,

Thanks.

Did you come across any webblogs on this topic/similar to this?

Regards

Former Member
0 Kudos

You have a conditions editor option in your receiver determination, where you can do some basic validation using XPATH queries, before you send your data to your final receiver.

cheers

Sameer