Drive your Analytics System with openAudit® through data-lineage

openAudit®, a dynamic reverse engineering solution, to control complex legacy systems
through data-lineage.



openAudit® analyzes dynamically all the components of the systems: storage, processing, scheduling, audit, reporting.

Unique added value?

openAudit® resolves most of the breaks in data flows, and allows multi-technology processing.


openAudit® is an open database with APIs, and intuitive graphical interfaces - on premise or in the cloud. Unlimited users.


Feature [Persistence];
Discover data uses

openAudit®, thanks to different probes and parsers, defines the operational sources of each data, and its final uses, whether in business reporting tools, or via ODBC, JDBC, Pythlon, Excel…. queries.

Use case: accelerate migrations to the cloud; knowledge sharing, end-to-end impact analysis for security issues.

Contact Us

Feature [Data-Lineage];
Detect data paths

openAudit®, through a continuous analysis of on-board technologies to transport the data, by adding the capture of certain logs, allows granular and continuous data-lineage, which can be shortened and schematized.

Use cases: technically address GDPR or BCBS 239 (Basel III); share knowledge within data teams.

Contact us

Feature [Collision];
Erase IT debt

openAudit® continuously defines what is used, what it is for, but also everything that is not used in Information Systems: obsolete or replicated tables / flat files, ETL jobs or procedures that no longer feed anything...etc.

Use cases: simplify a system, massively; detect "information superhighways" to focus on their security.

Contact us

Feature [ETL_Scheduling];
Check elapsed times

openAudit® analyzes the scheduler logs, and dynamically identifies which ones are operational, which are not, which are slow ... with direct access to whole triggered ETL jobs.

Use cases: Daily quality monitor of all runs, at a glance.

Contact us

[oA for SAP BO]
[oA for PowerBI];
Master and oversimplify a reporting platform

We have developed, at the recurring request of our customers, a specific solution to over-administer SAP BO and PowerBI. It can be linked with other features of openAudit®, to get an end-to-end impact analysis.

Use cases: granular impact analysis from dashboards to operational sources; identification of replication in the reporting layer; semi-automated cleaning of a platform.

Contact us

4' to discover the main features?

The architecture presented in this film is based on 4 technologies
reporting: SAP BO | databases: Teradata and GCP | ETL/ELT: Stambia

Technologies dynamically analysed by openAudit®

Procedural languages: SQL, PL/SQL, T-SQL, Teradata Bteq, Cobol, GCP bigquery…
ETL/ELT: Genio, BODS, Datastage, SSIS, ODI, Stambia, Talend....
Schedulers: DollarU, Autosys....
Reporting: SAP BO, PowerBI.



K€ 2 / month

To continuously analyze a single technology in an Analytics system.

Outputs :

  • [Data-lineage] + [Persistence],
    or [oA for SAP BO],
    or [oA for Power BI];
  • Cloud / On prem';
  • Unlimited Users.
  • [Collision],
  • [ETL Scheduling].

K€ 6 / month

To analyse dynamically a whole Analytics system : up to 6 technologies analysed.

Outputs :

  • [Data-lineage] + [Persistence];
  • [Collision];
  • [ETL Scheduling];
  • [oA for SAP BO],
    or [oA for PowerBI];
  • Cloud / On prem';
  • Unlimited Users.

They trust us:


openAudit® helps us on those 3 directions: impact analysis (data-lineage) during the evolution of our Information System; prepare the current BI 4.2 migration; make partial backups after the departure of a collaborator. ”

openAudit® offers impact analysis + data-lineage capabilities with a PL/SQL parser (our flagship techno for our ETL flows), a parser that we have never encountered in other tools. It also allows us to do the cleansing that are required in our code, with excellent results.”

openAudit®, an easy-to-use tool that provides a quick and clear view of its SAP BO environment, but also provides a very useful data-lineage for impact analysis.”

About Ellipsys:

Ellipsys was founded by Samuel Morin in 2015. The idea is that Analytics Systems get bigger, more complex and more heterogeneous as technologies accumulate and users multiply. Ellipsys’s promise was to automate the analysis of these systems, empower teams to improve them, make them simpler, easier to migrate... This remains our ambition, and our know-how has strongly developed around data-lineage, so that we can now tackle many architectures! The team is now made up of several high-level engineers, all keen on research and development ... and customer impact!

* These fields are required.