Skip to main content
The migration helper is a set of REST endpoints that automate the one-off task of seeding a DirectQuery database from an existing in-memory Atoti Market Risk deployment. It generates the SQL DDL that matches the Atoti Market Risk datastore schema and extracts the in-memory data into database-ready CSV files.
The migration helper requires an in-memory data cube. It reads rows directly from the in-memory IDatastore and uses the runtime IActivePivotManagerDescription to generate schema-compatible DDL. It is therefore only available when the application starts with starter.deployment.type=in-memory (the default). It is intentionally not registered when:
  • starter.deployment.type=direct-query — there is no in-memory dataset to extract.
  • starter.deployment.type=query-node — query-only nodes do not host a data cube.

​
Typical workflow

  1. Start Atoti Market Risk in in-memory mode and load the dataset you want to migrate.
  2. Call the migration helper endpoints to produce the DDL and CSV files (see below).
  3. Apply the DDL to your target database and load the CSV files.
  4. Restart Atoti Market Risk with the DirectQuery profile pointing at the now-populated database (see Getting started).

​
Endpoints

The controller is mounted at host:port/mr-application/migrationHelper/ and exposes: Names are mapped through MrDirectQueryNameMapper, so tables and columns in the generated DDL follow the same convention as the runtime DirectQuery schema (e.g. TradePnLs → TRADEPNLS, not TRADE_PN_LS). The following stores are excluded from the generated schema by default (see MRMigrationHelperRestController.getDefaultExtractionBuilder()):
  • Parent-child stores: BookParentChild, CounterpartyParentChild, LegalEntityParentChild — these are used to populate their hierarchy stores and are not needed in the DQ schema.
  • Summary cube base stores: BaseStore, SensiBaseStore, PnLBaseStore — summary cubes are not supported under DirectQuery.
  • The WhatIf simulation persistence table.
  • Sign-off companion stores for TradePnLs, TradeSensitivities, PnL.
To customise the set of exported stores, subclass MRMigrationHelperRestController and override getDefaultExtractionBuilder().

​
Configuration properties

Example: