Stores the configuration for AgileConnectors, most importantly for NLB deployments.
Columns
| Column Name
| Definition |
|---|
APP_NAME |
- Function:
- The name of the external service associated with the AgileConnector.
- Values:
-
- Analytics - The Analytics Center AgileConnector is used to generate reports.
- ADSync - The ADSyncModule AgileConnector is used to synchronize Active Directory users and groups.
- DBSync - The DBSyncModule AgileConnector is used to synchronize database users and groups.
- MailApproval - the Email Approval AgileConnector is used to approve or reject tasks.
- Event Service - The Event Service AgileConnector is used to initiate the process on receiving emails,
record inserted in the table, scheduled time, or on file drop.
- SMS Service - The SMS AgileConnector is used to receive SMS messages
for responses such as approval or rejection of the task.
- SAPConnector - The SAP AgileConnector integrates with SAP components and holds the integrated
connector application names.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- No
- Primary Key:
- Yes
- Foreign Key:
- No
|
CATEGORY |
- Function:
- Reserved for future use.
- Values:
- Null
- Data Type:
- nvarchar
- Size:
- 64
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
CFG_XML |
- Function:
- Stores the configuration changes made to the
integrated or external application.
This column contains an XML only value if a connector is added and
configuration changes are made and saved.
- Data Type:
- ntext
- Size:
- Null
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_DATE |
- Function:
- The date the AgileConnector configuration was created.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_BY |
- Function:
- The user who created the AgileConnector.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
CREDENTIAL |
- Function:
- The SharePoint impersonator user name.
- Values:
- The user name of the SharePoint impersonator that is configured for AgilePoint NX.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DESCRIPTION |
- Function:
- A free text description for the AgileConnector.
- Data Type:
- nvarchar
- Size:
- 2048
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
LAST_UPDATED_BY |
- Function:
- The user who last updated the AgileConnector.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
LAST_UPDATED_DATE |
- Function:
- The date the AgileConnector configuration was last modified.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
TYPE_INFO |
- Function:
- The metadata information about the AgileConnector
assembly and class name.
- Values:
-
- AgilePoint.AgileConnector.Analytics.APCConfiguration
- ActiveDirectorySynchronizer.GroupMemberSynchronizer
- AgilePoint.AgileConnector.Analytics.APCConfiguration
- Ascentn.AgileConnector.MailApproval.APCDaemon
- AgilePoint.AgileConnector.MicrosoftTeams.MicrosoftTeams
- AgilePoint.AgileConnector.SMSService.SMSServiceAgileConnectorDaemon
- Data Type:
- varchar
- Size:
- 1024
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
Relationships
| Table Name | Relationship |
|---|
| None | Not applicable |
