High-Volume Agent SAP Business One on HANA Private Previewlink
SAP Business One is an enterprise resource solution for small and medium enterprises. Fivetran replicates data from your SAP HANA source database and loads it into your destination using High-Volume Agent (HVA) connector.
IMPORTANT:
- You must have an Enterprise or Business Critical plan to use the SAP Business One connector.
- In Private Preview, the connector only supports Snowflake, BigQuery, PostgreSQL, Databricks, Redshift, and Azure SQL Database as destinations.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables and fields |
Custom data | check | All tables and fields |
Data blocking | check | Column level, table level, and schema level |
Column hashing | check | |
Re-sync | check | Table level |
History | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
ODBC connectionlink
Fivetran requires the installation of the HANA client on the machine with the HVA. The HVA uses the HANA ODBC driver to connect, read, and replicate data from HANA. For more information about the supported ODBC driver version, see the release notes (hvr.rel) in the hvr_home
directory of the agent installation.
Setup guidelink
Follow our SAP Business One Setup Guide to connect SAP Business One with your destination using Fivetran's HVA connector.
Sync overviewlink
Once Fivetran is connected to your HANA source database, we pull a full dump of selected data from your database during the initial sync and send it to your destination. We then capture all new and changed data using one of our proprietary capture methods. Fivetran automatically detects schema changes in the source database (for example, new tables or changed data types) and persists these changes to your destination. We offer one of the following capture methods:
- DirectDBMS Log Reading: This method captures changes directly from HANA's log segments and log backups. This method is very fast in capturing changes from the HANA database. However, it requires High-Volume Agent to be installed on the HANA machine.
- Archive Only: This method captures changes from HANA's log backups only. High-Volume Agent can either detect the location of the log backups automatically or use pre-configured custom path and format. It is important to understand that during the capture process, High-Volume Agent is not connected to the source database. Therefore, using a custom path allows the High-Volume Agent to capture from a location other than HANA's backup location(s).
INFO: The Archive Only capture method generally exhibits higher latency than the DirectDBMS Log Reading method because changes can only be captured when a log backup file is created. While this capture method enables high-performance data capture with minimal operating system and database privileges, it comes at the cost of higher capture latency.
Schema informationlink
Fivetran tries to replicate the exact schema and tables from your HANA source database to your destination according to our standard database update strategies. This ensures that the data in your destination is in a familiar format to work with.
When you connect to Fivetran and specify a source database, you also select a schema prefix. We map the SAP schema in your source database to your destination and prepend the destination schema name with the prefix you selected.
Fivetran-generated columnslink
Fivetran adds the following columns to every table in your destination:
_fivetran_deleted
(BOOLEAN) marks rows that were deleted in the source database._fivetran_synced
(UTC TIMESTAMP) indicates the time when Fivetran last successfully synced the row._fivetran_rowid
(NUMBER) is HANA internal row id ($rowid$
column) of the row. It is also used as a primary key if there is no other primary key defined on the table.
We add these columns to give you insight into the state of your data and the progress of your data syncs. For more information about these columns, see our System Columns and Tables documentation.
Schema changeslink
Schema changes are not recognized in Private Preview.
New tables are not automatically added. Use the Schema tab to enable the automatic addition of new tables.
NOTE: The connector does not support the truncate table operation. In case you need to truncate a table, we recommend performing a table-level re-sync instead.
Initial synclink
Once connected to your database, the Fivetran connector copies all rows from every table in every schema for which a Fivetran user has SELECT
permissions (except for those you have excluded in your Fivetran dashboard) and sends them to your destination. Additionally, we add Fivetran-generated columns to every table in your destination offering visibility into the state of your data during the syncs.
NOTE: While we import a maximum of four tables at a time, the process is designed to be efficient. As soon as one table import completes, we initiate the import of a new table. This approach ensures that we do not wait for all four tables to complete before starting the next one.
Updating datalink
Fivetran performs incremental updates of any new or modified data from your source database. We use log-based capture to extract your database's change data directly from the log files.
Tables with a primary keylink
We merge changes to tables with primary keys into the corresponding tables in your destination:
- An INSERT in the source table generates a new row in the destination with
_fivetran_deleted = FALSE
. - A DELETE in the source table updates the corresponding row in the destination with
_fivetran_deleted = TRUE
. - An UPDATE in the source table updates the data in the corresponding row in the destination.
NOTE: Redefining the primary key will trigger a re-sync.
Duplicate rowslink
Duplicates may appear for some rows that were updated at the same time during the initial sync. These duplicates are eventually cleaned up from the destination.
Tables without a primary keylink
We designate our _fivetran_rowid
column as the primary key for tables without a primary key.
Deleted rowslink
We do not delete rows from your destination. When a row is deleted from the source table, we set the _fivetran_deleted
column value of the corresponding row in the destination to TRUE
.
Deleted columnslink
We do not delete columns from your destination.
Excluded tableslink
Fivetran does not sync the following tables:
- Row Store tables
- Long text
STXL
table - Database-level system tables
- Temporary tables