Migration Assistant

                                                           for Cognos

Automatically decode Cognos reports
and data models

The Migration Assistant is our secret weapon for streamlining migrations to Microsoft Fabric. It unwinds the troves of data in vast, complex Cognos environments. The Migration Assistant programmatically decodes and inventories multi-layered Cognos reports and packages to identify details including data source(s), lineage, relationships and usage.

Helping to efficiently prioritize content for migration and streamline execution, the Migration Assistant is an ideal helper when modernizing to Fabric or when businesses merge, split or realign.

Watch the demo

 Streamlines Cognos to Fabric migrations

  • Identifies source data, eliminating need to manually detangle report and model details
  • Inventories report design elements enabling rapid layout reproduction
  • Identifies most used reports so you can prioritize those with most immediate business impact
  • Shows duplicate and rarely used reports allowing you to limit migration scope and reduce costs

Significantly accelerates migration time and increases accuracy

Enables accurate project scoping, budgeting and management

The Migration Assistant delivers complexity scores that quantify the effort required to rebuild or enhance reports and models.

Streamlines consolidations
of complex Cognos
environments

The Migration Assistant makes it easy to identify and eliminate report, model and database bloat for a better reporting experience and lower cost of ownership.

Interactive dashboard. Interlinking reports.

The Migration Assistant generates interlinked reports that let you view, drill down and analyze Cognos report and package information.


dashboard

Test drive the Migration Assistant dashboard

Report catalog

Combines reports and use information and can be grouped by package or usage. Assists in prioritizing the migration or rationalization project.

Insights by package

Creates a list of all reports in a package, the databases they reference and the unique tables in those databases. It also includes all the report specs for the reports in the package.

Report details

Shows details of individual reports. Useful for report recreation or when needing to drill down to source data items for a given report. Drills down to the lineage and relationship reports.

Lineage

Displays the path the data follows through the various model layers.

Relationship

Shows the relationships defined between tables including join style and columns. This information is especially useful when rebuilding data models in a new tool or data warehouse.

Custom

We can develop customized reports tailored to address your unique environment.

The Migration Assistant: real-life applications

Accelerating a Cognos data storage migration

A large U.S. bank accelerated their migration timeline by inventorying over 20,000 Cognos reports and 400 packages in preparation for their phased data storage migration to Google Big Query.

Read the case study

Reducing unnecessary Cognos complexity for better reporting

This established Cognos shop efficiently and accurately removed irrelevant columns and tables in their Framework Manager models and source database.

Read the case study

Get started today

We deploy the Migration Assistant as part of our Cognos modernization and migration services.

Back to top