ETL tools with connectors to [1c] : ERP

1C:Enterprise platform integration capabilities and techniques

Pages: 1

vaisakh devaraj	#1 People who like this: 0 Yes / 0 No Jun 19, 2023 04:12 PM
Just came Rating: 0 Joined: Jun 19, 2023 Company: Litmus7	I am trying to identify ETL tools that have out of the box connectors to connect to the SQL Server Database that is backend DB of [1c]:ERP . This is to fetch data , enable CDC etc to ingest data to a data lake for analytics and machine learning. I checked cloud provider services like ADF , AWS Glue etc but they dont seem to have. Please guide on how to establish either batch data connectivity(ODBC) or real time APIs to the back end SQL server DB of [1c] :ERP I am still in research phase trying to identify the right tool with connectors and went through documentations of tools like ADF , AWS Glue , Talend but yet to find any reference of a connector to [1c] : ERP

Aleksandr Biryukov	#2 People who like this: 0 Yes / 0 No Jun 22, 2023 12:21 PM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	Hello Vaisakh, it's very difficult to advise you here, since 1C stores data in SQL in a very "raw" form... it is very difficult to work with them... But we have our own BI solutions - 1C:Analytics. This solution has a completely English-language interface, and we are currently preparing English documentation for this product Maybe you will be interested to get acquainted with this product?

Subscribe

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

/* Улучшаем читаемость списков в документации */ .workarea ul, .content ul { margin: 15px 0 20px 25px !important; padding: 0 !important; list-style-type: disc !important; } .workarea li, .content li { margin-bottom: 8px !important; padding-left: 5px !important; line-height: 1.6 !important; } /* Ультимативный фикс для всех уровней заголовков в контенте */ .workarea h1, .workarea h2, .workarea h3, .workarea h4, .workarea h5, .workarea h6, .content h1, .content h2, .content h3, .content h4, .content h5, .content h6, div[id*="content"] h5, div[class*="content"] h5 { display: block !important; font-weight: 700 !important; color: #005aa0 !important; /* Наш фирменный синий */ text-transform: none !important; margin-top: 30px !important; margin-bottom: 15px !important; line-height: 1.2 !important; font-family: Arial, sans-serif !important; } /* Принудительные размеры в пикселях (чтобы не зависеть от % или em) */ .workarea h1, .content h1 { font-size: 28px !important; } .workarea h2, .content h2 { font-size: 24px !important; } .workarea h3, .content h3 { font-size: 21px !important; } .workarea h4, .content h4 { font-size: 19px !important; } .workarea h5, .content h5 { font-size: 18px !important; } /* Для 5 решеток ##### */ .workarea h6, .content h6 { font-size: 16px !important; } /* Фикс, если Битрикс добавил лишние отступы перед списками после заголовка */ .workarea h5 + ul, .content h5 + ul { margin-top: 5px !important; }