BODS to BW4HANA ADSO Peformance Issue

[former_member801855]

Hi All,

I am trying to load data from BODS directly into BW4HANA ADSO (write-interfaced enabled). While loading 1000000 records into ADSO directly, the job is taking 44 min to complete but while loading into the template table the Job is taking 2 min only.

Could you please help, how I can increase the Job performance while loading data directly into the ADSO inbound table.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

• Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

[denise_meyer]

Please read through the performance guide for assistance. Or engage consulting to help improve the performance in your environment -

https://help.sap.com/docs/SAP_DATA_SERVICES/5d0c467218d5489791d04ced984a8f89/73f20cb6ea5b4d4abe433d5...

Thanks,
Denise
SAP Support