jdbc sender adapter

[Former Member]

using jdbc sender adapter i need to access SQL Server Database.

we have stored procedure which returns two fields with values.

once stored procedure gets executed, how to retrieve the values from the result set and pass to tgt structure.

do i need write code in UDF, if yes what needs to be written?

[Former Member]

Hi Viswanath,

I don't think you can invoke Stored Procedure from your Sender JDBC Adapter.

thanks

amit

[Former Member]

my business requirement is

we have two fields, empid and code (30,000 records) stored in a table on sender side, they need to be sent to ECC daily.

we have stored procedure in place already on sender side, if we can not retrive the values from result set and pass to tgt strcture.

Then do I need to write a SQL query which gives all the empid & codes.

1) how to retrieve these and pass it to target structure.

2) can XI handle 30,000 records at a time

3) do i need to wrtie an UDF or java class

[Former Member]

Hi,

This much data size should be possible. The other option is extract the records in batch and then map it to the target structure.

thanks

amit

[VijayKonam]

You can call the stored procedure using the EXECUTE statement on the channel. Return the data from the SP as dataset or recordset. It will be automatically converted to flat row strucuture that Sender channel normally returns.

VJ

[Former Member]

1) how to retrieve these values and pass it to target structure.

2) What needs to be written in UDF or Java Class

[VijayKonam]

nothing. If you read the documentation for the jdbc sender, the strucuture is a flat one. just map it directly to your target fields. No UDF or java mapping is needed unless you have to implement some logic.

VJ