Sync data from your warehouse to Kognitiv's loyalty platform
Supported syncing
| Sync Type | Description | Supported Sync Modes |
|---|---|---|
| Any data set | Sync data from a source to a file-import specification in Kognitiv | Mirror |
Mirror mode means one file with all the rows in the query results will be created, every time the sync runs.
Getting started
Connect to Kognitiv
Go to the Destinations overview page and click the Add destination button. Select Kognitiv and click Continue. You can then authenticate Hightouch to SFTP by entering the following required fields into Hightouch:
- Hostname
- Port
- Credentials (see the supported authentication methods below)
The user needs to have access to the target directory and file with write privileges.
A permission denied error message during a sync indicates the user may not have write permissions for both the directory and the file.
You may need to allowlist Hightouch's IP addresses to let our systems connect to your SFTP server. Reference our networking docs to determine which IP addresses you need to allowlist.
Supported authentication methods
We support three authentication methods:
- Username + password
- Username + SSH private key
- Username + SSH private key + passphrase
We support two formats for the SSH private key:
- OpenSSH
- RSA
Provide the full private key for the user, including the header and footer.
For example:
-----BEGIN OPENSSH PRIVATE KEY-----
<private key body>
<private key body>
<private key body>
-----END OPENSSH PRIVATE KEY-----
PGP encryption
The Kognitiv destination supports PGP encryption. Given a PGP public key, all files transferred to the destination will be encrypted.
To use PGP encryption, provide your public key in the PGP public key text area including the header and footer in the following format:
-----BEGIN PGP PUBLIC KEY BLOCK-----
<PGP public key body>
<PGP public key body>
<PGP public key body>
-----END PGP PUBLIC KEY BLOCK-----
The PGP private key is required to decrypt the files synced to your destination. You don't need to insert this value in Hightouch.
Syncing data
File import specifications
Choose which file import specification you'd like to import to Kognitiv. Hightouch offers templates for:
- Member descriptor file
- Loyalty member custom fields
Access the complete list of Kognitiv's file import options here. If you'd like to sync to a file import specification that isn't listed, select Custom and enter in the column fields as mappings.
Field mapping
If you selected one of the file import specifications listed above, column mapping options will be available to select from. You can add additional mappings by creating a new field.
If you selected Custom file import specification, enter the field that you'd like to map data to.
Tips and troubleshooting
Common errors
To date, our customers haven't experienced any errors while using this destination. If you run into any issues, please don't hesitate to . We're here to help.
Live debugger
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.
Sync alerts
Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.