SQL

DataViz Migration - an upstream/downstream SQL interoperability layer - {oa-lake} featured image

DataViz Migration - an upstream/downstream SQL interoperability layer - {oa-lake}

Implementing a SQL interoperability layer to unify data sources and simplify migrations between data visualization platforms.

ETL Migration - legacy ETL connectors for SQL migration featured image

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 SQL featured image

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

ETL Migration - from legacy ETL to dbt

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

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

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

How to rebuild an open decision-support estate by externalizing calculations, indicators, and business rules from SAP BO, Cognos, Power BI, or Spotfire into a centralized, …

DataViz Migration - an interoperable semantic layer - {oa-lake-ctx} featured image

DataViz Migration - an interoperable semantic layer - {oa-lake-ctx}

Implementing a unified semantic layer to centralize business objects, indicators, and business rules independently of data sources and reporting tools.

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}

Analysis of connectors, stages, and technical components of the leading ETL platforms to produce interoperable SQL.