JDBC to JDBC

[Former Member]

Hi all,

I am doing jdbc to jdbc scenario, my scenario is like this:

I got two databases, i need to read the table from first database and send it to XI, after that i need to check the record is exist in one of the table in second database, if that record exist i need to write it to another table in second database.

In reciiver jdbc adapter configuration is it possible to validate one table and write it to another table?

Answer will be rewarded

Prasad

[Former Member · Accepted solution]

Hi Prasad,

2 options.

1. Use a SP and do the validation there and insert it in the correct table.

2. Use a BPM.

Steps in BPM.

1. Receive (Asynch) - Msg from DB1.

2. Send (Synch) - Do a select on table1 in DB2.

3. Switch (Do a check on the response from DB2) - 2 branches

4. Send (Asynch) in each branch to send it to the desired table.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi Jai

Can you please tell me what is SP in your answer

Prasad

[Former Member · Accepted solution]

>>>Can you please tell me what is SP in your answer

Stored Procedure

Regards,

Jai Shankar