Français English


Data lineage and the use of data to transform a system: simplifications / migrations

A SaaS software,
with automated processes for effective action!

Security : Only Metadata

The collected metadata is automatically pushed to the {openAudit} Cloud process server to be parsed. Data usage logs can be anonymized.

Light Processes, Continuously Replayed

All metadata is parsed at the delta so that analyses are performed daily, as close to the reality of the Information System as possible.

Handling Disruptions in Flows

All potential disruptions (semantic layers, FTP transfers, views, dynamic procedures, etc.) are handled through structural reconciliations, log captures, etc., for a complete representation of the flows.

6 features to transform a system

2' to discover {openAudit}

How {openAudit} Can Help You Address Complex Issues.

An indicator is calculated incorrectly: I can trace back through the flows within the entire system and identify the problem's origin in the code: "drill through."
GDPR: I can instantly know which people or machines (software) are accessing specific personal data, possibly inappropriately, to take action.
Data Loss Prevention (DLP): I can determine if sensitive data is being requested inappropriately by a person or machine somewhere in the system.
Migrating my data visualization: I can decommission a legacy data visualization technology, typically SAP BO, and migrate to a current technology like Looker or Power BI.
Migrating my data flows: I can decommission a data storage technology, typically Cobol or Oracle, and migrate to the Cloud: GCP, Redshift, etc.
Reducing Cloud costs: I can identify tables, files, and dashboards that are not in use, along with all associated processes, and decommission them.

Frequently Asked Questions

What technologies are currently addressed by {openAudit}?

DataFlows (procedural code): SQL and SQL views, PL/SQL, T-SQL, PostgreSQL, Perl, Cobol, Java, Redshift // DataFlows (ETL/ELT): Genio, Talend, SSIS, DataStage, Stambia, BODS // DataViz: Data Studio, Qlik Sense, SAP BO, Looker, Crystal Report, SSRS.

Is it possible to work with other technologies?

Ellipsys has been developing parsers in large numbers for a long time and is capable of developing new ones in record time. Furthermore, Cloud technologies heavily use SQL and its derivatives. We have genuine expertise in SQL, SQL views, nested views, etc., as well as a methodology for handling dynamic procedures, triggers, and more.

What about the personal data revealed and their processing?

{openAudit} will add log analysis to the data lineage, to know who consumed the data, when and how (which corresponds to the uses of the data). The generated audit logs contain all SQL queries executed on the database, whether by programs or users. These queries may contain "sensitive" information such as customer names, user numbers, etc. To be exhaustive, all integers, floats and strings present in queries are hidden and replaced by variables. We do not have access to the cartography table.

Do we have access to the databases linked to the processing of metadata by {openAudit}?

The {openAudit} databases, which allow us to construct our responses on the Web interfaces, are systematically made available to customers so that they can build adhoc responses Typically, some of our customers have "plugged in" PowerBI or Qlik to be able to make additional analyses.

{openAudit} is SaaS software, but is it possible to integrate it on-prem?

Yes. We have a number of banking customers who refuse to push their data outside. We install {openAudit} on VMs at home. Ideally, we need VPN access to be able to carry out maintenance corrective action, or version upgrades. You can also create a secure airlock with a Citadelle server.

How is {openAudit} billed?

Our PoCs are never free, because the setup takes time, and its value is significant. However, as soon as a license is signed, the set up is free (at constant technical scope). In addition, we offer multi-year licenses which directly depend on the number of technologies concerned (DataFlows and DataViz) but also volumes. We offer a large number of logins, always sufficient in the client's context.