Data & Technology
Account mappings, cost centres, product groups and code translations often sit in code or in an Excel sheet only one person can change. In Gridmap, finance and the business maintain them themselves, with versions and a change log, and the data warehouse picks up the changes automatically. That saves developer time and removes the wait for tickets.
The controller needs a new cost centre in the group report.
The controller adds the cost centre themselves.
Most companies have rules that decide what the reports show: which account belongs to which line in the group report, which products belong to a group, how a cost centre in one system translates to another. The rules change often, but they live in code or in Excel files that only a few people can update.
Gridmap moves the rules into a tool where the business can see and change them, and the changes reach your data warehouse on the next run.
Every change is saved with a version and a name, so you can show what a mapping looked like on a given date, for example when the auditor asks.
AI suggests mappings for thousands of values at once, sorted by how confident each suggestion is.
Watch retail chain
The chain's Snowflake and dbt data warehouse fetches mappings and reference data from Gridmap on every run, and the sales and finance models build on them.
When a mapping changes in Gridmap, the change follows into the next run without anyone touching the code.
Your warehouse reads Gridmap over a REST API with support for incremental loads (delta sync). Each run fetches only the rows that changed since the previous run, and each API key is scoped to one project.
Mapping tables that live as seeds in the dbt project today can move to Gridmap and be read as a dbt source. The business maintains them there, and the calculations stay in dbt with their tests.
In dbt only developers can change them, and Excel has neither version history nor permissions. In Gridmap the business makes the change itself, every change is logged and the data warehouse picks it up automatically.
Yes, if you want it to. AI can produce suggestions that you review, or map automatically. Suggestions are sorted by confidence, so you can start by reviewing the uncertain ones.
The data warehouse reads the mappings over a REST API with incremental loads, and each run fetches only what has changed. In the other direction, Gridmap can pull values from a database or source system on a schedule.
Within the EU.
All data can be read out over the API at any time, so you can move it wherever you want.
There is a free plan with one GridMap and two users. Prices for larger teams are on gridmap.se.
Book a demo and we will go through your mappings and what would make sense to move. We will get back to you within 24 hours.