SAP Business One Sunsetlink
SAP Business One is an enterprise resource planning (ERP) software for small and medium-sized enterprises. Fivetran connects to the underlying database to integrate your ERP data with the destination of your choice for analytics.
IMPORTANT: We have deprecated our existing SAP S/4 connector. See our High-Volume Agent SAP Business One on HANA documentation.
Setup guidelink
SAP Business One is built on the SQL Server or SAP HANA relational databases. Instead of pulling data from the SAP Business One API, we pull directly from the source database, saving time and effort. For syncing SAP Business One, use our SQL Server connector or SAP S/4 connector.
NOTE: Our SAP Business One connector can sync any table from the SAP Business One database. Contact our support team for SAP HANA support.
Schema informationlink
For more information on SAP Business One schemas, see our SQL Server Schema information and SAP S/4 Schema information sections.
Limitationslink
- Our SAP S/4 connector does not capture schema changes.
- Our SQL Server and SAP S/4 connectors does not support
TRUNCATE TABLE
operations. If you perform aTRUNCATE TABLE
operation on the source database, you must re-sync the corresponding table in your destination to capture the changes.