1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:
Organize the data according to the required fields.
Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.
Set up data loading, gather key calculations: day, week, month, rating, deviation from the plan.
Ensure that each user sees only their data or their team's data — and does not have access to others' data.
During the pilot project, fix errors, clarify formulas, add necessary fields, and improve stability and speed of operation.
A step-by-step implementation of the new functional layer is expected every month.
-
30 days1670 USD
30 days1670 USD
Maya, hello! We have a ready solution that allows:
- to exchange data with various systems: to transmit structured data (with possible limitations), to receive information and process it, converting it into documents / directories
- to export or receive data from the registers of your accounting system for work and analysis through requests
- built-in AI tools that also allow receiving and processing data from accounting.
In any case, the module is just the start and the foundation for your task, so as not to "reinvent the wheel" - we will further address all issues regarding your request to achieve the final goal and objectives of your project.
-
21 days1559 USD
21 days1559 USD
Evaluation of the pilot stage - 70,000 UAH, 21 working days. This is about preparing data from 1C to BigQuery, table structure, intermediate sets for Looker, calculations day - week - month - rating - deviation from the plan and access restrictions by users and teams.
We would start with a brief design of the data model - which entities we pull from 1C, how we update the data, where we calculate the metrics, how we check the correctness of the formulas. Next - loading into BigQuery, a layer of intermediate tables, access rights, test dashboards in Looker, and stabilization during the pilot. In general, it is normal to do this in layers every month, but it is important not to gather everything on fragile manual exports =)
To start, we need access to 1C or a description of the exchange method, a list of required fields, current formulas for plans and ratings, user roles, access to BigQuery and Looker. After agreeing on the model, a new functional layer can be added every month.
> Question - Is your 1C local or cloud-based, and what method of data export is currently available?
> Question - Should the rights work at the level of Looker, BigQuery, or in both places?
… Similar cases Ingello
> https://business.ingello.com/forma-bpm - corporate processes, roles, performance control, and access logic
> https://business.ingello.com/iks - accounting, management data, reporting, and complex business logic
> https://business.ingello.com/platforma - architecture of the internal platform with data, roles, and development by stages
FLH page - https://systems-fl.ingello.com/ua
-
7 days45 USD
7 days45 USD
Hello, I have worked on integrating data from ERP systems into BigQuery for a retail chain with 50+ stores - I set up automatic loading of sales, inventory, and financial reports, processing 100K+ records daily.
Are you planning to use standard 1C APIs, or will custom solutions need to be developed for data export?
I suggest we get in touch; I will provide you with free technical consultation and we can create a development plan + I will tell you about my team!
-
20 days223 USD
1539 35 3 20 days223 USD
Good day. I am doing similar analytics for PowerBI. I am writing an HTTP service that exports data via JSON. In BigQuery, you can export via ODBC. There is no faster way. And there are the same dashboards.
-
5 days223 USD
976 4 0 5 days223 USD
Good day. My name is Dmytro. I have experience working with BigQuery, Looker Studio, ETL processes, integrations with 1C/BAS, and building analytical systems for business.
I can help with building a full-fledged data layer between 1C and Looker:
— data preparation and normalization
— designing table structures in BigQuery
— building intermediate datasets for dashboards
— automating data loading
— calculating KPIs (daily/weekly/monthly, ratings, plan/fact)
— setting up access and row-level security for teams and users
— optimizing query speed and stability
… I can also support the pilot phase: correcting formulas, adding new fields, optimizing logic, and gradually scaling the system step by step every month.
I work systematically — not just "export tables," but build a clear and stable analytical architecture for further development of BI reporting.
I am ready to discuss the current structure of 1C, data sources, and your KPIs 👍
-
3 days16 USD
1481 9 0 3 days16 USD
Good afternoon! We have experience in building ETL processes for integrating 1C with BigQuery. We implement this through the configuration of connectors for data extraction, their normalization, and the design of table structures according to Looker's requirements. This will ensure the accuracy of analytics and high report performance. We would be happy to discuss the implementation details in a meeting.
-
Версія 1C:Small Business (UNF) 8.3.1.6.21.1
-
Мая, а можете точніше написати версію УНФ вашої? Ви написали версію платформи, а не вказали реліз вашої УНФ / МБ
-
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 11 hours 36 minutes back ∙ 3 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 2 hours back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 6 days 1 hour back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 13 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 9 days 20 hours back ∙ 16 proposals |
Ukraine