SQL

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

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.

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

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

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.