1. Create your app in smartsheet
Register your developer account here: https://developers.smartsheet.com/register/
Enter your email address in the box provided and click Register Developer Account
You will be sent and email with an activation link. Click the link.
The link will take you to a get started page where you will create you account password.
After you enter your password and click Continue you'll be taken to Developer Tools window.
Click Edit Developer Profile and fill in your company name and website.
When you're finished click Create New App.
Fill in all the required URLs, check Publish App, and upload a logo if you choose and Save
After you Save, a window will pop up with your App ID and secret. Copy these to a text file to be used later.
2. Obtaining your OAuth Access Token
On you smartsheet developer home page, click the avatar icon in the upper right corner and select App and Integrations....
In Personal Settings select the API Access tab and click Generate New Access Token.
Name the token and click OK, copy the token to your text file to be used later.
3. Obtaining and Entering credentials into the smartsheet driver.
In this section we'll be building the connection string to be used later when setting up the data source connection.
Locate the LinkedIn driver cdata.jdbc.smartsheet.jar here:
Double click the driver and it should open the drivers connection properties. If clicking doesn't work for you, you can do this via command line.
Navigate to the drivers folder and run command "java -jar cdata.jdbc.smartsheet.jar"
Scroll to the OAuth section of the connection properties and begin filling in the appropriate fields.
6600 is the default port for v.10 adjust accordingly.
Set Initiate OAuth to GETANDREFRESH
OAuth Access Token
Obtained in Step 2. Copy and paste from your text file.
Client ID and Client Secret
Obtained at the end of Step 1. Copy and paste from your text file.
Same as the callback URL
Once these fields are filled in click Test Connection.
When your test comes back successful, click Copy to Clipboard to copy the connection string you created in the text box.
Paste the connection string into a text file to use in the final steps.
4. Creating the Data Source Connection
- Log into either the Datahub or the Admin console > Data Sources Tab > New
- Data Source Type: Generic JDBC
- Give the Data Source a name
- Database URL*: Enter in the connection string you created in Step 3
- JDBC Driver Class: cdata.jdbc.smartsheet.SmartsheetDriver