Setting Up a Database for Columnar Store

If you want to use columnar tables but your database for Landmark is not Microsoft SQL Server 2016 or higher, but you have a Microsoft SQL Server 2016 or higher database available, you can use this procedure to set up that database for columnar tables for Landmark.

This procedure consists of creating several parameters in the Configuration Parameters form in the Landmark Administration Console.

  1. Log in to the environment data area (gen).
  2. In your Landmark UI, navigate in the Administration Console to Other > System Configuration Parameters > By Residence Category.
  3. On the Configuration Parameter Categories form, in the top list section, filter on and select “Analytics.”
  4. On the Available Keys By Runtime Component tab, select each key one at a time that is listed in the table below, click Create Parameter, specify the appropriate value, and click OK.
    Key Description
    ColumnarDatabaseName The columnar database name.
    ColumnarDatabaseType The columnar database type, such as msf2016.
    ColumnarServer The columnar database server (in the format serverName\instanceName).
    ColumnarUsername The username used to log in to the columnar database.
    ColumnarPassword The password used to log in to the columnar database.
    ColumnarPort The port used to connect to columnar database. You only need to set this parameter if the port is different than the default port.
    ColumnarMultiSubnet Whether the columnar database is in a multi-subnet setup or not. You only need to set this parameter if the database is in a multi-subnet setup.