Development We automate your reporting and analytics end to end — Power BI, Tableau, web reports and a Telegram bot Order reports
Sign in Get in touch
1C · MS SQL · PostgreSQL

1C → your database with readable names

In the 1C database tables are called _Reference123 and _Document531 — impossible to make sense of. ETL Sync reads the 1C structure itself, collects the tables you need and writes them to a separate database with readable names. Then anyone can work with the data: an analyst, Excel, web reports or any BI system.

Start free Get in touch
1С 8.2 / 8.3MS SQLPostgreSQLETL Sync

Before → after

Before

  • 1C tables in SQL are named _Document531 and _Fld5011RRef — no way to read them without a developer.
  • Every time we need 1C data, we ask a developer for an export.
  • Queries against the live database slow 1C down for accounting and sales.

After

  • The program reads the 1C structure itself: tables and columns get readable names.
  • The tables you need refresh themselves in a separate database — even every 5 minutes.
  • Everyone works with the separate database. 1C only hands over changes — nobody notices.

How it works

  1. 1

    Connect 1C

    Point to the MS SQL or PostgreSQL server holding the 1C database. A read-only login is enough.

  2. 2

    Pick tables

    Products, sales, stock — search by name, the program suggests the refresh mode.

  3. 3

    Choose a database

    Your MS SQL Server or PostgreSQL — on your side or cloud storage on our server.

  4. 4

    Turn on the schedule

    Only changed rows — in seconds. A full check — at night.

What it looks like in the program

1C tables with readable names and a suggested mode
1C tables with readable names and a suggested mode
Overview: what refreshed and when
Overview: what refreshed and when

What you get

Readable names

The 1C 8.2/8.3 structure is read from the database automatically — no add-ons or exports.

Changes only

Documents and catalogs — by row version (_Version), registers — by recorder.

1C stays untouched

The program only reads the 1C database. No configuration changes.

Ready-made marts

Your SQL query → a ready table for reports, on schedule.

On schedule

Every 5 minutes, hourly or nightly. Connection drops — automatic retry.

Telegram summary

A sync report every morning, errors straight to Telegram.

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.

Data stays with you

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
Plans and download
Nothing to install

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
How it works

Frequently asked questions

Does it work with 1C Accounting, Trade Management, ERP, Retail?
Yes. The program works with any 1C 8.2 and 8.3 configuration on MS SQL Server or PostgreSQL.
What do we do with the database next?
Anything: web reports or dashboards in Power BI and Tableau, SQL queries, Excel. We can build the reports for you.
What if 1C runs in file mode?
You need client-server 1C (MS SQL or PostgreSQL). We'll help move a file database to a server.
Can I try it for free?
Yes, the Start plan is free with no time limit: 1 source, 1 storage and 2 tables.

Related articles

6 min read

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.

Read 5 min read

Why 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...

Read 5 min read

1C tables in SQL: what _Reference, _Document and _Fld mean and how to get readable names

Opened a 1C database in SQL Server and saw _Reference123 and _Fld5011RRef? How 1C stores data, what these names mean and how to get catalog, document and...

Read

Other solutions

MS SQL · PostgreSQL · MySQL

From any database into a new one — fast and on schedule

ETL Sync collects tables from MS SQL Server, PostgreSQL, MySQL and other databases and syncs them into one new database: only changed rows, in...

MS SQLPostgreSQLMySQLMariaDB1С Learn more BILLZ · online ERP · CRM

Online 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 · JSON

Any 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 · CSV

Google 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 more

Leave a request

We will call you back within a business day, show the program and help you install it.

Or message us
@finance_92 +998956600666

By sending, you agree to the processing of your contact details.