Skip to Content

SAP BODS Unable to do pushdown query with HANA source and target (same schema and datastore)

Apr 05 at 05:30 AM


avatar image
Former Member

As mentioned in the heading. I am unable to do a complete pushdown in BODS between two HANA tables with in the same schema/datastore.

I created two test tables with just 4 columns and when doing a direct connection without a query transform, I still couldn't get a full pushdown.

Is there something that needs to be checked.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Apr 06 at 08:57 AM

Do you have bulk load enabled in the target table? Switch it off and try again.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Dirk, that did the trick. I did do this earlier, but it didn't do a pushdown for some reason. Now I just recreated the flow again with 'delete before load' before I saved it and it did a pushdown.

Thanks again!

Good Day!