Skip to main content
Version: Latest (4.55.2.)

OpenText eDOCS DB source connector

The OpenText eDOCS database connector uses a direct connection to the database. This connector has only been tested with eDOCS version 16.3 and currently only MSSQL and Oracle databases are supported.

note

To use this connector with an Oracle database, you will need to install some additional Oracle drivers. Please refer to the DB Query Component documentation for more information.

Features​

  • Exporting content structure
  • Exporting versions
  • Exporting binaries
  • Exporting users and groups
  • Exporting relationships
  • Exporting ACLs

Settings​

mongoConnection​

The Mongo connection string including the database name to connect to.

eDOCSDBConnectionString​

The connection string to the eDOCS database.

Example: mssql://USERNAME:PASSWORD@edocs.yourcompany.com:1433/dm_default

eDOCSDBConnectionOptions​

The connection options to connect to the eDOCS database. Only required for MSSQL databases.

Example:

{
  "options": {
    "trustServerCertificate": true,
    "tdsVersion": "7_1",
    "encrypt": false,
    "packetSize": 16368
  }
}

eDOCSDBEngine​

The engine of the eDOCS database. Currently, only MSSQL and Oracle are supported.

eDOCSDBOwner​

The owner of the eDOCS database schema. Only required for Oracle databases. Example: DOCSADM.

eDOCSFileStoragePath​

The path where eDOCS stores the files. Example: C:/edocs/DM_DEFAULT.

pageSize​

Specifies the page size number that is used when paginating.

Example: 10000

selectedDocNumbers​

An array containing the eDOCS document numbers to be retrieved. When the array is empty, all objects will be retrieved.

Example: [279,280,281,282,283,284,285,287]

permissionMapping​

An object containing a mapping from the database integer value of a permission to an array of human readable permissions. Missing mappings are logged as a warning when the ACLs are retrieved and should be added to this object.

origin​

Specifies the origin of the document in the Content Store.