MigraFlow — Data Migration to Creatio CRM
Connect your SQL Server, map fields visually, and migrate to Creatio CRM in minutes. No scripts. No manual OData.
MigraFlow is a desktop application that connects directly to your SQL Server database and your Creatio CRM instance. It lets you browse tables, map columns to Creatio fields with a visual interface, resolve lookups automatically (text to GUID), filter records with WHERE conditions, and execute the migration with real-time progress and CSV-exportable logs. The demo version allows up to 500 cumulative records.
Download
MigraFlow — Data Migration to Creatio CRM
Windows 10+ · v1.0.0 · ~85 MB
How it Works
Connect
Enter SQL Server and Creatio credentials. Test both connections with one click.
Select Table
Browse tables with row counts and column previews. Pick the table to migrate.
Map Fields
Map SQL columns to Creatio fields. Auto-mapping by name, automatic lookup resolution, default values.
Filter (Optional)
Add WHERE conditions to migrate only specific records. See the generated SQL query in real time.
Migrate
Preview the first 10 rows, run the migration with real-time progress, and export the CSV log.
Key Features
Auto field mapping
Matches SQL columns to Creatio fields automatically by name (e.g., "Email" to "Email").
Lookup resolution
Send text values and MigraFlow resolves the corresponding GUID in Creatio automatically.
Default values
Assign fixed values to Creatio fields not in your SQL table (e.g., OwnerId = "Supervisor").
WHERE filters
Filters with =, !=, >=, <=, LIKE, IS NULL, IS NOT NULL operators. Multiple conditions with AND.
Real-time progress
Progress bar with percentage and live count of OK / Warnings / Errors.
Exportable CSV log
Download a file with the detail of each record: row, status (ok/warning/error), and message.
Saved credentials
Option to remember SQL Server and Creatio credentials across sessions.
4 Creatio entities
Supports Contact, Account, Lead, and Activity. More entities in future versions.
Tech Stack
Architecture Patterns
SQL connection via TCP/IP
Tedious driver connects directly to port 1433 with SQL authentication.
OData v4 + Cookie Auth
Authentication against Creatio via cookies, then CRUD operations via OData REST API.
Batch processing
Records are processed in batches of 10 with pause between batches to avoid overloading Creatio.
Local storage
Credentials and usage counter stored in %APPDATA%/migraflow/ via Electron.
Need to migrate more than 500 records?
Contact us for the full version with no record limit.
Get in touch