{openAudit} allows you to migrate SAP BO as a package to Power BI or Looker! Ellipsys has developed an open middleware to connect, transform, and orchestrate your data — regardless of the number of sources or targets. {openAudit} allows to perform automated ETL migrations from various platforms such as DataStage, Talend, and BODS, etc., to pure SQL or dbt. {openAudit} allows you to migrate SAP BO as a package to Power BI or Looker! Ellipsys has developed an open middleware to connect, transform, and orchestrate your data — regardless of the number of sources or targets. {openAudit} allows to perform automated ETL migrations from various platforms such as DataStage, Talend, and BODS, etc., to pure SQL or dbt.




{oA.Reverse}

Migrate the DataFlow or DataViz layer

Legacy ETL/ELT and data visualization tools have accumulated a tremendous amount of complexity over time. Some of these technologies are outdated and no longer meet the requirements of modern data stacks: scalability, ease of use, and interoperability.
Migration is necessary. Unfortunately, the sheer volume of data and the inherent complexity of most of these technologies make these projects excessively costly and risky.

{openAudit}, by leveraging the extreme granularity of its reverse engineering capabilities, enables "as is" migrations for ETL/ELT and certain data visualization technologies in an automated way. This allows for faster time to market, reduced migration costs, and greater buy-in from business users.

DataFlow and DataViz migration

Migrate legacy ETL / ELT jobs to adaptable SQL or to modern solutions such as dbt

We have developed a unique methodology capable of deconstructing the business logic encapsulated in ELT/ETL jobs from numerous legacy solutions (BODS, DataStage, SSIS, ODI, Informatica, AB Initio, Genio, etc.) and converting it into pure or enriched SQL. This logic can then be executed directly on modern databases (GCP, Azure SQL, etc.). In addition, {openAudit} can rebuild all these instructions within modern data transformation technologies (for example, dbt).

Create standard SQL from the source technology

Step-by-step migrations from ETL / ELT to SQL make it possible to break down complex processes into readable and maintainable blocks by flattening the nested SQL of legacy systems. This allows for explicit control points and intermediate tables to track and better understand the data flow.

Create standard SQL from the source technology
Rebuild business logic in the target technology

Move to a modern data transformation technology

The transformations generated by {openAudit} are converted into enriched SQL, either to adapt directly to the target database (GCP, Redshift), or to be encapsulated within the target technology (such as dbt). Orchestration via Dagster, for example, makes it possible to visualize dependencies, schedule, and monitor pipeline executions. This approach reduces latency, improves maintainability, and fully leverages modern data warehouses.

New: "oa-lake", a SQL middleware to unify sources and tools

{oa-lake} acts as an orchestration layer between data systems and visualization tools. Based on a distributed SQL engine and Parquet storage, it centralizes business logic, reduces the load on source systems, and simplifies end-to-end data flow governance.

Create standard SQL from the source technology

Use cases

Exit Oracle Data Integrator (or other ELT), Migrate and sustainably break the complexity of flows.

Analytics: open middleware for multi-source and multi-target

Migrate data visualization technologies to the Cloud in an automated way

{openAudit}, by relying on the exceptional introspection capabilities of certain data visualization technologies, makes it possible to automate the process of “reconstruction” of the platform in the target technology: intelligence and layout. In particular, we have extensive experience in migrations between SAP BO and Power BI from Microsoft, or SAP BO to Looker from Google.

Granular analysis of DataViz technology in source

{openAudit} will automatically recover all of the instructions that are passed into the DataViz technology at the source, at the intelligence or layout level.

Granular analysis of DataViz technology in source
Automated migration to target DataViz technology

Automated migration to target DataViz technology

{openAudit} reconstructs intelligence in a fully automated way based on the target technology: variables, expressions, etc. The structure of the initial dashboard is also reproduced in the target technology.

Migrations of business rules to the target DWH

Part of the intelligence from the source dashboards is moved to the target platform's data warehouse, to streamline data preparation and thus significantly reduce complexity, but also to substantially improve response times.

Migrations of business rules to the target DWH
Mass non-regression tests

Mass non-regression tests

{openAudit} runs the dashboards in bulk, before migration and after migration, then compare the results (content and form) to validate the quality of the migration.

Use cases

Migrate from SAP BO to Power BI, Automatically, Fixed price!

Migrate from SAP BO to Power BI automatically, at a fixed price ?

Migrate from SAP BO to GCP Looker - Keeping your data as a source? Is it possible?