FinancialForce Sunset
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.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ORGANIZATION table |
| History mode | check | |
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported environments
Our two FinancialForce connectors, FinancialForce and FinancialForce Sandbox, support the following environments:
| CONNECTOR NAME | ENVIRONMENT |
|---|---|
| FinancialForce | Production |
| FinancialForce Sandbox | Sandbox |
Setup guide
Follow our step-by-step FinancialForce setup guide to connect FinancialForce with your destination using Fivetran connectors.
Sync overview
The FinancialForce connector follows the same sync strategy as our Salesforce connector. See Salesforce's Sync overview section for more information.
Schema information
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 tables
FIVETRAN_QUERY
| COLUMN |
|---|
| id 🔑 |
| done |
| modified_field |
| modified_since_inclusive |
| merge_mode |
| query |
| rows_updated_or_inserted |
| source_object |
| source_api |
| start |
FIVETRAN_API_CALL
| COLUMN |
|---|
| start 🔑 |
| method |
| uri |
| update_id |
FIVETRAN_FORMULA
| COLUMN |
|---|
| field 🔑 |
| object 🔑 |
| formula |
| sql |
FIVETRAN_FORMULA_MODEL
| COLUMN |
|---|
| object 🔑 |
| model |