Data lineage - connection protocols to the various analytics technologies
Jul 2, 2026·2 min read
ressources
{openAudit} acquires metadata through the native interfaces officially exposed by vendors: database protocols (JDBC, ODBC), REST APIs, SDKs, technical repositories, or standardized exports. Collection uses dedicated service accounts, limited to metadata, with passwords encrypted after first use.
Available connectors
ETL / ELT
SAP Data ServicesIBM DataStageTalendSSISAb InitioStambiadbtOracle Data IntegratorInformatica PowerCenter
SAP BusinessObjectsIBM CognosPower BITableauQlik SenseSSRSCrystal ReportsDigDashStrategySASLookerSpotfire
Databases
Through JDBC, ODBC, or proprietary connectors: schemas, tables, views, stored procedures and, when analyzed, usage statistics.
ETL / ELT
Through technical repositories, administration APIs, or XML / JSON exports: jobs, transformations, dependencies, and data flows.
Data Visualization Tools
Through SDKs, REST APIs, or internal repositories: data sources, semantic layers, dashboards, and business rules. Source data lineage is thus extended down to the dashboard cell.
Secure environments
Collection can be supervised through VMware Horizon, OpenOTP (two-factor authentication), or an administration bastion, with logging and traceability of operations. The mechanism is the same in Cloud, on-premise, or hybrid environments.
Frequently asked questions
Which protocols does {openAudit} use to collect metadata?
The native interfaces exposed by vendors: JDBC, ODBC and proprietary connectors for databases; technical repositories, administration APIs and XML or JSON exports for ETL/ELT tools; SDKs, REST APIs and internal repositories for data visualization tools.
What access needs to be granted for a data lineage project?
Dedicated service accounts with access limited to metadata. Passwords are encrypted after first use.
What is collected from data visualization tools?
Data sources, semantic layers, dashboards and business rules. This extends the data lineage to the reporting layer, down to the dashboard cell.
Can collection run in a highly secured environment?
Yes. Collection can be supervised through VMware Horizon, OpenOTP (two-factor authentication) and an administration bastion, with logging and traceability of operations. The mechanism is the same in cloud, on-premise or hybrid environments.
