Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

Use a MSSQL database in Locator Uploader Command Line Utility

Jump to Best Answer
  • 1.  Use a MSSQL database in Locator Uploader Command Line Utility

    Posted 08-13-2020 06:41
    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
    ------------------------------


  • 2.  RE: Use a MSSQL database in Locator Uploader Command Line Utility
    Best Answer

    Posted 08-16-2020 22:04
    Edited by Miquel Roy Sunyer 08-19-2020 11:48
    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
    ------------------------------



  • 3.  RE: Use a MSSQL database in Locator Uploader Command Line Utility

    Posted 08-19-2020 11:48
    Edited by Miquel Roy Sunyer 08-19-2020 11:47
    Hi Duri, that worked perfectly fine.

    Thanks a lot,

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