Clockify Setup Guide Lite Private Preview
Follow our setup guide to connect Clockify to Fivetran.
Prerequisites
To connect Clockify to Fivetran, you need an active Clockify account.
Generate API key
Log in to your Clockify account.
In the top right corner of the dashboard, click your profile icon.
Click Preferences option.
Go to the Advanced section and generate your personal API key.
Make a note of the API key. You will need them to configure Fivetran.
NOTE: If you face any difficulties in creating the API key, please reach out to the Clockify support team.
NOTE: If you have the Clockify Free pricing plan, detailed report data is limited to a maximum interval of one year (366 days) for the
TIME_ENTRY_REPORT
andTEAM_REPORT
tables, as well as their child tables. To access data from previous years, upgrade your Clockify plan.
Find server region
Find the region your account server is hosted in your Clockify dashboard URL and make a note of it. Your subdomain represents the account host region.
- If your URL is
https://euc1.clockify.me/xxxxx
, then your subdomaineuc1
and the region isEU (Germany)
. - If your URL is
https://use2.clockify.me/xxxxx
, then your subdomainuse2
and the region isUSA
. - If your URL is
https://euw2.clockify.me/xxxxx
, then your subdomaineuw2
and the region isUK
. - If your URL is
https://apse2.clockify.me/xxxxx
, then your subdomainapse2
and the region isAU
.
NOTE: If your URL subdomain is having some other key word other than the above four, kindly select Others option in the dropdown.
Finish Fivetran configuration
- In the connector setup form, enter the Destination schema name of your choice.
- Enter the API key you generated.
- Select the Server region you found.
- Click Save & Test. Fivetran will take it from here and sync your data from your Clockify account.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration