From any database into a new one — fast and on schedule
Company data is scattered across databases: accounting, warehouse, website, CRM. ETL Sync takes the tables you need from each and puts them into one new database. A million rows the first time, then only changes: a few rows move in seconds, and the full check runs at night.
MS SQLPostgreSQLMySQLMariaDB1СBefore → after
Data lives in several databases — combining it is manual work.
All the tables you need are in one database and refresh on schedule.
Reloading big tables takes hours and loads the live databases.
Only changed rows move — seconds instead of hours.
Export scripts break silently — we find out when the report is already wrong.
Every sync is checked; errors go to Telegram right away, dropped connections retry.
How it works
- 1
Connect databases
MS SQL Server, PostgreSQL, MySQL — a read-only login.
- 2
Pick tables
What goes where: tables, columns, your own names.
- 3
Refresh mode
Changes only by key or date, full check on schedule.
- 4
Done
The new database refreshes itself — with history and stats for every sync.
What it looks like in the program
What you get
Many databases into one
MS SQL, PostgreSQL, MySQL and 1C as sources, one storage.
Changes only
By key, modified date or row version — no reloading millions of rows.
Big tables
Parallel loading and streaming reads — no memory issues.
Row checks
Row count reconciliation and protection from empty reloads.
On schedule
Every 5 minutes or nightly; dropped connection — automatic retry.
Statistics
How many rows and how many seconds — for every table.
You decide where the program and data live
Usually the program is installed on your side — data never leaves the company. Don't want to install anything? We'll run it all on our server.
In your company
- The program on your computer or Windows server
- Warehouse — your MS SQL Server or PostgreSQL
- Data never leaves the company
- Pay only for the key — there is a free plan
On our server
- The panel opens in a browser over HTTPS
- Your own PostgreSQL database — from 10 GB
- Updates and backups are on us
- Monthly billing: key and storage, auto-renew
Frequently asked questions
Which databases are supported?
Does it load the live database?
Can tables and columns be renamed?
How many tables can be synced?
Related articles
How to connect Power BI to 1C: 3 ways and which one to choose
Three ways to get 1C data into Power BI: Excel exports, a direct SQL connection and a separate warehouse. Pros, cons and what to choose.
ReadWhy 1C reports are slow and how to move analytics to a separate database
A yearly sales report takes minutes and accounting complains about freezes? Here are the causes and how to move analytics out of 1C into a separate...
ReadOther solutions
1C → your database with readable names
ETL Sync collects catalogs, documents and registers from the 1C database and writes them to your MS SQL or PostgreSQL database: Catalog.Products...
1С 8.2 / 8.3MS SQLPostgreSQLETL Sync Learn more BILLZ · online ERP · CRMOnline ERP and platforms → your database and web reports
Sales, stock and customers from BILLZ and other online platforms — into your database on schedule. The whole store network in one set of web...
BILLZМойСкладiikoPosteramoCRM Learn more REST API · JSONAny website or service with an API → your database
Website orders, marketplace data, payment and any other services with an API — into your MS SQL or PostgreSQL database on schedule. API responses...
REST APIJSONMS SQLPostgreSQL Learn more Google Sheets · Excel · CSVGoogle Sheets and Excel — into SQL, by themselves
Sales plans, budgets and reference lists from Google Sheets, Excel and CSV go to MS SQL Server or PostgreSQL on schedule. Column types are...
Google SheetsExcelCSVMS SQLPostgreSQL Learn moreLeave a request
We will call you back within a business day, show the program and help you install it.