Sage Intacct
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 |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Sage Intacct setup guide to connect Sage Intacct with your destination using Fivetran connectors.
Schema information
This schema applies to all Sage Intacct connectors.
To zoom, open the ERD in a new window.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 object.
If you want the AUDIT_HISTORY table to capture the deletions of GL_BATCH transactions originating from subledgers, do the following:
- Log in to your Sage Intacct account.
- Go to General Ledger > Setup > Configurations.
- Select the Enable auditing of transactions posted from subledgers checkbox.
NOTE: We don't capture deletes for custom objects as the Intacct API does not offer a mechanism to capture deletes for these objects.