I'm a new Gallery Admin and I expect I'm missing the answer somewhere, but I searched the community and didn't find a solution. I need to build a Gallery Data Connection to MySQL. I have the Simba MySQL ODBC connection set up on the Server, and I can connect Alteryx to a MySQL environment, but only if I enter the all connection info directly into the ODBC configuration, (host, username, [password,] port, catalog). If I embed the connection credentials into the ODBC connection doesn't that mean that either a) all MySQL connections on the gallery would connect to the same MySQL instance, or b) if gallery users wanted to access multiple distinct MySQL environments, I'd have to created multiple Simba MySQL System DSN's?
Is it possible to set up a generic Simba MySQL ODBC entry, and pass the specifics of each connection to it using a connection string in the Alteryx connection, as I've done with other Data Connections? I've seen some documentation that gets me close () but one part of the config I need to enter for this connection is "Category" and any way that I've tried adding that to the connection string, breaks.
Thanks for any help you can offer.
-Jack
