Create DSN for MySql running at localhost

JDBC, ODBC, SQL, Ensemble


We have a local running WINDOWS MySql, which we connect to via MySQL Workbench  :::Mysql@localhost:3306

We have java :: C:\Program Files\Java\jdk1.8.0_221\bin


How do we create a DSN that we can use in the business service settings to connect and run our query?

Do we make a ODBC or JDBC DSN.

What settings for either 


  • 0
  • 0
  • 46
  • 0
  • 1


The way I've done this before was to create a JDBC Gateway Connection. And I had to add a business service to the production for a Java Gateway Service. This needed to be in place in order for my JDBC connection to actually work.