Skip to Content
author's profile photo Former Member
Former Member

Question on JDBC Adapter

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,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 02:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 02:38 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.