Drive your Analytics System with openAudit®


openAudit®, a dynamic reverse engineering solution, to control complex Analytics Systems

Persistence

How?

openAudit® analyzes dynamically all components of Analytics Systems: storage, processing, scheduling, audit, reporting.

Unique added value?

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

Outputs? 

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

persistence
persistence

Feature [Persistence];
Discover data uses

openAudit®, thanks to different probes and analyzers, defines the operational sources of each data, and its end uses, whether in business reporting tools, or via ODBC, JDBC, Python, Excel, or other queries.

Use cases: accelerate migrations to the Cloud; knowledge sharing, end-to-end impact analysis to identify data leakage issues, ...etc.

Contact Us
data-lineage
data-lineage

Feature [Data-Lineage];
Explore data processing

openAudit®, thanks to a continuous analysis of all on-board technologies to process the data, adding the capture of certain logs, allows a granular and continuous data lineage, which can be granular or schematic.

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

Contact us
collision
collision

Feature [Collision];
Erase IT debt

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

Use cases: massively simplify an Analytics System; detect the "information superhighways" to focus on their quality and security, reduce licensing costs, act for green IT,..etc.

Contact us
etl_scheduling
etl_scheduling

Feature [ETL_Scheduling];
Check run times

openAudit® analyzes the scheduler logs, and dynamically identifies sequences that are operational, those that are not, those that are slow... with direct access to the content of all triggered ETL jobs.

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

Contact us
bo-powerbi
bo-powerbi

[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 - other technologies under development - It can be linked to other openAudit® features, to have a view of whole Analytics Systems.

Use cases: granular impact analysis from dashboards to operational sources; identification of obsolete or replicated dashboards in the reporting layer; semi-automated cleaning of a platform from unused / broken items.

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.


Pricing:

From...

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].
..To

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:

Adeo
BGL
Cora
EIB
RBC
Raiffeisen
Unibail
BIL
CTCE

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 in parlicular, 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.