Data lineage - the principles of connector containerization

Jul 2, 2026 · 2 min read
ressources

{openAudit} collection relies on containerized components deployed in the Client’s environment, as close as possible to the systems analyzed: one container per technology (databases, ETL/ELT platforms, data visualization tools, audit databases), compatible with Docker and Podman, for on-premise, SaaS, or hybrid deployment.

ETL / ELT
SAP Data ServicesIBM DataStageTalendSSISAb InitioStambiadbtOracle Data IntegratorInformatica PowerCenter
Databases
OracleTeradataIBM DB2SQL ServerGoogle BigQueryPostgreSQL
Languages and scripts
SQLJavaPerlCOBOL
Data visualization and reporting
SAP BusinessObjectsIBM CognosPower BITableauQlik SenseSSRSCrystal ReportsDigDashStrategySASLookerSpotfire

Key point: extractors and anonymizers are decoupled from the processing engines; each component is deployed and updated independently.

Diagram: the principles of connector containerization

Extraction

Extractors connect to the technologies analyzed through dedicated service accounts and collect metadata from databases, ETL/ELT platforms, data visualization tools, audit databases, and the scheduler. Each extractor produces a homogeneous output format, whatever the technology.

Anonymization

When required, an anonymization container sits between collection and the production of exchange files: character strings, application parameters, and literal values (SQL constants…) are replaced with technical variables. Dependencies are preserved, sensitive information removed.

Exchange files

The components produce standardized CSV files: technical objects, dependencies, transformations and, when available, usage information. The Client can archive, check, or validate them before transfer.

Processing

The central {openAudit} components use these files to reconstruct dependencies, consolidate metadata, integrate usage from audit logs, and produce the data lineage.

Result: a homogeneous collection chain, independent of the technologies analyzed and of deployment modes.

Frequently asked questions

How does {openAudit} collect metadata?
With containerized components deployed in the client’s environment, one per technology. They connect to databases, ETL/ELT platforms, data visualization tools, audit databases and the scheduler using dedicated service accounts, and produce standardized CSV files.
Which technologies do the collectors cover?
ETL/ELT: SAP Data Services, IBM DataStage, Talend, SSIS, Ab Initio, Stambia, dbt, Oracle Data Integrator and Informatica PowerCenter. Databases: Oracle, Teradata, IBM DB2, SQL Server, Google BigQuery and PostgreSQL. Dataviz: SAP BusinessObjects, IBM Cognos, Power BI, Tableau, Qlik Sense, SSRS, Crystal Reports, DigDash, Strategy, SAS, Looker and Spotfire. Plus the SQL, Java, Perl and COBOL languages.
How does metadata anonymization work?
A dedicated container, placed between collection and transfer, replaces character strings, application parameters and literal values with technical variables before the exchange files are produced. Technical dependencies are preserved.
In which environments can the collectors be deployed?
On-premise, SaaS or hybrid, with Docker or Podman. Each component can be deployed and updated independently.