The collected metadata is automatically pushed to the {openAudit} Cloud process server to be parsed. Data usage logs can be anonymized.
All metadata is parsed at the delta so that analyses are performed daily, as close to the reality of the Information System as possible.
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.
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.
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.
{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.
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.
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.
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.
