Articles and guides
How to connect 1C, BILLZ and spreadsheets to Power BI, speed up reports and stop depending on Excel exports.
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...
Read1C 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...
ReadSolutions for your task
1C, BILLZ, Google Sheets and Excel — into one warehouse for Power BI and Tableau reports. Pick what you need.
Power BI on 1C data — in one day
Connect Power BI and Tableau to 1C data: ETL Sync moves catalogs, documents and registers into a SQL warehouse on schedule, with readable table...
1СPower BITableauMS SQLPostgreSQL Learn more ETL for 1C1C to SQL and PostgreSQL — automatically
ETL for 1C: catalogs, documents, tabular sections and registers are copied to MS SQL Server or PostgreSQL on schedule, changes only, with readable...
1СMS SQLPostgreSQLMySQL Learn more BILLZ · Power BIBILLZ analytics in Power BI and SQL
ETL Sync pulls sales, stock, products and stores from BILLZ via API into your SQL database. Power BI reports across the whole store network —...
BILLZPower BIMS SQLPostgreSQLTelegram 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 more ETL Sync serverNothing to install: the program and storage run with us
Don't want to install the program and a server yourself? We run ETL Sync and a PostgreSQL warehouse on our server: the panel opens in a browser,...
1СBILLZPostgreSQLHTTPSPower BI Learn moreLeave a request
We will call you back within a business day, show the program and help you install it.