FinancialForce Betalink
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. Supports history mode. |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Supported environmentslink
Our two FinancialForce connectors, FinancialForce and FinancialForce Sandbox, support the following environments:
CONNECTOR NAME | ENVIRONMENT |
---|---|
FinancialForce | Production |
FinancialForce Sandbox | Sandbox |
Setup guidelink
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_MODELlink
COLUMN |
---|
object 🔑 |
model |