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 relational database. 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.

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) is required
• Our SQL Server connector does not support TRUNCATE TABLE operations. If you perform a TRUNCATE TABLE operation on the source database, you must re-sync the corresponding table in your destination to capture the changes.