Data Connection Service

Introduction

By enabling the Database Connector Service (CDS), SQL access is made possible to programs and services from the outside of the firewall.The Data Connection Service is used to provide Http communication to services placed outside the primary firewall, instead of having to allow SMB and SQL server traffic to travel through the firewall.

General

This tab resembles the property page for the service found in the services of the control panel. Each of the settings available in each tab of this dialogue is described below.

 

Element	Description
Service status	Status of the Data Connection Service. Equivalent to services in the control panel.
Service Name	The name of the service used by the operating system.
Display name	The name you will see in services in the control panel.
Description	Description of the service.
Startup type	The type of service. This can be either; automatic, manual, or disabled. The default value is automatic.
Last heartbeat	This is a timestamp for the last synchronization activity.
Path to executable	The full path to the program that is started by the service.

Database

On the database tab, you can change the authentication method to the SQL server.

Element	Description
SQL server	The SQL server that the Data Connection Service connects to.
SQL database	The SQL database that holds the CapaInstaller Management Solution database.
Update	Clicking on this button the CIDal settings.xml is updated with the correct database.
Use Windows authentication	Instructs Data Connection Service to establish a database connection by identifying itself with the computer account.
Use SQL authentication	When this radio button is selected, the Data Connection Service will connect to the database with the credentials in the user name and password fields.
User name	The user name used to connect to the database when SQL authentication is selected.
Password	The password that goes with the user name stated above.

Config

On the config tab, you can change the URL and certificate.

Element	Description
Certificate	The certificate used to validate the connection.
Thumbprint	The certificate thumbprint.
Port Number	The HTTPS port number the service listens on.
Http Port	The port number used for HTTP communication.
Public URL	This URL is used to communicate with the service.

Element	Description
OK	Clicking this button commits any changes that you may have made and closed the dialog.
Cancel	Cancels any changes made and closes the dialog.