I need to create a metadata on a Microsoft Azure database.
I can connect to the server, then I have retrieved the database names, but when I try to retrieve the Schema names I got the following error :
I checked on internet and here's what I found :
So, I tried to change the jdbc lib with the ones (sqljdbc.jar and sqljdbc4.jar) supplied by Microsoft in their update pack, but it's still not working..
Is there a specific JAR or plugin to use Azure with Stambia?
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,..)..
It looks like accessing Azure's catalog is not the same as accessing SqlServer's catalog:
They say "you should connect to the master database to call SQLServerDatabaseMetaData.getCatalogs". I guess this explains why you need to specify the db in the JDBC URL.
We will have to take a closer look to see if there is another way. And maybe this will take a new dedicated Technology entry in Stambia. I can't say yet