Use Azure SQL Database about sndml3 HOT 5 CLOSED

Hi.

My understanding is that Azure SQL is compatible with Microsoft SQL Server; so I would expect the mssql JAR file to work with Azure SQL, although I have not tried it. I am not sure about the URL.

I can tell you from my experience with AWS that you will get optimal performance if you run sndml on an Azure Linux or Windows server. The application is very chatty with the database, so you should run sndml and the database in the same cloud.

When you get it working, please update this issue with any notes. If if does not work, please update this issue with the error message.

Thanks.

from sndml3.

I don't ave any mssql jar.
I will have a look tomorrow morning, thank you :)
I run in an ubuntu vm in azure so it should be good !

from sndml3.

ok I re-executed maven with the "github.release" profile and I got the ms sql jar.
No I'm working on the config file lol

from sndml3.

ok it work with this url string :

datamart.url=jdbc:sqlserver://xxx.database.windows.net;databaseName=sndm;

Thank you it's resolved :)

from sndml3.

Excellent. Glad to know that worked!

If you download the zip file from https://github.com/gflewis/sndml3/releases then mssql.jar is included, but it is not in the default maven build, as you discovered. I'm glad you were able to figure out the "github.release" part.

Thanks.

from sndml3.