Problems with Workbench, ODBC, MySQL and the data specialist exam
I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/data-specialist-practical-test-2h
The task wants you to use Workbench 5 to set up a MySQL job and then import the data from Workbench to Domo. The connection to Domo from Workbench works fine. When I use the parameters for the MySQL server, I get the following error:
[03.31.21 5:19:30 AM] Value cannot be null.
Parameter name: input
I have tried using the System DSN that has been configured and also the Connection Builder using the parameters mentioned. The problem is always the same. I know the ODBC connection works as I can pull a table into Access using the same Domo DSN Connector.
Just wondering if anyone who tried taking the exam ran into the same problems?