SAP Data Workflow Platform|DVW Flow Tool
One SAP extract, delivered to every platform your teams use
Read data from SAP ECC, S/4HANA, BW and 20+ other SAP products, prepare it, and deliver it to Microsoft Fabric, Snowflake, Databricks, Power BI, Excel and more, on demand or on a schedule. Write back to SAP is available through add-ons.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
DVW Flow Tool: the workflow platform built for SAP
The DVW Flow Tool is a standalone data preparation, transformation, and orchestration platform. It blends SAP data with your non-SAP data and applies over 100 built-in transformation and cleansing operations before delivery to more than 20 analytics platforms, cloud data services, and business applications. Microsoft Fabric integration is included in the base license.
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.
Deliver SAP data to a platform
- SAP to Microsoft Fabric. Deliver SAP data to Microsoft Fabric for analytics, reporting and AI workloads, and read and write a Fabric Lakehouse using drag-and-drop.
- SAP to Databricks. Build AI-ready SAP data pipelines into Databricks for ML teams.
- SAP to Snowflake. Load structured SAP data into Snowflake for analytics and ML workflows.
- SAP to Google BigQuery. Load structured SAP data into Google BigQuery for analytics and ML workflows.
- SAP to Amazon Redshift. Load structured SAP data into Amazon Redshift for analytics and reporting on AWS.
- SAP to Apache Iceberg. Read and write SAP data as Apache Iceberg tables in your lakehouse.
- SAP to Power BI and Azure. Deliver SAP data to Power BI, Azure Blob Storage, Azure Data Lake and Power Apps Dataverse.
- SAP to Excel. Deliver SAP data into the Excel reports your team already uses, refreshed on demand or on a schedule.
Finance, tax and audit
- Financial close and reconciliation. Automate period-end reconciliation and variance analysis using SAP financial data.
- Tax reporting and compliance. Extract SAP tax data for VAT/GST returns, transfer pricing analysis, tax provision calculations and country-by-country reporting.
- Audit and compliance. Extract SAP transaction data for internal and external audit, SOX compliance testing, journal entry analysis and GL-to-sub-ledger reconciliation.
Migration and consolidation
- SAP data migration. Prepare, validate and load data during SAP S/4HANA migration projects using IDoc, BAPI and OData.
- SAP data consolidation. Combine data from multiple SAP systems and non-SAP sources into a single prepared output.
- Data blending and preparation. Blend SAP data with non-SAP sources and deliver prepared datasets to target platforms.
Automate and capture change
- Scheduled SAP extracts. Automate recurring SAP data extracts on a schedule using DVW Flow Tool Server.
- SAP change capture. Get SAP changes the moment they happen, or pull scheduled deltas on your own cadence.
- Write back to SAP. Write data back to SAP via BAPI, IDoc, OData and Analytics Cloud add-ons.
SAP data is extracted, prepared and delivered on a scheduled or on-demand basis. Write capabilities are available via add-ons.
There is no separate charge for the Databricks, Snowflake, Google BigQuery, Amazon Redshift, Microsoft Fabric Lakehouse and Apache Iceberg integrations. They require an active DVW Flow Tool Server license.
Key features of the DVW Flow Tool
What your license covers
One product, three levels. The Workbench is the base license. The Server adds scheduling and capacity. Add-ons cover write back to SAP and non-core SAP products.
- Read from SAP: tables, transactions and reports, queries, spool, BW, OData, Analytics Cloud and Datasphere
- SAP documents, attachments and long text
- 100+ transformation and cleansing tools
- File, Microsoft, SQL and ODBC targets
- Salesforce and Tableau connectivity
- Delivery to Microsoft Fabric
- Scheduled workflows
- Event-driven extract flows
- Parallel dataflow execution
- Databricks, Snowflake and Google BigQuery
- Microsoft Fabric Lakehouse read and write
No separate charge for these platform integrations. The Server license enables them.
- Write back to SAP: BAPI, IDoc, OData and Analytics Cloud, individually or as the SAP Write Tools Package
- SAP SuccessFactors, IBP and Cloud for Customer, read and write
- SAP Ariba reports, SAP and PBS archive data
- SAP UI automation with DVW RPA Tools for SAP
Licensing is by named user for Workbench and by capacity for Server. The 30-day free trial typically includes both Workbench and Server. View Flow Tool Pricing
Where it delivers
Deliver prepared SAP data to cloud platforms, databases, analytics tools and file formats. The DVW Flow Tool connects SAP to 20+ target platforms.
There is no separate charge for the Databricks, Snowflake, Google BigQuery, Amazon Redshift, Microsoft Fabric Lakehouse and Apache Iceberg integrations. They require an active DVW Flow Tool Server license. Contact our team for details.
Delivering SAP data to Microsoft Fabric is included in the base product. Read and write access to a Fabric Lakehouse requires a Server license.
All 20+ platforms, databases and file formats ▼
† Databricks, Snowflake, Google BigQuery, Amazon Redshift, Microsoft Fabric Lakehouse and Apache Iceberg are standard targets and sources with no separate charge. Read and write access to these platforms requires an active DVW Flow Tool Server license. SAS and SPSS files are read as sources; the Flow Tool does not write them.
SAP change capture, event-driven or scheduled
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.
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. Watch the change capture demo.
The full tool list
You read data from SAP, prepare and combine it, and deliver it to the platforms your teams already use, all inside the Flow Tool. The tools sit in five groups. Open a group to see what it contains. Add-on and Server requirements are noted where they apply.
Read from SAP Tables, T-codes, queries, spool, BW, OData, documents and text, SAP cloud applications and archives ▼
Read from SAP
Included in the base license.
- Tables and views
- Transaction codes and ABAP reports
- SAP Queries
- Report spool files
- SAP BW and BW/4HANA
- S/4HANA embedded BW
- OData services, including SAP Fiori apps
- SAP Analytics Cloud
- SAP Datasphere
- SAP Business ByDesign
Table reads cover transparent, clustered and pooled tables. BW reads return data, texts and hierarchies on separate outputs.
Read SAP documents and text
Attachments, stored documents and long text, in any file type SAP holds.
- Document Management System
- ArchiveLink documents
- SAP Office documents
- HR case management attachments
- Application server files
- SAP long text
SAP cloud applications and archives
Licensed as add-ons.
- SAP SuccessFactors, read and write
- SAP IBP, read and write
- SAP Cloud for Customer, read and write
- SAP Ariba reports
- SAP archive data
- PBS archive data
Transform Prepare, enrich, combine, reconcile, filter and sample ▼
Prepare
- Auto field
- Cell updater
- Cleanse
- Data anonymization
- Data scrambler
- Dataset information
- Rename
- Unique rows
Anonymization and scrambling are built in, so SAP data can be de-identified inside the flow before it reaches a downstream platform or a test environment.
Enrich
- Transform
- Constant value column
- Cumulative sum
- Date and time parsing
- Current date and time
- Row index
- Multi-field binning
- Rank
- String split
- Value allocation
- Value distribution
- Weighted average
Transform reorders and renames fields, changes field types and applies formulas.
Combine
- Join
- Union
- Append
- Aggregate
- Reconciliation
- Pivot
- Transpose
- Text to column
- Group iterator
Aggregate supports group, count, sum, mean, median, mode, minimum, maximum, standard deviation, variance, skewness and kurtosis.
Filter and sample
- Filter
- Sort
- Row select
- Sampling
- Percentage sampling
- Oversample
Sampling covers first and last rows, skipping rows, every nth row, a random number of rows and a random percentage of rows.
The reconciliation tool compares two datasets and returns three outputs: the records that matched, the records only on the left, and the records only on the right. Teams doing period-end checks, cross-system comparisons or audit testing get that as a single step rather than a chain of joins and filters.
Write back to SAP BAPI, IDoc, OData and SAP Analytics Cloud, licensed as add-ons ▼
Write back to SAP
Licensed as add-ons, individually or as the SAP Write Tools Package.
- BAPI read and write
- IDoc write
- OData write
- SAP Analytics Cloud write
Deliver to and read from other platforms Cloud data platforms, Microsoft ecosystem, databases, Salesforce, Tableau and file formats ▼
Read from other sources
Blend SAP data with everything else in a single flow.
- Excel
- CSV
- Fixed width and text files
- XML
- JSON
- Parquet
- HDF
- SAS
- SPSS
- Report files produced by SAP RPA
- SQL databases and ODBC
- SharePoint
- Azure Blob Storage
- Azure Data Lake
- Amazon S3
- Databricks
- Snowflake
- Google BigQuery
- Amazon Redshift
- Microsoft Fabric Lakehouse
- Apache Iceberg
- Power BI Service
- Power Apps Dataverse
- Salesforce
- Tableau Cloud and Server
- Tableau Hyper files
Write to destinations
Every platform destination above also has a write tool, so a flow can read from and write back to the same system.
- Excel
- CSV
- Fixed width and text files
- XML
- JSON
- Parquet
- HDF
- SQL databases and ODBC
- SharePoint
- Azure Blob Storage
- Azure Data Lake
- Amazon S3
- Databricks
- Snowflake
- Google BigQuery
- Amazon Redshift
- Microsoft Fabric Lakehouse
- Apache Iceberg
- Power BI Service
- Power Apps Dataverse
- Salesforce
- Tableau Cloud and Server
- Tableau Hyper files
Delivering SAP data to Microsoft Fabric is included in the base product. Databricks, Snowflake, Google BigQuery, Amazon Redshift, Microsoft Fabric Lakehouse and Apache Iceberg connectivity carries no separate DVW charge and requires an active Flow Tool Server license. Licenses for those platforms themselves are not included. SAS and SPSS files are read only.
Build, run and automate Nested flows, execution, messaging, secrets, code, and SAP UI automation ▼
Build and run flows
- Embedded dataflow
- Execute
- Flow inputs and outputs
- Wait
- Messages
- Azure Key Vault
- Code editor
Flows can be nested, so a flow that works can be reused inside larger flows rather than rebuilt.
SAP UI automation
Licensed separately as DVW RPA Tools for SAP, and usable inside Flow Tool flows. Covers SAP GUI and HTML-based SAP applications.
- SAP GUI automation
- SAP Fiori UI automation
Licensing is by named user for Workbench and by capacity for Server. View Flow Tool Pricing
Technical specifications
SAP systems supported, SAP read and write detail, and platform architecture, for technical evaluators.
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.
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). Utilize 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, including the services that SAP Fiori apps are built on. 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 optimized 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 Datasphere - Extract data from SAP Datasphere spaces, including views and analytic models. Select fields to be extracted. Apply Filters to the SAP Datasphere data to be extracted.
- 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 DVW Flow Tool is a standalone data preparation and orchestration platform designed for SAP data delivery and transformation.
- Standalone platform - no analytics platform required
- Connects SAP to 20+ non-SAP platforms, interfaces and file types
- Schedule workflows with DVW Flow Tool Server
- Use multiple SAP systems in a single workflow
- Respects user's SAP authorizations
- Designed to optimize extract of large data volumes
- Scheduled delta loads
- Event-driven triggers (SAP pushes changes to the Flow Tool)
- Reads SAP data, writes back via add-ons
- Cloud data platform integrations for Databricks, Snowflake, Google BigQuery, Amazon Redshift and Apache Iceberg (require an active DVW Flow Tool Server license)
Try it free for 30 days
Full functionality. No commitment. Trusted by 500+ enterprises worldwide.
Start your DVW Flow Tool trial
30-day free trial. Takes less than a minute. Server features such as scheduling are typically enabled once your SAP connectivity is established.
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.