SAP Business One
SAP Business One is an enterprise resource planning (ERP) software from SAP 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.
Setup guide
SAP Business One is built on the SQL Server or SAP HANA relational databases. Instead of pulling data from the SAP Business One API, Fivetran pulls directly from the source database, saving time, effort and footprint. For syncing SAP Business One, use therefore our SQL Server connector or SAP HANA connector.
NOTE: Our SAP Business One database connectors can sync any table from the SAP Business One database. Contact our support team for SAP HANA support as the SAP HANA connector is still in Private Preview
Schema information
For more information on SAP Business One schemas, see our SQL Server Schema information and SAP HANA Schema information sections.
Limitations
- Access to the SAP Business One databases (SQL Server or SAP HANA) is required
- Our SAP HANA connector does not capture schema changes (yet).
- Our SQL Server and SAP HANA 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.