{openAudit} allows you to migrate SAP BO as a package to Power BI or Looker! Ellipsys has developed an open middleware to connect, transform, and orchestrate your data — regardless of the number of sources or targets. {openAudit} allows to perform automated ETL migrations from various platforms such as DataStage, Talend, and BODS, etc., to pure SQL or dbt. {openAudit} allows you to migrate SAP BO as a package to Power BI or Looker! Ellipsys has developed an open middleware to connect, transform, and orchestrate your data — regardless of the number of sources or targets. {openAudit} allows to perform automated ETL migrations from various platforms such as DataStage, Talend, and BODS, etc., to pure SQL or dbt.



{oA.Lineage}

Mapping an Information System

Information systems are so complex that teams can no longer effectively navigate the data flows to conduct the desired investigations, whether in databases or within the data visualization tools themselves, where management rules have proliferated.

The technical and multi-technology data lineage of {openAudit} makes it possible to understand the origin and uses of each data element in on-premise and/or cloud systems with a single mouse click, from end to end. The underlying analyses are rerun daily.



DataFlow mapping

Do Data Lineage in DataFlows

Starting from any "data point" in the Information System (a field in a table, a table, a file, a schema, etc.), {openAudit} allows you to understand its origin, its evolution, and its uses thanks to multi-technology technical data lineage. The process is dynamic, 100% automated, operated in delta mode and without breaks: {openAudit} handles views, nested views, dynamic procedures, transfers via FTP, etc.

End-to-end impact analysis

{openAudit} offers a view that allows to instantly know all the uses of a data point in the data visualization layer, ignoring all transformations.

End-to-end impact analysis
Complete and instantaneous mapping

Complete and instantaneous mapping

{openAudit} allows you, from any data point, to display a complete map of the upstream and downstream flow, from operational sources to data exposure (DataViz, queries), i.e. its uses.

Granular data lineage

{openAudit} allows you to progressively monitor the deployment of data in complex Information Systems, on premise, Cloud, without disruption. Each transformation can be analyzed with “drill through”.

Granular data lineage

Use cases

From source to dashboard cell: Mapping the IS to rebuild it intelligently

The data lineage of {openAudit} to reinforce GCP Dataplex

Do Data Lineage in the Data Visualization layer

{openAudit} allows you to understand all of the company's data visualization technologies on a single impact analysis interface. Data lineage in the dashboard can be triggered to highlight the numerous management rules defined there.

Highlighting management rules

{openAudit} performs data lineage in expressions, variables, etc., to precisely explain the management rules underlying the calculation of a dashboard indicator.

Highlighting management rules
Automatic sourcing of dashboard indicators

Automatic sourcing of dashboard indicators

{openAudit} analyzes the content of views to identify the physical fields that are the source of a dashboard's data, even if the views are stacked.

A combined impact analysis grid

{openAudit} combines the analyzes of the company's different DataViz technologies in the same grid, which allows the business and IT to carry out exhaustive impact analyses.

Combined impact analysis grid

Use cases

Source the data in a dataviz solution

E-book / Control & Simplify an SAP BO platform with {openAudit}