DataViz Migration - SAP BO, Power BI, Spotfire, or Cognos to an open, interoperable architecture
Data visualization platforms evolve regularly.
SAP BusinessObjects, IBM Cognos, Power BI, or Spotfire may succeed one another within the same Information System. Business objects, calculations, indicators, and business rules generally remain identical from one platform to the next.
{openAudit} analyzes technical repositories, semantic layers, and reports to reconstruct the dependencies between data sources, intermediate processes, and the objects exposed in dashboards.
Key point: the functional components of reporting platforms are extracted and then rebuilt in a format independent of the target technology.
Analysis of the decision-support estate
The parser-based analysis mechanisms cover SAP BusinessObjects universes, Cognos Frameworks, Power BI models, Spotfire Information Links, as well as the associated reports, dashboards, calculations, filters, and business objects.
The collected metadata makes it possible to reconstruct technical dependencies, semantic layers, and business rules.
Rationalization
Technical repositories are cross-referenced with usage logs. Unused reports, duplicates, and obsolete components are identified before the migration phase.
Result: a reduced scope for the actual migration.
SQL transcription
Queries, calculations, filters, aggregations, joins, variables, and business rules are reconstructed in the form of SQL.
The resulting SQL forms an open representation of the functional logic originally carried by the data visualization platform.
Key point: SQL becomes the pivot format for representing business objects.
{oa-lake}
The SQL processes are integrated into {oa-lake}.
{oa-lake} centralizes business objects, indicators, dimensions, business rules, and SQL transformations. The engine federates several data systems and exposes a single model to reporting tools.
Data can be materialized in Parquet format. Queries are generated against the physical systems or executed from the cache when needed.
Key point: business logic is defined once and then exposed to several data visualization platforms.
