I have a workbook that connect live to an ODBC and I tried publishing it to Tableau server but it show error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Unable to connect using the DSN named "SCSNB07: Scheduler9". Check that the DSN exists and is a valid connection.
Errors occurred while trying to load the workbook "/views/Book3". The load was not able to complete successfully.
The same ODBC DSN that exists on your desktop machine to connect to data needs to exist on Tableau Server so Tableau Server can connect to data. It appears that you don't have a matching ODBC driver and/or DSN on the Server, or it is named differently than on your desktop.