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.
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.
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.
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.
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.
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 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!