Resources

  • Data lineage and simplification: SaaS and on-premise architectures of {openAudit}, connectors, containerization, data catalogs.
  • ETL migration: DataStage, Talend, Informatica, SSIS, ODI to SQL, dbt… or to an open SQL ETL ({oa-tbx}).
  • Dataviz migration: SAP BusinessObjects, Cognos, Spotfire to Power BI, Looker… or to an open SQL and semantic layer ({oa-lake}).
All articles

Filter by keyword or click a technology.

Data lineage - on-premise architecture featured image
+1

Data lineage - on-premise architecture

Typical {openAudit} deployment for automated flow mapping, usage analysis, and dead-branch detection.

Data lineage - SaaS architecture featured image
+1

Data lineage - SaaS architecture

Typical {openAudit} deployment in SaaS mode for automated flow mapping, usage analysis, and dead-branch detection.

Data lineage - feeding third-party data catalogs to expose technical data lineage featured image

Data lineage - feeding third-party data catalogs to expose technical data lineage

Automated publication of data lineage, dependencies, and usage to the leading Data Catalog solutions on the market.

Data lineage - the principles of connector containerization featured image
+28

Data lineage - the principles of connector containerization

Containerized architecture enabling secure extraction, anonymization, and processing of the metadata used by {openAudit}.

Data lineage - connection protocols to the various analytics technologies featured image
+34

Data lineage - connection protocols to the various analytics technologies

Native protocols and interfaces (JDBC, ODBC, REST API, SDK, exports) used to collect metadata from databases, ETL tools, and data visualization tools.

ETL Migration - from legacy ETL to SQL featured image
+8

ETL Migration - from legacy ETL to SQL

Automated conversion of legacy ETL processes into open, portable SQL pipelines.

ETL Migration - from legacy ETL to dbt featured image
+8

ETL Migration - from legacy ETL to dbt

Migrating legacy ETL platforms to dbt using data lineage, usage analysis, and automated SQL model generation.

ETL Migration - legacy ETL connectors for SQL migration featured image
+11

ETL Migration - legacy ETL connectors for SQL migration

Reverse engineering of the read and write connectors of legacy ETL platforms (DataStage, Talend, Informatica, BODS, SSIS...) ahead of a migration to open SQL.

ETL Migration - from legacy ETL to an open SQL ETL - {oa-tbx} featured image

ETL Migration - from legacy ETL to an open SQL ETL - {oa-tbx}

Running migrated ETL processes as SQL in an open, serverless container orchestrated by Airflow, with no dependency on the original ETL platform.

DataViz Migration - migrating from SAP BO to Power BI featured image
+1

DataViz Migration - migrating from SAP BO to Power BI

Automated analysis of SAP BusinessObjects, universe simplification, and migration to Power BI with business intelligence preserved.

DataViz Migration - migrating from SAP BO to GCP Looker featured image
+2

DataViz Migration - migrating from SAP BO to GCP Looker

Automated analysis of SAP BusinessObjects, universe simplification, and migration to Looker with business intelligence preserved.

DataViz Migration - migrating from Cognos to Power BI featured image

DataViz Migration - migrating from Cognos to Power BI

Automated migration of IBM Cognos estates to Power BI, with reconstruction of the semantic layer and recovery of reports.

DataViz Migration - SAP BO, Power BI, Spotfire, or Cognos to an open, interoperable architecture featured image
+1

DataViz Migration - SAP BO, Power BI, Spotfire, or Cognos to an open, interoperable architecture

Externalize calculations, indicators, and business rules from SAP BO, Cognos, Power BI, or Spotfire into an open SQL and semantic layer: {oa-lake}.

DataViz Migration - SQL interoperability and semantic layer - {oa-lake} featured image
+17

DataViz Migration - SQL interoperability and semantic layer - {oa-lake}

{oa-lake}: a multi-source SQL interoperability layer with a built-in semantic layer, to define business objects and KPIs once for every BI tool.