ODBC Connection with Visio
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?