Database Tables and Stored Procedures Used by the Content Server Connector

The LiveLink Connector uses a direct connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors) to the LiveLink database (Oracle or MSSQL) to enumerate and/or retrieve the data to index.

The list below enumerates the tables accessed by the connector.

Table Name	Description
DTree	Main table. All general information about items is stored here.
BLOBDATA	The document content and serialized category definitions are stored in this table.
DTREEACL	The IDs of the rights and permissions for items
LLATTRDATA	Metadata Provides context with details such as the source, type, owner, and relationships to other data sets. Metadata provides details around the item being crawled by Connectivity Hub. values and data types
RM_CLASSIFICATION	Record metadata
RIMSNODECLASSIFICATION	Record metadata
RM_RECORDSOFFICERS	Record metadata
RM_OBJECTHOLD	Information about Holds that are assigned to the record objects
RM_DOCRECTYPEF	Information about Holds that are assigned to the record objects
RM_DOCXRE	Record metadata
DAuditNew	Audit table, where information is stored about all (or enabled) LiveLink events
KUAF	Information about LiveLink users and groups
KUAFChildren	Information about LiveLink users and groups
KINI	System configuration information (servers, providers, add-ons, and so on)
DVERSDATA	Information about item versions
CATREGIONMAP	Information about categories
ProviderData	Information about provider objects. This object controls the storage behavior for item content and other related system bits.
DAttributes	Information about the attributes or properties of documents or files like size, creation date, author, etc.
DCatAttrs	Information about the attributes or properties associated with categories in the content management system, such as the name, description, and other metadata. It is used to manage and organize content based on categories.
DCategories	Information about the categories used to organize content within the system. It includes details such as the category name, description, and other metadata, and is used to classify and organize content for easy retrieval and management.
DispositionHold	Information about legal holds placed on content in the system. It includes details such as the hold ID, the date it was placed, the reason for the hold, and the content items that are affected. This table is used to ensure that content is not deleted or modified during legal proceedings or investigations.
DTreeAncestors	Information about the hierarchical relationships between content items in the system. It includes details such as the parent-child relationships between nodes in the content tree, and is used to quickly retrieve content items and their ancestors.