Fivetran fully automated connectors sync data from cloud applications, databases, event logs and more into your data warehouse. Our integrations are built for analysts who need data centralized but don’t want to spend time maintaining their own pipelines or ETL systems.

Authenticating

Fivetran uses API Key based auth, a developer-friendly delegated access protocol. Quolum has already connected the necessary wires with Fivetran. Using a sequence of click-throughs, your organization's administrator allows Quolum to make API calls to Fivetran without getting access to passwords.

Step 1: Initiate a connection to Fivetran

Click the Connect button from the Connections card. If you are not an admin, you can invite your organization's Fivetran admin to make a connection to your Fivetran organization account. When you click on the Connect button, the web browser will navigate to the Fivetran login page.

2382

Quolum Catalog: Fivetran App

Step 2: Log in to Fivetran

Log in to Fivetran using your organization's credentials. The exact login mechanism may depend on your Fivetran plan, and the sign-in mechanism used. You may have corporate SSO such as Azure AD, GSuite, or Okta along with multi-factor authentication. Once you have successfully logged-in you can find the API Key and API Secret as mentioned below in Step 3.

1186

Fivetran Authentication

Step 3: Back to Quolum

Once you have granted access to Quolum, Fivetran is going to send you back to Quolum's page in Step 1, where you started. The Connect button on the Connections card would now say Reconnect. Reconnect is used to reauthenticate under circumstances where the access has expired.

Under the hood

Using the OAuth protocol, Quolum now has delegated access to your Fivetran Workspace. The Quolum server, running on Amazon AWS VPC, will be able to make API calls and retrieve feature-level utilization of projects, stories, and tasks. Later, this data is crunched and available for visualization on the Quolum dashboard.