Skip to main content

Data Migration

Guide on performing a data migration

Andrew Grech Gatt avatar
Written by Andrew Grech Gatt
Updated over 10 months ago

Data Migration Overview

Data Migration is a critical step to ensure all historical data (prior to the activation of the FT Real Time Feed) is successfully migrated into the FT Database. This step ensures proper data alignment between the platform and FT.

Recommended Tables for Data Migration

  • Login Activity

  • User Balance Activity

  • Payment Events

  • Casino Activity

  • Sports Activity

  • Bonus Activity

Note:

Only the Payment Events table consists of raw event data.

All other tables are activity tables, containing aggregated data.

Additional tables can be selected from the Data Migration Portal available in your FT instance:

Navigation: Integration β†’ Data Migration

CSV File Preparation

  1. Use the Data Migration Portal to select the required tables and fields.

  2. Save the selection to auto-generate the CSV templates.

  3. Download the templates and fill them with historical data.

Migration Steps

1. Dry Run

  • Upload the filled CSV files to the TEMP tables via the portal.

  • QA verification is performed on the uploaded data.

  • Approval must be granted before proceeding.

2. Full Run

  • A timestamp will be provided by FT.

  • Platform must regenerate CSV files, updating data up to the provided timestamp to ensure no data discrepancy occurs.

  • FT will stop β€œconsumer” services (RTF events will still be received but queued).

  • Final CSVs are uploaded.

  • FT begins the actual data migration.

3. Post-Migration

  • Upon successful migration, FT services will resume.

  • Accumulated messages in the queue will be consumed and normal RTF processing will continue.

Important Notes

  • The duration of the migration process primarily depends on how quickly the platform can prepare and deliver the CSV files.

  • Once files are received, data migration typically completes within two working days, depending on data volume.

Handling Large Volumes of Payment Data

If your Payment Events volume exceeds 1 million records, we recommend migrating Payment Activity instead.

Caveat:

Migrating Payment Activity instead of Payment Events will result in loss of historical data functionality in:

  • Data Studio

  • Player Features

Did this answer your question?