Bulky message in XI

[Former Member]

Hi,

I have a scenario where JDBC sender gives be a close to 30 mb resultset once a month. How can i efficiently handle this.

How can i somehow schedule the Sender JDBC adapter.

[bhavesh_kantilal · Accepted solution]

Siva,

If what I understood is correct, you want to schedule your JDBC adapter to run once a month. Unfortunately, <b>there is no way to schedule an ADAPTER</b> for the moment in XI.

You will have to look at work arounds for the same.

Regards,

Bhavesh

[Former Member]

Thanks All,

My sender is the MS SQL DB and receiver is BW system.

its JDBC Sender to ABAP Proxy to BW. The problem is that the data is only available after 4th and cant poll it every week, only on 4th.

[moorthy]

Hi Siva,

Options-

1) Make the Polling Interval of the Sender JDBC adapter in such a way that it is polled once in a week..instead of per month SO that you may get smalles chunks of data from the Table.

2) If there is a chance, to redesign with ABAP proxy instead of Sender JDBC adapter, you can really thik on this.. Because this is good comapred to use Sender JDBC adapter.. In sender JDBC adapter you have a concern of Security also right ...?

Hope this helps,

Regards,

Moorthy

[Former Member]

Hi,

Split the data and send it in small chunks, I guess thats the only solution.

Thanks,

Prateek

[Former Member]

Please can somebody suggest the optimal solution for 30 mb resultset from JDBC sender..

Siva