OpenText CS DB source connector
The OpenText CS database connector uses a direct connection to the database. It supports all OpenText Content Server versions running on a MSSQL or Oracle database.
Features
- Exporting content structure
- Exporting versions
- Exporting categories
- Exporting binaries
- Exporting principals
- Exporting record details (record management)
- Exporting classifications
- Exporting audit logs
- Exporting holds
- Exporting relationships
- Other custom metadata than categories and record details
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
OTCSDBConnectionString
The connection string to the OpenText CS database.
Example: mssql://USERNAME:PASSWORD@otcs.yourcompany.com:1433/otcs
OTCSDBEngine
The engine of the OpenText CS database. Currently, only MSSQL
and Oracle
are supported.
OTCSDBOwner
The owner of the OpenText CS database schema. Only required for Oracle
databases. Example: DMS
.
providerDataMapping
Specifies the mapping of the provider data. The provider data of an object contains the reference to the file on the file system. As the provider data itself only contains a relative path, the absolute path is constructed by combining the provider data with an UNC path based on the storage provider name and sub provider name.
A list of logical providers can be obtained by running the following query on the OpenText CS database:
SELECT * FROM <OTCSDBOwner>.KINI WHERE inisection = 'Livelink.LogicalProviders'
Example of provider data:
A<1,?,'providerInfo'='0000\\003\\3193.dat','storageProviderName'='ExtShared','subProviderName'='Default'>
Example of provider data mapping:
{
"ExtShared" : {
"Default" : "\\\\otcs\\data01"
}
}
pageSize
Specifies the page size number that is used when paginating.
Example: 250
enableRecordManagement
Enables extracting the record details on containers and records. Can either be true
or false
.
enableAuditLogs
Enables extracting the audit logs on containers and records. Can either be true
or false
.
enableHolds
Enables extracting the applied holds on containers and records. Can either be true
or false
.
enableRelations
Enables extracting the cross references on containers and records. Can either be true
or false
.
rootIds
A list of comma-separated rootIds. The id of the Enterprise workspace is typically 2000
.
Example: [1448,1461]
origin
Specifies the origin of the document in the Content Store.