Skip to main content

Has anyone experience on connecting Celonis with SAP Business One (BOne)?

How easy is the connection?

 

Hello there!
The recommended solution for connecting Celonis to SAP Business One (BOne) involves utilizing a direct database extraction via a standard JDBC (Java Database Connectivity) extractor, as a dedicated out-of-the-box connector for BOne does not exist. This setup is technically viable provided you have the necessary credentials and collaboration from your SAP and database administrators to ensure secure and reliable access to the underlying Microsoft SQL Server database. While this approach is effective for extracting current transaction data, it presents two primary limitations: BOne does not natively provide robust change logs, meaning tracking historical data changes or performing incremental loads may require custom logic within Celonis or periodic full data loads. Furthermore, the specific tables and fields required for process mining must be meticulously identified based on your business requirements and the BOne database schema. Ultimately, this approach is feasible but requires careful management and additional effort around change tracking and precise table selection.
Hope it helps!