Data migration and report development for teams moving off old systems.

We move your data off legacy platforms without losing what the old system got right, then build the reports your people use every day on the new one.

40 years of experience supporting K-12 school districts and local governments on ERP projects.

What we do

Two kinds of work, usually on the same project: getting the data out of the old system, and making it useful in the new one.

Data migration

Moving records off mainframes, AS/400s, old SQL databases and file-based systems onto a modern platform.

  • Field-by-field mapping, including the business rules hidden in old code
  • Staged loads instead of one risky weekend cutover
  • Record counts and totals reconciled at every stage
  • Mapping documents and a runbook your team keeps

Report development in Cognos

IBM Cognos report writing: rebuilding the reports people depended on in the old system, and adding the ones they always wanted.

  • Cognos list, crosstab and dashboard reports, with prompts and filters people can use on their own
  • Power BI or SSRS reports available as an alternative to Cognos
  • Old and new reports checked side by side before switch-over
  • Scheduled delivery to the people who need them

Also available: system integrations and APIs, and Azure data platforms.

About Ioniq

Ioniq Data Solutions is a small, independent data consultancy built on 40 years of experience supporting K-12 school districts and local governments through ERP projects: finance, payroll, HR and student systems, from selection through conversion and go-live.

The person who scopes your project is the person who does the work, so nothing gets lost between the proposal and the delivery.

Send us an RFP, a statement of work, or a few paragraphs about the problem. You get back a written proposal with a fixed scope and a clear price, usually within a week.

Experience
40 years supporting K-12 and local government ERP projects
Focus
Legacy data migration and report development
Systems
COBOL and mainframe data, SQL Server, Azure, IBM Cognos, Power BI, SSRS
Pricing
Fixed scope and price, agreed in writing up front
You keep
All code, mappings, reports and documentation

Start a request

Tell us what system you're moving off and what reports you need. Link your RFP if you have one.

  • A reply within two business days
  • A written proposal with a fixed scope and price
  • The person who scopes it does the work

Prefer email?