Sage Intacct

is a provider of cloud-based accounting software which can provide real-time financial and operational insights, as well as the ability to automate critical processes.

Features

Feature Name	Supported	Notes

Custom data
		Column level

		Table level
History

Priority-first sync
		Get the models: /
Private networking

Setup guide

Follow our step-by-step to connect Sage Intacct with your data warehouse using Fivetran connectors.

Schema information

This schema applies to all Sage Intacct connectors.

Sync note

We store timestamp-based attributes as TIMESTAMP. Previously, we stored these attributes as VARCHAR in the destination. If you have previously synced a table with timestamp-based attributes, to ensure data integrity, drop the table from your destination and trigger a table re-sync.

Capture deletes

We use the Sage Intacct API to fetch the deleted records from the AUDIT_HISTORY table.

NOTE: The AUDIT_HISTORY table does not capture the GL records that are deleted due to the deletion of their corresponding AR Invoices.

We capture the newly created or modified records first and capture deletes at the end of each sync. As a result, if you delete and recreate an object with the same primary key, then we mark the _fivetran_deleted column as TRUE. For future syncs, if you update the record with the same primary key, then we mark this column as FALSE. We don't capture deletes for custom objects as the Intacct API does not offer a mechanism to capture deletes for these objects.