Our latest dbt™ data model for SAP replicates common SAP extraction reports to help enterprise customers better understand and analyze their business critical data. These models include all the primary master data extractor reports and some financial extractor reports.

This Quickstart Model includes:

• For customers wanting their master data extractor reports, we've brought in essential master attribute and master text tables used by most customers, including Company Code, Customer, Employee, G/L Account Number, Material Data and Vendor.
• For customers wanting transaction data, we've recreated general financial extractor reports like General Ledger: Balances, Leading Ledger and Line Items Leading Ledger.

Unlocking the power of your SAP data

SAP reporting is very challenging to build and construct. But, it often holds business-critical data. Whether you’re trying to analyze your financials, business operations or inventory logistics — you need access to clean, analytics-ready data. This, however, is difficult when you can’t centralize and easily customize your SAP data.

How Fivetran helps our SAP customers

These models work in tandem with Fivetran's SAP connectors, like HVR SAP Netweaver, SAP ERP on HANA or HVA SAP ECC and build off the output of our SAP source package. When you deploy these models with your chosen dbt tooling, you immediately turn loaded SAP data into analytics-ready tables. If you choose to use Fivetran Transformations for dbt Core™ you can manage and orchestrate the model runs sequentially with your connector load. Both provide the same output tables in your destination. 

Providing this replication of extractor reports that you see within SAP’s UI saves your data team from having to rebuild the necessary reporting, allowing them more time to focus on gathering insights. These models allow you to extend your existing reporting by retaining the initial field naming, which prevents any current reporting from breaking and ensures you can utilize our models more easily. We've also built out robust documentation of field definitions so your entire team can understand the translation between the SAP field conventions and their intended business descriptions.

Accelerate your time to insight

Our Quickstart data models perform the foundational modeling work for you, so you can focus on more advanced analysis. Those models or custom database transformations can then be orchestrated and managed using our automated Fivetran Transformations for dbt Core™ or your preferred dbt tooling, like dbt Cloud. No matter how you choose to deploy our solutions, our two platforms work better together.

Download the SAP package here!

[CTA_MODULE]