Skip to Content
avatar image
Former Member

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

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.

Thanks,

Alex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 06 at 08:57 AM

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

    Add comment
    10|10000 characters needed 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!