JDBC sender adapter - Real time scenario

[Former Member]

i am trying to retrieve small amount of data from oracle tables as such as real time means less time interval.

If i read the oracle table everytime, is there any performance issue arise ? Client 's question is if PI is reading everytime ?

Regards,

Vasudeva

[Former Member · Accepted solution]

My Scenario Sender JDBC -Receiver RFC

And i need to update flag as i read the record from table.

So how can i configure sender JDBC to get the update back ( Flag) - Sync/async ?????

What are the steps required ?

[prasanna_shanmugasundaram · Accepted solution]

There is an option/field in the sender JDBC adapter. It will be last filed in the section where you type your "Select * from " statement. If you dont need to update any filed you can enter "<test> in that field. Or else write a proper "Update" statement in the same.

eg. Update table <tableName>.. or what ever it is like.

Thanks

Prasanna

[Former Member · Accepted solution]

OK. I WANT TO KNOW ? HOW CAN I UPDATE THE FLAG ? JUST CONFIGURATION OR MESSEAGE MAPPING ALSO REQUIRED ?

[former_member208856 · Accepted solution]

In Async, you can do this, there is no need to Sync.

When you are picking data (Using JDBC Sender Communication Channel) from table using Select Statement, On Processing Tab, there is one option "QUERY SQL STATEMENT", you will write your Select here

like this

Select a, b, c from abc where flag = 'N".

Now for UPDATE Statement, there is one option "UPDATE SQL STATEMENT"

you will write your update flage query here

like this

UPDATE abc SET Flag = "Y" where flag = "N".

[Former Member · Accepted solution]

Thank you sandeep.

Am i required to do messeage mapping also to update flag status ?

[former_member208856 · Accepted solution]

Your Scenario is JDBC Sender, you will pick data from Tables using JDBC Sender & SQL Statement, when you are picking data, at the same time your are updating flag.

Now data is in the table, you need to pass it to your RFC, you will pass required data in RFC function module, but for updating your SQL table, there is no need to use SYNC message or any message mapping.

Only message mapping is required at the time, when you are passing Sender Data to Target RFC.

[Former Member · Accepted solution]

Not required to do any message mapping to update the flag status. Need to write in Update SQL statement.

Thanks,

[prateek]

Suppose you use the polling interval as 60 seconds. Then in the standard configuration, PI stay connected to the database all the time and the next polling will also happen in the same connection session. This will continue forever unless the system is disconnected for some reason.

If you wish to avoid this behavior, then use option "Disconnect from Database After Processing Each Message" in sender JDBC channel which ensure that the connection to database is terminated after each poll interval.

Regards,

Prateek

[Shabarish_Nair]

there should not be any problem.

What is the amount of data being read? also what is the polling intervals?

[Former Member]

Its may be 500 records .

[former_member208856]

you have to pick 500 records in one time & flag that 500 records as (READ).

Now when you will go to read new data again, you will read new records which are UNFLAGED.

There will not be any performance issue.

[Former Member]

Hi,

There would not any performace issue.

Use the Update SQL statement parameters:

Enter a valid SQL statement that is to be applied to the database once the data (determined from the Query SQL Statement) has been successfully sent to the Integration Server/PCK.

It must be an INSERT, UPDATE, or DELETE statement.

Thanks,

Edited by: Hareenkumar on Aug 3, 2010 12:12 PM

[Former Member]

Hi Vasudeva,

There would not be any performance issue.

Use the paramter " Update SQL Statement". then it will not read the data which is already done.

Please refer the weblink below for configuring sender JDBC adapter.

http://help.sap.com/saphelp_srm40/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm