The Amazon Redshift app for Freshchat/CSS provides agents and admins data from your Amazon Redshift data Warehouse.

This integration is powered by the Amazon Redshift app, which allows you to enrich contact details from Amazon Redshift.

Note: The term Freshchat used in this article also applies to the Freshdesk Omni product.

Prerequisites:

Ensure that you have admin permissions in Freshchat.

This article includes:

Installation

To install the Amazon Redshift app on Freshchat:

1. Log in to your account, go to Admin Settings > Marketplace and Integrations > Marketplace Apps.
2. Search for the Amazon Redshift app.
3. Click Install and connect your account.
4. Enter the following details:
   • Freshchat domain (yourcompany.freshchat.com)
   • Freshchat API key
     To find your Freshchat API Key, go to Admin Settings > Marketplace and Integrations > API settings.
     Complete the Captcha verification to view the key.
   • CRM domain (yourcompany.myfreshworks.com)
   • CRM API Key
5. Click Install to complete the setup.
6. Once the installation is complete, you can view the app icon on the left navigation pane. If you have more than one installed app in your account, the apps will be grouped. 

Configuring data sync

To synchronize data between Amazon Redshift and Freshchat, go to the 'Data sync' tab in the full-page app. 

1. On your Freshchat account, click on the Amazon Redshift app icon from the left navigation pane.
2. Go to the Data sync tab and click Configure sync.
3. Authenticate the Amazon Redshift account you want to synchronize the data with Freshchat.
4. To connect to your Amazon Redshift account, log in with your Google account and allow read/write access to Amazon Redshift.
5. You will find a tab for recipes. Recipes are workflows that define the flow and direction of data. Choose the direction of data flow based on your requirements:
   • Amazon Redshift to Freshchat: One-way data flow from Amazon Redshift to Freshchat
   • Freshchat to Amazon Redshift: One-way data flow from Freshchat to Amazon Redshift
6. Once you choose the direction, relevant recipes will appear. You can currently sync Contact and Account information between Amazon Redshift and Freshchat.
7. Choose the fields you want to sync.

Configuration between Amazon Redshift and Freshchat

Contacts sync:

On your Amazon Redshift account, create a field called ‘Contact ID’ under the Contact table.

1. In the Recipe data screen, on the right pane, choose the table and the corresponding column from which the recipe should fetch the data.
   
2. In the left pane, configure the Actions for the Trigger.
   Under Actions, map the contact fields (2) and set the action as "Upsert Contacts in Freshchat".
   
3. Save and run the recipe.

Note: Follow the same steps to sync company fields.

Pricing

The Connector app is a paid add-on priced at $80 per 5000 tasks and aligns with your billing cycle. For example, for a monthly billing cycle, tasks expire monthly or annually for an annual plan. 

To purchase the add-on:

1. On your Freshchat account, go to Admin Settings > Account and Billing > Plans and Billing > Manage plan.
2. Select the number of Connector App Task Packs you wish to purchase.
   Please note that you can purchase the add-on only when you have an active subscription with Freshchat.

How are tasks calculated?

Every action block in the recipe constitutes a task. The following table shows the task consumption based on the entity and direction of sync: