Connect to your Smartsheet data
Smartsheet is a service offering software for collaboration and work management. Easily connect to your Smartsheet data to perform data analysis and track progress.
Smartsheet connector requirements
The Smartsheet connector requires the Smartsheet Administrator in your organization to:
- Use the authentication methods:
- OAuth
- API Access Token
Smartsheet connector properties
Here are the properties for the Smartsheet connector:
| Property | Description |
|---|---|
| Data Source Name | Enter the name of the data source |
| Authentication Method | Select the authentication method to connect to Smartsheet. The options are: OAuth API Access Token Refer to Security configurations for the Smartsheet connector for more information. |
| OAuth Client ID | Select OAuth for Authentication Method to configure this property. Enter the ID used to identify the application. |
| OAuth Client Secret | Select OAuth for Authentication Method to configure this property. Enter the secret string the application uses to prove its identity when requesting a token. |
| Authorize | Select OAuth for Authentication Method to configure this property. Select this button to authenticate your Smartsheet account and grant Incorta read access to your sheets. |
| API Access Token | Select API Access Token for Authentication Method to configure this property. Enter the user access token. |
| Use Connection Pooling | Enable this property to use connection pooling. For a description of the connection pooling properties, refer to the CData JDBC Driver for Smartsheet Connection String Options. |
| Show Advanced Options | Enable this property to use the advanced connection options. For a description of the advanced options, refer to the CData JDBC Driver for Smartsheet Connection String Options. |
Learn more about how to configure the Smartsheet connector.