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.
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.
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.
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.
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.
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.
To continuously analyze a single technology in an Analytics system.
To analyse dynamically a whole Analytics system : up to 6 technologies analysed.
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.”
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!