Khoros Care Lite

Khoros Care is a digital customer engagement platform.

Features

Feature Name	Supported	Notes
Capture deletes		`TEAM` table.
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connector level and table level. A parent table re-sync includes all associated child tables.
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

Supported deployment models

We support the SaaS and Hybrid deployment models for the connector.

NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.

Setup guide

Follow our step-by-step Khoros Care setup guide to connect Khoros Care with your destination using Fivetran connectors.

Sync overview

To capture new records, we incrementally sync the following tables:

COMBINED_REPORT
CONVERSATION_ACTION_HISTORY_REPORT
CONVERSATION_REPORT
HELP_REQUEST_REPORT
INCOMING_POST_REPORT
RESPONSE_APPROVAL_REPORT
RESPONSE_REPORT
TEAM_PERFORMANCE_INTERVAL
TEAM_PERFORMANCE_REPORT
USER_REPORT

Instead of using the fivetran_deleted column, all the tables (except TEAM) use the fivetran_id column to record their deletions. Therefore, we recommend that you ignore the fivetran_deleted column in these tables.

Schema information

This schema applies to all Khoros Care connectors.

Explore Khoros Care schema ERD

Limitations

Due to source limitations, we can only retrieve the last 548 days worth of data from Khoros Care.