Cornerstone Setup Guide Lite

Follow our setup guide to connect Cornerstone to Fivetran.

Prerequisites

To connect Cornerstone to Fivetran, you need a Cornerstone account with the 'Edge APIs - Manage' security permission.

Setup instructions

Enable reporting API

1. Log in to your Cornerstone account.

2. Go to Admin > Tools > Edge > Marketplace.

3. In the search bar, search for and click Reporting API tile.

4. In the Marketplace page, do one of the following:

   • If you are in the pilot and stage environment:

     1. Click Install.

     2. Click I Agree to accept terms and conditions and then click Configure Now.

   • If you are in the production environment, click Purchase Inquiry.

     Once you submit the inquiry, a Cornerstone Client Executive will contact you with the next steps for completing the purchase and enablement process.

Find base URL

Find your account's base URL in your Conerstone URL and make a note of it. The base URL depends on the environment.

• For Production, the base URL is portal_name.csod.com.
• For Staging, the base URL is portal_name-stg.csod.com.
• For Pilot, the base is portal_name-pil.csod.com.

Generate client credentials

1. Log in to your Cornerstone account.

2. Navigate to Admin > Tools > Edge > API Management > Manage OAuth 2.0 Applications.

3. Click Register New Application.

4. Enter your Application Name.

5. Enter the User ID of an active user in your portal.

6. In the Access Token Validity Period field, type 86400 seconds.

7. In the Scopes section, select the following scopes:

   • Reporting API: Refer to the table below to find the complete list of required permissions.

     Expand for the table

     
     

     Tables	Required Scope
     SETUP TEST	obj_metadata:read
     USERS	vw_rpt_user:read
     CERTIFICATION	vw_rpt_certification2:read
     PERFORMANCE_REVIEW	vw_rpt_performance_review:read
     USER_CUSTOMER_FIELD	vw_rpt_user_cf:read
     GOAL	vw_rpt_goals:read
     CURRICULUM	vw_rpt_curriculum:read
     TRAINING	vw_rpt_training:read
     TRAINING_ASSIGNMENT_USER	vw_rpt_training_assignment_user:read
     TRAINING_CURRICULA	vw_rpt_training_curricula:read
     RECRUITING	vw_rpt_recruiting:read
     REQUISITION	vw_rpt_requisition:read
     REQUISITION_CF	vw_rpt_requisition_cf:read
     REQUISITION_LOCATION	vw_rpt_requisition_location:read

   • Be sure to select the obj_metadata:read scope to complete the setup test. Additionally, we recommend that you select all the required scopes to avoid HTTP 401 unauthorized errors. For more information, see the List of scopes and security permissions for APIs.
   • To prevent any errors during data sync, deselect the tables for which the required scopes are not provided.

8. Click Register Application and then click Save changes.

9. Make a note of the Client ID, Client Secret, and all the Scopes that you selected. You will need them to configure Fivetran.

Finish Fivetran configuration

1. In the connection setup form, enter your Destination schema name.

2. Enter the Base URL that you found.

3. Enter the Client ID and Client secret you generated.

4. Enter the list of Scopes you selected.

   Enter all the selected scopes as space-separated values. For example: employee:read reportingmetadata:view.

5. (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.

6. Click Save & Test. Fivetran will take it from here and sync your Cornerstone data.

Related articles

description Connector Overview

account_tree Schema Information

settings API Connection Configuration

home Documentation Home