SAP Business One

SAP Business One is an enterprise resource planning (ERP) software from SAP for small and medium-sized enterprises. SAP Business One can run on either SQL Server or SAP HANA as the underlying database platform. Fivetran connects to the underlying database to integrate your ERP data with the destination of your choice for analytics.

Fivetran supports SAP Business One through:

• The SQL Server connector, for Business One on SQL Server.
• The SAP HANA connector, which is available by request. If your SAP Business One deployment runs on HANA, contact Fivetran Support for more information.

Setup guide

To sync SAP Business One data, use our SQL Server connector.

Fivetran connects directly to the SQL Server database used by your SAP Business One deployment, rather than using the SAP Business One API. Connecting directly to the database simplifies the integration process and enables efficient, reliable data extraction for analytics.

Schema information

For more information on SAP Business One schemas, see our SQL Server Schema information section.

Limitations

• Access to the SAP Business One database (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.