-
Products
- Solutions
- Pricing
- Free Trial
- Resources
-
Insights
- Blog
-
SAP Data Models
>
- SAP FI/CO Table Relationships - Interactive Data Model Diagram
- SAP SD Table Relationships - Interactive Data Model Diagram
- SAP Inventory Management Table Relationships - Interactive Data Model Diagram
- SAP Purchasing Table Relationships - Interactive Data Model Diagram
- SAP PP Table Relationships - Interactive Data Model Diagram
- SAP QM Table Relationships - Interactive Data Model Diagram
- SAP PM Table Relationships - Interactive Data Model Diagram
- SAP WM Table Relationships - Interactive Data Model Diagram
- SAP HCM Table Relationships - Interactive Data Model Diagram
- SAP PS Table Relationships - Interactive Data Model Diagram
- Demos & Recordings >
- Webinars
- Events
- Contact Us
DVW Flow Tool
The workflow platform built for SAP. Read, transform, and write SAP data across 20+ analytics platforms and cloud services.
The DVW Flow Tool is a standalone data preparation, transformation, and orchestration platform. It reads data from SAP, applies over 100 built-in transformation and cleansing operations, and delivers output to more than 20 analytics platforms, cloud data services, and business applications. Microsoft Fabric integration is included in the base licence.
Free 30-day trial. Full functionality. No commitment.
Free Trial | Demos | Pricing
Platform overview: extract SAP data once and deliver it in parallel to Excel, Power BI, Snowflake, Databricks, and more through a single low-code workflow.
Data preparation, orchestration and delivery with SAP data
The DVW Flow Tool extracts, prepares and delivers SAP data to 20+ target platforms. No manual exports, no staging databases, no ABAP development required.
SAP data is extracted, prepared and delivered on a scheduled or on-demand basis. Write capabilities are available via add-ons.
Read and write access to a Microsoft Fabric Lakehouse requires an active DVW Flow Tool Server licence.
Works with the SAP systems you already use
Connect SAP ECC, S/4HANA, and 20+ other SAP products for data preparation and delivery to your target platforms.
Don't see your SAP system here? Contact our team to check if your SAP system is covered.
Works across your data landscape
Deliver prepared SAP data to cloud platforms, databases, analytics tools and file formats. The DVW Flow Tool connects SAP to 20+ target platforms.
Premium cloud platform integrations require an active DVW Flow Tool Server licence.
† Microsoft Fabric Lakehouse is a standard non-SAP target and source. Read and write access to a Fabric Lakehouse requires an active DVW Flow Tool Server licence.
SAP change capture, event-driven or scheduled
Get SAP changes the moment they happen, or pull scheduled deltas on your own cadence.
The DVW Flow Tool captures SAP changes at the application layer. Have changes pushed to you within seconds of the business event, or read scheduled deltas when near-real-time is not required. There are no database triggers, no log-mining and no replication layer. Every read uses standard SAP interfaces and respects your SAP authorizations.
Event-driven extract flows
SAP pushes to the Flow Tool the moment a business event fires, using SAP's own Business Transaction Events framework. The matching extract flow runs within seconds, with no polling and no nightly batch.
Change-document delta
For master data and transactional changes where a scheduled delta is enough, the Flow Tool reads SAP change documents (CDHDR and CDPOS) and extracts only what changed since the last run.
Timestamp and BW request-ID windows
For tables without change-document coverage, and for BW delta, the Flow Tool tracks timestamp and request-ID watermarks to pull only new and changed records.
How event-driven capture works. A lightweight handler registered in SAP's standard framework calls the Flow Tool the moment a configured business event fires. You choose which events matter, from a financial posting to a sales order to a goods movement, and almost any other event SAP raises. The Flow Tool then reads the related records through standard SAP interfaces, transforms them, and writes them to your chosen destination. The handler returns immediately, so it never slows down the user who hit save.
Available on SAP ECC and SAP S/4HANA (on-premise and Private Edition / RISE). Event-driven capture is near-real-time, not sub-second replication.
Technical specifications
Full read, write and delivery capability detail for technical evaluators.
The DVW Flow Tool supports the extract of data from a wide range of SAP sources including:
- SAP Tables & Views - Extract data from SAP Tables (Transparent / Pooled / Clustered) and SAP Views. Search for SAP Tables and related SAP Tables. Select fields to be extracted from a complete list of Table fields incl. custom fields. Apply Filters to the SAP Table data to be extracted.
- SAP Transactions (T-Codes) & Reports - Extract data from standard and custom SAP Transactions (T-Codes) and Reports (ABAP Reports). Utilise existing Transaction and Report Variants. Select fields to be extracted. Apply Filters to the SAP data to be extracted.
- SAP Queries - Works with SAP Queries (Transaction SQVI / SQ01 / SQ02 / SQ03). Search for SAP Queries. Select fields to be extracted from the SAP Query. Apply Filters to the SAP Query data to be extracted.
- SAP Spool - Works with standard and custom SAP Transactions and Reports that provide the ability to "Execute and Print" and "Execute in Background". Access SAP Spool Jobs linked to user's SAP User Name.
- SAP OData - Search for SAP OData services. Select fields to be extracted from the OData service. Apply Filters to the SAP OData data to be extracted.
- SAP Attachments - Extract attachments from SAP Transaction Data and SAP Master Data. Supports any SAP supported MIME type format including texts, images, audio, video and applications such as PDF, MS Word, MS Excel, MS PowerPoint etc.
- SAP Long Text - Extract SAPscript texts from SAP Transaction Data and SAP Master Data. Supports any SAPscript Text Object and Text ID.
- SAP BW - Extract data from SAP BW Queries & SAP BW Query Views. Extract data from SAP BW InfoProviders (InfoCubes, MultiProviders, Composite Providers, InfoSets, DSO, ADSO, InfoObjects acting as InfoProviders). Extract SAP BW Hierarchy data in an optimised flat tabular format. Extract SAP BW Text for any SAP BW InfoObject.
- SAP HANA Views - Extract data from SAP HANA CDS Views, Calculation Views, Attribute Views and Analytical Views. Search for SAP HANA Views. Select fields to be extracted. Apply Filters to the SAP HANA View data to be extracted.
- SAP Analytics Cloud - Extract data from SAP Analytics Cloud objects.
- SAP Business ByDesign - Extract data from SAP Business ByDesign via OData services.
- SAP BAPI (Add-On) - Search for standard and custom SAP BAPIs. Select SAP BAPI tables and fields to be included in extract. Apply Filters to the SAP BAPI extract. Automatically format the SAP BAPI extract output.
The DVW Flow Tool uses SAP BAPI, SAP IDoc, SAP OData and SAP Analytics Cloud write capability to support the load, creation and update of SAP Master Data (e.g. Customer, Material), SAP Transaction Data (e.g. Sales Order, G/L Journal Entry), SAP BW InfoProvider Data, and SAP Analytics Cloud Data.
- SAP BAPI Write (Add-On) - Load data from DVW Flow Tool workflows directly into SAP using SAP BAPIs or SAP RFC-enabled Function Modules. Supports use cases including creation of Sales Orders, Purchase Requisitions, posting Goods Movements, posting G/L Documents.
- SAP IDoc Write (Add-On) - Load data from DVW Flow Tool workflows directly into SAP using IDoc (Intermediate Document) technology. Supports data migration for SAP S/4HANA, loading and update of Master Data and Transaction Data.
- SAP OData Write (Add-On) - Load data from DVW Flow Tool workflows directly into SAP S/4HANA Cloud via OData services.
- SAP Analytics Cloud Write (Add-On) - Write data to SAP Analytics Cloud objects from DVW Flow Tool workflows.
The following non-core SAP products are available as Add-Ons to the DVW Flow Tool. Add-Ons require an active DVW Flow Tool Server licence.
- SAP Integrated Business Planning (IBP) (Add-On) - Read data from and write data to SAP IBP Planning Areas.
- SAP SuccessFactors (Add-On) - Read data from and write data to SAP SuccessFactors using SAP OData. Works with SAP SuccessFactors modules including Employee Central, Compensation, Onboarding, Performance & Goals, Recruiting, Succession & Development.
- SAP Customer Experience (CX) (Add-On) - Read data from and write data to SAP Cloud for Customer, SAP Sales Cloud, SAP Service Cloud and SAP Marketing Cloud.
- SAP Ariba (Add-On) - Read data from SAP Ariba Analytics Procurement and Sourcing Reports.
Deliver SAP data directly to leading cloud data platforms with premium connectors:
- Databricks Connector (Premium) - Deliver SAP data directly to Databricks. Build AI-ready SAP data pipelines for your ML teams. Requires active DVW Flow Tool Server licence.
- Snowflake Connector (Premium) - Deliver SAP data directly to Snowflake. Load structured SAP data for analytics, reporting and ML workflows. Requires active DVW Flow Tool Server licence.
The DVW Flow Tool delivers prepared and transformed SAP data to a wide range of platforms and formats:
- Databricks (Premium Add-On)
- Snowflake (Premium Add-On)
- Microsoft Fabric
- Microsoft Fabric Lakehouse (requires DVW Flow Tool Server licence)
- Azure Blob Storage
- Azure Data Lake
- Power BI & Power BI Service
- Power Apps Dataverse
- SharePoint
- Excel
- SQL Databases
- ODBC
- SAS
- SPSS
- Tableau
- CSV
- JSON
- XML
- Parquet
- HDF
- TXT
The DVW Flow Tool enables organizations to deliver SAP data to analytics and AI platforms for advanced analytics, reporting and machine learning workflows. Structured SAP data can be combined with non-SAP sources and prepared for delivery to your chosen analytics platform.
Typical use cases include:
- Delivering SAP data to Microsoft Fabric for analytics, reporting and AI
- Reading and writing SAP data to a Microsoft Fabric Lakehouse for analytics, AI and downstream Fabric workloads
- Building AI-ready SAP data pipelines into Databricks for ML teams
- Loading structured SAP data into Snowflake for analytics and ML workflows
- Automating extract and preparation of SAP data for recurring analytics workflows
- Combining SAP data with non-SAP sources before delivery to analytics platforms
- Writing model outputs and analytical results back to SAP
SAP data is extracted and transformed by DVW Flow Tool, then delivered directly to your chosen analytics platform on a scheduled or on-demand basis. Model outputs can be written back to SAP using the DVW Flow Tool write capabilities.
The DVW Flow Tool is a standalone data preparation and orchestration platform designed for SAP data delivery and transformation.
- Standalone platform - no installation on SAP required
- Connects SAP to 20+ non-SAP platforms, interfaces and file types
- Schedule workflows with DVW Flow Tool Server
- No staging of data required
- Use multiple SAP systems in a single workflow
- Respects user's SAP authorisations
- Designed to optimise extract of large data volumes
- Delta loads supported
- Uses standard SAP APIs
- Premium integrations available for Databricks and Snowflake
Premium cloud platform integrations
Deliver SAP data directly to leading cloud data platforms with premium connectors designed for enterprise-scale data pipelines.
Premium cloud platform integrations require an active DVW Flow Tool Server licence. Contact our team for pricing and availability.
Microsoft Fabric Lakehouse is also Server-licensed but is included as a standard destination, not a premium-priced connector. See the standard destinations list above.
Key features of the DVW Flow Tool
Try it free for 30 days
Full functionality. No commitment. Trusted by 500+ DVW customers worldwide.
Start your DVW Flow Tool trial
30-day free trial. Takes less than a minute.
Thank you for registering
We're setting up your DVW Flow Tool trial. Check your inbox for login details — they'll be with you shortly.
Not ready to install today?
Have a look at the product first, or talk to us about your use case.
|
Products
|
Resources & Insights
Solutions
|
Company
|
Get started
DVW Analytics gives business users and technical teams direct read and write access to SAP data from Alteryx, KNIME, Dataiku, Power BI, Databricks, Snowflake, and more. Trusted by 500+ organizations worldwide.
|
|
© COPYRIGHT 2003 - 2026 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.
|
SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.