Cornerstone OnDemand Connector

Intro

Cornerstone OnDemand helps organizations recruit, train, engage, and manage their employees. Cornerstone also helps people be their best at work with the right development and experiences.The Cornerstone OnDemand connector allows you to pull data from your Cornerstone OnDemand system into Domo. To learn more about the Cornerstone OnDemand API, visit their page (https://apiexplorer.csod.com/apiconn…/apiexplorer#/).

You connect to your Cornerstone OnDemand account in the Data Center. This topic discusses the fields and menus that are specific to the Cornerstone OnDemand connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to your Cornerstone OnDemand account and create a DataSet, you must have the following:

• The API Key and API Secret. It can be retrieved from the Manage API tab in Integration Center.
• The client assigned hostname for your Cornerstone OnDemand application (Corpname).
• Environment
• A valid username associated with an active account in the portal.

Connecting to Your Cornerstone OnDemand Account

This section enumerates the options in the Credentials and Details panes in the Cornerstone OnDemand Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your Cornerstone OnDemand account. The following table describes what is needed for each field:

Field	Description
API Key	Enter the API Key. It can be retrieved from the Manage API tab in Integration Center.
API Secret	Enter the API Secret. It can be retrieved from the Manage API tab in Integration Center.
Corpname	Enter the client assigned hostname for your CornerStone OnDemand application (Corpname).
Environment	Select the environment (Pilot, Stage, or Production).
Username	Enter a valid username associated with an active account in the portal.

Once you have entered valid Cornerstone OnDemand credentials, you can use the same account any time you go to create a new Cornerstone OnDemand DataSet. You can manage Connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu	Description
API	Select the API you want to use to pull data from Cornerstone OnDemand. - Reporting API - Data Exporter API
Views (Reporting API)	This field appears when you select the Reporting API. Select a view from the dropdown. The views that are accessible to you are dependent on your access level.
Views (Data Exporter API)	This field appears when you select the Data Exporter API. Select the Object from the drop-down.

Other Panes

For information about the remaining sections of the Connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

FAQs

What endpoint is the base URL for this connector?

The base URL for Cornerstone OnDemand varies per your environment selection.

Environment	Base URL
Pilot	https://-pilot.csod.com/services/api/x/odata/api
Stage	https://-stg.csod.com/services/api/x/odata/api
Production	https://.csod.com/services/api/x/odata/api

What kind of credentials do I need to power up this connector?

You need the username, corp name, API key, and API secret associated with your Cornerstone OnDemand account. You can get your API key and API secret from the Manage API tab in Integration Center. You also need to select the environment (Pilot, Stage, or Production).

How often can the data be updated?

As often as needed.

Are there any API limits that I need to be aware of?

None

Troubleshooting

• Make sure your authentication remains valid.
• Review the configuration to make sure that all required items have been selected.
• Review the Connector history for error messages.
• In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the Connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the timeframe that you are trying to pull.