FinancialForce is an ERP and service automation tool built on Salesforce.
Fivetran fetches all the underlying FinancialForce data from Salesforce (SFDC) into a SQL-enabled environment allowing you to get a more in-depth analysis of your data.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture Deletes | check | Only for replicateable objects |
| Custom Data | check | |
| Data Blocking | check | Column level, table level, and schema level |
| Column Hashing | check | |
| Re-sync | check | Table level and connector level |
| History | check | Table level |
| API Configurable | check | |
| Priority-first sync | ||
| dbt Package |
Setup guidelink
FinancialForce is built on the Salesforce platform. Follow our step-by-step FinancialForce setup guide to connect FinancialForce with your destination using Fivetran connectors.
Sync overviewlink
The FinancialForce connector follows the same sync strategy as our Salesforce connector. See Salesforce’s Sync overview section for more information.
Schema informationlink
Fivetran follows a one-to-one mapping with all objects in FinancialForce. FinancialForce object names start with c2g__. We sync the objects with the c2g__ prefix in their names from your Salesforce account to your destination.
See the FinancialForce schema for more information.
NOTE: You must have a FinancialForce account to access the entity-relationship diagrams.
System tableslink
FIVETRAN_QUERYlink
| COLUMN |
|---|
| id 🔑 |
| done |
| modified_field |
| modified_since_inclusive |
| merge_mode |
| query |
| rows_updated_or_inserted |
| source_object |
| source_api |
| start |
FIVETRAN_API_CALLlink
| COLUMN |
|---|
| start 🔑 |
| method |
| uri |
| update_id |
FIVETRAN_FORMULAlink
| COLUMN |
|---|
| field 🔑 |
| object 🔑 |
| formula |
| sql |
FIVETRAN_FORMULA_HISTORYlink
| COLUMN |
|---|
| field 🔑 |
| object 🔑 |
| version 🔑 |
| formula |