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
Use the Data Migration Portal to select the required tables and fields.
Save the selection to auto-generate the CSV templates.
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