Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Schema Blocking on SAP ERP HANA connector

Answered
Deniz Keskin User

SAP ERP HANA connector with hybrid deployment

The schema blocking feature that is available for different connectors according to this link

https://fivetran.com/docs/using-fivetran/features/data-blocking-column-hashing/config#configuredatablockingandcolumnhashing

This is currently not available for SAP ERP HANA connector with hybrid deployment and needed to get more control over table replication and MAR generated

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Edwin Fivetranner

    Hi Deniz, 

    I'm unsure how the schema-blocking feature would give you control over MAR. We explicitly decided to selectively choose the tables that customers want to source from SAP rather than sourcing all tables. A default S/4HANA or SAP ECC schema contains over 140,000 tables. We don't want to add new tables automatically. Hashing is available on SAP columns but will not impact MAR.

  • Deniz Keskin User

    Hello Edwin,

    Yes we have to select the needed tables in the connector. I understood that when new collumn are generated this will automatically picked up and added to the table.

    In some cases we might not want this (on big tables) as this will lead to an increase in MAR. Schema blocking prevents new collumns to be added automatically and therefore more control of MAR consumption.

    Thanks
    Deniz