CaptivateIQ Lite Private Preview
CaptivateIQ is a sales compensation management platform that helps companies design, calculate, and manage commission plans accurately and at scale.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ATTRIBUTE_WORKSHEET, ATTRIBUTE_WORKSHEET_COLUMN_CUSTOM_PICKLIST_OPTION, DATA_WORKBOOK, DATA_WORKSHEET, EMPLOYEE, EMPLOYEE_ASSUMPTION, EMPLOYEE_VISIBILITY, HIERARCHY_GROUP, PAYOUT_PERIOD_GROUP, PAYOUT_COMMISSION_PLAN, PAYOUT_WORKSHEET, PERIOD_GROUP, PUBLISHED_DASHBOARD, REPORT_MODEL, TRANSFORMATION_WORKSHEET and USERS tables. | |
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | AUDIT_LOG and DATA_WORKSHEET_RECORD tables. | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step CaptivateIQ setup guide to connect CaptivateIQ with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables.
AUDIT_LOGCOMMISSION_PLANDATA_WORKSHEET_RECORDEMPLOYEE_ASSUMPTIONEMPLOYEE_VISIBILITYHIERARCHY_GROUPJOBORGANIZATIONREPORT_MODEL_EXPORTUPLOADUSERS
To capture new records, updates and deletes, we re-import the following tables during every sync:
ATTRIBUTE_WORKSHEETATTRIBUTE_WORKSHEET_COLUMN_CUSTOM_PICKLIST_OPTIONDATA_WORKBOOKDATA_WORKSHEETEMPLOYEEPAYOUT_COMMISSION_PLANPAYOUT_PERIOD_GROUPPAYOUT_WORKSHEETPERIOD_GROUPPUBLISHED_DASHBOARDREPORT_MODELTRANSFORMATION_WORKSHEET
We also re-import the following tables once a month to capture updates and deletes:
EMPLOYEE_ASSUMPTIONEMPLOYEE_VISIBILITYHIERARCHY_GROUPUSERS
Schema information
This schema applies to all CaptivateIQ connections.
Explore CaptivateIQ schema ERD