search

gflewis / sndml3

ServiceNow Data Mart Loader: an application to load SQL databases from ServiceNow
MIT License
30 stars 19 forks source link

Use Azure SQL Database #7

Closed nlejeune closed 6 years ago

nlejeune commented 6 years ago

Hi,

Thank you for the great work. It worked with a mysql database by using the command : java -jar sndml-3.0.2-mysql.jar -p properties.conf -t task_load.yaml

Is this possible to use an Azure SQL server instead of mysql ? what will be the datamart.url parameter :

datamart.url=jdbc:sqlserver://xxx.database.windows.net:1433/database_name ?

If I execute : java -jar sndml-3.0.2.jar -p properties_sql.conf -t sys_user I got : "Error: Could not find or load main class fully.qualified.MainClass"

gflewis commented 6 years ago

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.

nlejeune commented 6 years ago

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 !

nlejeune commented 6 years ago

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

nlejeune commented 6 years ago

ok it work with this url string :

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

Thank you it's resolved :)

gflewis commented 6 years ago

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.