ConnectionType Table

ConnectionType is a static table storing the types of connection that can be used to import data into FlexNet Manager Suite.

Table 1. Database columns for ConnectionType table

Database Column

Details
ConnectionTypeID

Type: integer. Key. Generated ID

A unique identifier for each ConnectionType. Possible values and the corresponding default strings are:

  • 1 = SQL Server
  • 2 = Other (the inventory source is another type of data store, like an Excel sheet or MS Access database).
  • 5 = PowerShell
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a connection type. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

The text to display if the type resource string has no translation.