MS SQL to ABAP Proxy (BW)

[Former Member]

Hi,

I have a scenario where i call a stored procedure to MS SQL DB which returns me a huge resultset of 17.4 MB size. I also have to convert 2 fields before i send it to BW via ABAP Proxy.

I do a lookup to another conversion db for converting thoe 2 fields.

Please suggest me how best i can handle such a huge resultset and optimize the lookup.

regards,

Siva

[Former Member]

Devireddy,

Go through the below urls which explains you how to optimize your lookups and step by step procedure for how to JDBC Stored procedures:

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/people/sap.user72/blog/2005/12/08/integration-builders-through-proxy-server-part--1

/people/sap.user72/blog/2005/12/13/integration-builders-through-proxy-server-part--2

If you further have any specific questions get back to us on SDN.

Regards,

---Mohan