Smartsheets input and output connector needed

[TheCoffeeDude]

Connecting to Smartsheets using Alteryx Desktop (and by extension, Alteryx Server) is extremely cumbersome. If a user wants to read data from Smartsheet, they are required to get an API token (preferred) or use a username/password

Then do one of the following to read data from Smartsheets:

1. a. Install a ODBC driver

    b. Configure a DSN connection for ODBC
    c. Use the input data using a generic ODBC connection
or
2. Use python

To write data to Smartsheets, a user can use Python or upload the data using an API call - both very hard for end users to use especially if they're not Python developers.

Regardless, all of these are problematic. On the server I manage, I have over 15 ODBC connections to Smartsheets and it's getting very hard to upgrade the server hardware because of them. Creating a native connector for input/output of data to Smartsheets will eliminate a headache of managing ODBC connections, and make it simple for Alteryx Desktop users to read and write data.

[oyes2704]

Please make sure the driver is SSO friendly. Native Smartsheet ODBC is struggling with the SSO for a number of years.

[TheCoffeeDude]

You should be using the API token rather than SSO. There's no way to go through the SSO process if your workflow is uploaded and running on Alteryx Server.

[oyes2704]

@TheCoffeeDude Unfortunately even with a token, Smartsheet ODBC has an issue with SSO enabled: Smartsheet ODBC connector not working - but only for Excel — Smartsheet Community

Remember as the first check to run Data Import with Smartsheet ODBC from SSIS and Excel. If those two fail, Alteryx not going to work for sure.

[TheCoffeeDude]

@oyes2704 Your experience of needing to go through the SSO process even when using an API token is remarkably different from mine. In my company, I only have to go through the SSO process once a day for most applications. I do not have to go through the SSO process for applications where I can generate an API token.

Different companies, different requirements.