Extract, transform and load data from legacy on-premises databases to AWS Aurora MySQL — unlocking modern BI tools like Amazon QuickSight and Google Data Studio for databases that lack native cloud connectivity.
View Live Site · Built by Factor BI
Vansync is a Windows ETL engine that bridges legacy on-premises databases — which have no native connectors to modern BI tools — to AWS Aurora MySQL, where the entire analytics ecosystem becomes available.
On-Premises DBs → Vansync Engine → AWS Aurora MySQL → BI Tools
(Firebird, dBase, (QuickSight,
VFP, Sybase, Data Studio,
SQL Server, Redshift, ...)
MySQL)
| Database | Notes |
|---|---|
| Firebird SQL | Used by Microsip, Aspel ERPs |
| Sybase SQL Anywhere | Used by Volante and others |
| dBase / DBF | Used by Maxirest and legacy POS systems |
| Visual FoxPro | |
| Microsoft SQL Server | Used by Intelisis ERP, Soft Restaurant |
| MySQL | Source-to-source sync or consolidation |
- Legacy Database ETL — extract from databases with no native BI connectors
- Multi-Location Consolidation — merge data from multiple branches and DB engines into a single Aurora-MySQL instance
- Scheduled Refresh — configure sync schedules or trigger on-demand via API
- Modern Data Warehouse — load into Aurora-MySQL, Redshift, or any cloud-native DWH
- Google Sheets Library — pull spreadsheet data into your DWH via Google Apps Script
- Two-way Synchronization — optionally push data back from Aurora to on-premises tables
This repo is the public documentation site served via GitHub Pages at https://factorbi.github.io/.
The HTML files were originally generated by MkDocs and are now edited directly — there is no build step and no markdown source files in the repo.
python3 -m http.server 8000
# open http://localhost:8000| Group | Pages |
|---|---|
| Getting Started | index, easyawssetup, registration, installation |
| Data Sources | firebird, sqlserver, dbase, visualfoxpro, sqlanywhere, mysql, csvtomysql |
| Configuration | customdatajson, vansync-api, synctowindows, setupaws |
| ERP Integrations | aspel, microsip, intelisis, soft-restaurant, positouch |
| Troubleshooting | troubleshooting |
| Business Intelligence | businessintelligence, about |
Each page lives at /<pagename>/index.html. Shared assets (css/, js/, img/, fonts/) are at the repo root; pages reference them with ../ relative paths.
- All visible content in English, except
aspel,microsip,intelisis, andsoft-restaurant— those remain in Spanish. - Product name is Vansync (never "Bipost").
- Executable is
Vansync.exe. - S3 bucket prefix for new clients:
vansync-. - Do not rename: AWS system DB names (
bipost_system,bipost_sync_info,bipost_sync_table) or image filenames (e.g.img/bipost7.png).
© 2026 Factor BI. Vansync™ is a trademark of Factor BI.