Announcing the Fivetran dbt™ package for SAP

Use our latest dbt package to recreate your SAP extractor models and better understand your performance.
August 25, 2023

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 package 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.

That’s why we built this package. Providing this replication of extractor reports that you see within SAP’s UI saves time for your data team to rebuild the necessary reporting, allowing them more time to focus on gathering insights. These models build on top of our Fivetran connector loaded data, allowing you to extend your existing reporting by retaining the initial field naming. This 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.

How Fivetran helps our SAP customers

These models work in tandem with Fivetran's SAP connectors, like HVR SAP Netweaver, HVA SAP ECC or SAP ERP on HANA 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.

We are planning to build out additional models that will serve all the extractor reports, so we'd love your feedback to improve upon our initial build of the dozen extractor reports that make up this first package version!

Download the SAP package here.

Accelerate your time to insight

No matter your source or your use case, Fivetran is here to help. Our 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.

[CTA_MODULE]

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Product
Product

Announcing the Fivetran dbt™ package for SAP

Announcing the Fivetran dbt™ package for SAP

August 25, 2023
August 25, 2023
Announcing the Fivetran dbt™ package for SAP
Use our latest dbt package to recreate your SAP extractor models and better understand your performance.

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 package 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.

That’s why we built this package. Providing this replication of extractor reports that you see within SAP’s UI saves time for your data team to rebuild the necessary reporting, allowing them more time to focus on gathering insights. These models build on top of our Fivetran connector loaded data, allowing you to extend your existing reporting by retaining the initial field naming. This 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.

How Fivetran helps our SAP customers

These models work in tandem with Fivetran's SAP connectors, like HVR SAP Netweaver, HVA SAP ECC or SAP ERP on HANA 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.

We are planning to build out additional models that will serve all the extractor reports, so we'd love your feedback to improve upon our initial build of the dozen extractor reports that make up this first package version!

Download the SAP package here.

Accelerate your time to insight

No matter your source or your use case, Fivetran is here to help. Our 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.

[CTA_MODULE]

Related blog posts

How we execute dbt™ runs faster and cheaper
Data insights

How we execute dbt™ runs faster and cheaper

Read post
Wizard for dbt Core™ VSCode extension now available for Snowflake
Product

Wizard for dbt Core™ VSCode extension now available for Snowflake

Read post
Pack up the stored procedures and move to modernize
Data insights

Pack up the stored procedures and move to modernize

Read post
No items found.
How the modern data stack powers real-time decisions at CHS
Blog

How the modern data stack powers real-time decisions at CHS

Read post
Introducing Alation’s Fivetran OCF connector
Blog

Introducing Alation’s Fivetran OCF connector

Read post
Fivetran celebrates triple win with tech partner awards
Blog

Fivetran celebrates triple win with tech partner awards

Read post

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.