I downloaded the latest version of sqljdbc provided by Microsoft (
Then I tried connecting the Azure databases with the different drivers using Squirrel (
- sqljdbc42.jar : KO
- sqljdbc41.jar : OK -> I get the list of databases and their tables ONLY if I add the database name in the connection URL.
So I went back to Stambia, added the same sqljdbc41.jar to the Microsoft SQL driver, then added the database name to the URL and it worked!
BUT the thing is, if I keep the metadata like this, I will need to create a metada for each database I need (and each environment DEV, PROD,..)..
Maybe there's an other way?