ETLDatabase Synchronization

Replicate your data to AWS.

Vansync extracts data from your legacy on-premises databases and loads it into Amazon Aurora MySQL — so you can finally connect the BI tool of your choice to systems that were never built for the cloud.

The pipeline

From systems that were never built for the cloud — to any BI tool you want.

Sources

On-prem databases

Firebird SQLVisual FoxProdBase / DBFSybase SQL AnywhereSQL ServerMySQL

ETL by Factor BI

Vansync

Extract, load and transform — scheduled or on-demand.

Destination

Amazon Aurora MySQL

Cloud-native data warehouse on AWS, schema auto-created.

Your BI tool

Connect any BI tool

QuickSightRecommendedTableauPower BIGoogle Data Studio

The difference

Trapped on-prem, or live in the cloud.

Without Vansync

Firebird, Sybase, dBase or Visual FoxPro

no native BI connector

your data stays trapped on-prem.

With Vansync

Your data lands in Amazon Aurora MySQL

every modern BI tool connects natively

dashboards in days, not months.

How it works

Four steps from extraction to analytics.

Extraction

Vansync reads the tables you choose from your on-prem database.

Loading

Data is loaded into your Amazon Aurora MySQL instance, schema auto-created.

Transformation

Stored procedures clean, aggregate and reshape data before and after each load.

Analytics

Connect QuickSight (or any MySQL-compatible BI tool) to your transformed data.

Capabilities

More than data movement.

ETL

Legacy database ETL

Extract from Firebird, Sybase, dBase and Visual FoxPro — engines with little or no native BI support.

Consolidation

Multi-branch consolidation

Merge data from multiple branches and engines into a single Aurora MySQL instance.

Refresh

Scheduled refresh

One or several sync schedules, or trigger on-demand via API.

Two-way

Two-way synchronization

Push specific tables from Aurora back to your on-prem environment when you need them.

Sheets

Google Sheets to your warehouse

Load sales targets, budgets and other spreadsheet data straight into the DWH.

DWH

Modern data warehouse

Build on Aurora MySQL, Redshift or any cloud-native DWH, fully AWS-compatible.

Supported sources

The engines we extract from.

Firebird

Firebird SQL

Visual FoxPro

dBase

dBase / DBF

Sybase

SQL Anywhere

SQL Server

Microsoft SQL Server

MySQL

Pricing

From $150 USD/month.

Includes up to 10 source databases or Google Sheets and 100 syncs/month. AWS infrastructure (Aurora, etc.) is billed separately by AWS. Volume discounts, supported engine versions and onboarding — let's talk.