Spectrum Spatial (SSA/LIM)

Hello, 

For years, we've been using the Locator Uploader CommandLine Utility to upload addresses that can be search in the Analyst's search bar, using a csv file as opposed to a database source.

Now we're exploring the option of uploading the addresses straight from the database, instead of creating a csv and uploading it. This would save a step in the overall process.

However, I am not sure which parameters should I use in the configuration.properties file in order to establish connection with a MSSQL Server database.

These are the parameters as defined in the configuration.properties file, with Oracle/mysql examples provided:
################ Database to connect to. #################
# User Name e.g. Admin
database.admin.user=root
# Password e.g. Password
database.admin.password=root
# Driver class e.g. com.mysql.jdbc.Driver
database.driver.class.name=com.mysql.jdbc.Driver
# JDBC URL e.g. jdbc:mysql://mymachinename:3306/singleline>
database.driver=jdbc:mysql://mymachinename:3306/Database

Apart from not knowing which parameters to use to get to the MSSQL Server database, there doesn't seem to be anywhere to specify the server and the name of the database. Also, haven't been able to find it in the documentation. Can you help?

------------------------------
Miquel Roy Sunyer
Kirklees Council
HUDDERSFIELD
------------------------------

Hi Miquel,

I believe you need to use these settings but its been a while so I may be missing something

database.admin.user=?????
database.admin.password=?????
database.driver.class.name=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.driver=jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;

If you have a named SQL instance you will need to include that rather than the port number
database.driver=jdbc:sqlserver://localhost;instanceName=instance1;databaseName=AdventureWorks;

------------------------------
Duri Bradshaw
Spatial IT Consultant
Insight GIS
------------------------------

Original Message:
Sent: 08-13-2020 06:40
From: Miquel Roy Sunyer
Subject: Use a MSSQL database in Locator Uploader Command Line Utility

Hello,

For years, we've been using the Locator Uploader CommandLine Utility to upload addresses that can be search in the Analyst's search bar, using a csv file as opposed to a database source.

Now we're exploring the option of uploading the addresses straight from the database, instead of creating a csv and uploading it. This would save a step in the overall process.

However, I am not sure which parameters should I use in the configuration.properties file in order to establish connection with a MSSQL Server database.

These are the parameters as defined in the configuration.properties file, with Oracle/mysql examples provided:
################ Database to connect to. #################
# User Name e.g. Admin
database.admin.user=root
# Password e.g. Password
database.admin.password=root
# Driver class e.g. com.mysql.jdbc.Driver
database.driver.class.name=com.mysql.jdbc.Driver
# JDBC URL e.g. jdbc:mysql://mymachinename:3306/singleline>
database.driver=jdbc:mysql://mymachinename:3306/Database

Apart from not knowing which parameters to use to get to the MSSQL Server database, there doesn't seem to be anywhere to specify the server and the name of the database. Also, haven't been able to find it in the documentation. Can you help?

------------------------------
Miquel Roy Sunyer
Kirklees Council
HUDDERSFIELD
------------------------------

Hi Duri, that worked perfectly fine. 

Thanks a lot,

------------------------------
Miquel Roy Sunyer
Kirklees Council
HUDDERSFIELD
------------------------------

Original Message:
Sent: 08-16-2020 22:04
From: Duri Bradshaw
Subject: Use a MSSQL database in Locator Uploader Command Line Utility

Hi Miquel,

I believe you need to use these settings but its been a while so I may be missing something

database.admin.user=?????
database.admin.password=?????
database.driver.class.name=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.driver=jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;

If you have a named SQL instance you will need to include that rather than the port number
database.driver=jdbc:sqlserver://localhost;instanceName=instance1;databaseName=AdventureWorks;

------------------------------
Duri Bradshaw
Spatial IT Consultant
Insight GIS

Original Message:
Sent: 08-13-2020 06:40
From: Miquel Roy Sunyer
Subject: Use a MSSQL database in Locator Uploader Command Line Utility

Hello,

For years, we've been using the Locator Uploader CommandLine Utility to upload addresses that can be search in the Analyst's search bar, using a csv file as opposed to a database source.

Now we're exploring the option of uploading the addresses straight from the database, instead of creating a csv and uploading it. This would save a step in the overall process.

However, I am not sure which parameters should I use in the configuration.properties file in order to establish connection with a MSSQL Server database.

These are the parameters as defined in the configuration.properties file, with Oracle/mysql examples provided:
################ Database to connect to. #################
# User Name e.g. Admin
database.admin.user=root
# Password e.g. Password
database.admin.password=root
# Driver class e.g. com.mysql.jdbc.Driver
database.driver.class.name=com.mysql.jdbc.Driver
# JDBC URL e.g. jdbc:mysql://mymachinename:3306/singleline>
database.driver=jdbc:mysql://mymachinename:3306/Database

Apart from not knowing which parameters to use to get to the MSSQL Server database, there doesn't seem to be anywhere to specify the server and the name of the database. Also, haven't been able to find it in the documentation. Can you help?

------------------------------
Miquel Roy Sunyer
Kirklees Council
HUDDERSFIELD
------------------------------