ODBC Connection with Visio
Hi All,
I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards.
In Visio, you have the option to create an organizational chart via a Wizard and "an ODBC-compliant data source". After clicking on our Smartsheets connector, I can select the correct sheet. Yet, visio is unable to "read names from ODBC data source". Can anyone assist?
Thanks!
Comments
-
Hi,
Interesting use of the ODBC connector.
If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
C_Carroll,
Were you able to get the ODBC connection to Visio to work? Looking for a solution to create an org chart from a file we have in Smartsheet. This looked like a great option...
Thanks for the feedback,
Rae Ann Harris
-
Lucidchart migh be a possible solution as well.
Is that an option?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi there!
I also received this error in Visio when connecting to the sheet in Smartsheet through the ODBC connector, however, when I created a report from the original sheet that only included Employee name, Reports to, Title and Location and used that as the database table then the Visio Organization Wizard was able to process the request. The error may have something to do with connecting directly to the sheet and/or parsing through additional columns.
Hope this helps!
-
I was able to get past the error by not adding the API token and using the username and password instead. Although this is not the safest method, it worked.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives