Set Up an SKP System as a Construct Data Source

SQL Server connections in the Syniti Knowledge Platform can be associated with a data source in Construct. This setup allows the pages within a WebApp that is connected to the specified data source to use the database connection from the system. With this linkage, users enter the connection information in the Syniti Knowledge Platform instead of in Construct.

Setting up a Syniti Knowledge Platform system as a Construct data source has a few advantages:

• The connection information can be utilized by multiple modules.

• There is one centralized location to enter connection information.

To set up a system as a Construct data source:

1. Log in to the Syniti Knowledge Platform.

2. Create a system.

3. Create a connection where the

   1. Connection Type is SQL Server

   2. Hostname, Port, Username, Database, SKP Connectors fields are populated

      Note

      Database is a required parameter in order for Construct to know which database to use when querying tables/views.

   3. Usage is Construct

      Note

      Instead of creating a new connection, users can edit an existing connection. If an existing connection is edited clear the cache by clicking the Clear Cache button on the Parameters page in Construct.

4. Access Construct.

5. Select Admin > Data Sources in the Navigation menu.

6. Register a data source where the

   1. Connection ID is the system connection created with the Usage set to Construct

   2. Connector ID is the SKP connector that allows the Syniti Knowledge Platform to communicate with Construct. If a Connector ID is not specified, the Preferred SKP Connector (from the system connection in the Syniti Knowledge Platform) is used.

Note

Refer to Register a Data Source for more information.