🎉 New dbt SAP package! 🎉
This is the initial release of the SAP package!
📣 What does this dbt package do?
- Provides recreations of the SAP extractor models to enable you to better understand your SAP data. The package achieves this by performing the following:
- Brings in essential master attribute tables like Company Code (
sap__0comp_code_attr), Customer Master (sap__0customer_attr), Employee (sap__0employee_attr), G/L Account Number (sap__0gl_account_attr), Material Data (sap__0material_attr), and Vendor Number (sap__0vendor_attr). - Brings in general ledger models like General Ledger: Balances, Leading Ledger (
sap__0fi_gl_10) and Line Items Leading Ledger (sap__0fi_gl_14). - Brings in master text models like Company Code (
sap__0comp_code_text), Company (sap__0company_text), and Vendor (sap__0vendor_text).
- Brings in essential master attribute tables like Company Code (
- Produces modeled tables that leverage SAP data from Fivetran's SAP connectors, like LDP SAP Netweaver, HVA SAP ECC or SAP ERP on HANA and build off the output of our SAP source package.
- Generates a comprehensive data dictionary of your source and modeled sap data through the dbt docs site.
- Currently the package supports Postgres, Redshift, BigQuery, Databricks, and Snowflake. Additionally, this package is designed to work with dbt versions [">=1.3.0", "<2.0.0"].
For more information, refer to the README.
Submit any feedback you have here in our survey, post in our Fivetran dbt community with questions you might have, or submit any issues you encounter with our package within Github if you need any additional help!