Documentum

Documentum is an enterprise content management platform. Its functionality is made available through application programming interfaces (API).

Most of the customisation in the basic product is done using the DFC (Documentum Foundation Classes), a comprehensive collection of Java APIs. Customisation can be done via configuration, particularly through the extension products D2 and xCP. These additions aim to provide faster ways of building applications based on document types and metadata, and business processes, respectively.

---

Authentication Connection

This connector require an Authentication Connection to function. Authentication connectors are used to authenticate repository/output connections that need certain authentication fields like access tokens or refresh tokens.

Authentication Connections Overview

Configuration

• Name: Unique name for connection

• Username: Username to authenticate with

• Password: Password to authenticate with

• Collection: The default collection name

• Doc Broker: Documentum Doc Broker

• Doc Base: Documentum Doc Base

• Server Port: Port number

---

Discovery Instance

Configuration

• Name: Unique Name for the Discovery Connection to identify it in the UI.

• Authentication Connection: A predefined connection for authentication.

• Ignore Types: Comma delimited list of types to ignore. Note that you can have regex as well. So to ignore all types with "workflow" in the name, you would enter(.)workflow(.) into the ignore types textbox.

• Doc Base: Documentum Doc Base

• Server Port: Port number

• Doc Broker: Documentum Doc Broker

---

Integration Connection

Every job requires an integration connection for both the source repository connection and the output connection. Also known as input an output connections. Their job is to query or crawl remote systems for files, folders, metadata, versions, and renditions. . In repo mode, it will retrieve list items and all of their relevant metadata from a list or library on the specified site. In output mode, the connection will write content and assign the mapped content type (from type mappings), or simply leave the new list item as a Document. Click here for more information on setting up an integration connection.

There are no fields to configure in an integration connection.

Guide toIntegration connections

The Documentum DFC (Documentum Foundation Classes) Integration Connection is for retrieving content, and it's associated metadata from a Documentum Repository based on root folder, content type and document type. 3Sixty is currently compatible with Documentum v5 and higher.The Documentum Integration Connection utilises the DFC library along with DQL (Documentum Query Language) to sync/integrate content, and it's associated metadata to Documentum. 3Sixty is currently compatible with Documentum v5 and higher.

---

DFC Query Repository Connector

There is a new Documentum connector called the DFC Query Connector it's query based, not folder crawl based

Configuration

• Query: this is how you get docs, needs to be a full query that works in Documentum.

  • You need the i_chronicle_id, and it should be unique, so DISTINCT i_chronicle_id

  • If you want to track links as relationships you can add this to the select part of the query: i_reference_cnt

• Worker Count: number of workers. These will go and get each document, and it's versions, metadata, renditions, permissions, etc... essentially think of a worker as a concurrent user, though because of queries that need to be run it could result in more than one connection to Documentum.

• Document Queue Size: the internal queue we use for documents. These will just be document ids that will be picked up by workers and then resolved

  • If there are a lot of files in folders this will speed things up a lot to have folders in cache, but you don't want the cache too big, or it will take up a lot of memory. We suggest 1000-10000 as the optimal number depending on your system.

• Cache Options Tab: Number of Items in Cache: this is a folder cache where we keep the properties and info for folders this is used to get the document path and to get folder properties if that option is checked

---

Job Configuration

A 3Sixty Job is the process of moving or syncing content (including versions, ACL's, metadata) from one CMS (content management system) to another. Add tasks to your job to have better control over how your data gets migrated. Click here for details on how to set up an integration job.

Guide to Integration jobs

Repository Run Options:

• Query: this is how you get docs, needs to be a full query that works in Documentum.

  • You need the i_chronicle_id, and it should be unique, so DISTINCT i_chronicle_id

  • If you want to track links as relationships you can add this to the select part of the query: i_reference_cnt

• Content Max Length: Max Document Size Allowed, set to 0 to allow any sized document.

• Document Queue Size: the internal queue we use for documents. These will just be document ids that will be picked up by workers and then resolved

  • If there are a lot of files in folders this will speed things up a lot to have folders in cache, but you don't want the cache too big, or it will take up a lot of memory. We suggest 1000-10000 as the optimal number depending on your system.

• Max Document Retries: How many times to attempt a document before erring.

• BFS Integration: Check if output connector is BFS (Bulk File System).

• Include Parent Folder Properties: Check to include

• Parent Folder Properties: The number of levels of parent properties you want. 1 is the parent, 2 is the parent and grandparent, etc...

• Include ACLs: Check box to include

• dctm.includeFoldersDesc: Check box to include the folder description.

• Filesystem Staging Location: Enter a location on the filesystem to stage documents or leave blank to use in-memory staging.

• Use Mounted Drive for Binary: Check to use a mounted drive to retrieve binary using getPath on DFC Document.

• All versions: Check to retrieve all versions of a Document.

• Use Renditions: Check to retrieve the renditions of the document.

• Ignore Use Renditions Mime Types: Comma delimited list of mime types to ignore using renditions.

• Use First Matching Rendition as Binary: Check to use the first Rendition that matches as the Document Binary (Include Binaries and Use Renditions also have to be checked)

• First Rendition MimeType to match and use as Binary:

  • If the Use First Rendition as Binary box is checked, this field is the MimeType of the Rendition to match (defaults to application/pdf if left blank or fed invalid value).

  • If ANY MimeType to Match is acceptable EXCEPT a specific MimeType. Use: NOT(mimetype) where mimetype is the mimetype you would like to only have a rendition and NOT the binary

  • (e.g. NOT(application/pdf) will use the first rendition that is NOT of the mimetype application/pdf.

Repository Cache Options

Max Number of Items in Cache:Maximum number of folders to keep cached

---

Output Specifications

When using this connector as a file destination, filling out the following fields will tell 3Sixty where you want the files integrated to.

Configuration

• Version Label Field: Source field containing version label

• Root Path: This is the root path / cabinet to start writing content to. Note that any subsequent folders that do not exist will be created. Defaults to "/"

• Content Type Rule: This is the DQL to find the Documentum Content Type (dm_format object) for a given extension and or mime type using content specific parameters. This is done as Documentum may have more than one content type per extension and or mimetype. If more than one dm_format is returned in the DQL result, then the first one will be used.

  • dos_extension --> Query Parameter: ${extension}

    • Example: select name from dm_format where dos_extension = '${extension}'

  • mime_type --> Query Parameter: ${mimeType}

    • Example: select name from dm_format where mime_type= '${mimeType}'

  • is_hidden

    • Example: select name from dm_format where mime_type= '${mimeType}' and dos_extension = ${extension} and is_hidden = false

  • can_index

    • Example: select name from dm_format where mime_type= '${mimeType}' and dos_extension = ${extension} and can_index = true

Mapping

3Sixty Mapping gives you the ability to map your content types and metadata from one system to another.

There are two places in 3Sixty where you can set up mappings:

• At the top of the mapping tab you can select from saved mappings

• Creating a unique mapping based on your connectors.

Guide to 3Sixty Mapping

Tasks

Job tasks also known as processors provide a processing pipeline for documents and metadata. Post processors can also be added as a task to run after the files are processed.

Click here for a list of all the tasks you can add to your integration job.

---

Troubleshooting

Note: There are known compatibility issues with the external DFC dependencies and Java 11. If you are using Java 11 and experience start-up errors after adding the external dependencies, please consider using Java 8.

---

Content Service Connector

Note:  An Auth connector is not needed for the Documentum DFC content service connector. For Security Mode, choose Service Provided Credentials

Managing Permissions with Documentum DFC Content Services

As of Version 2.7.6, this connector also offers permissions support using the /acls content service endpoint.

The API supports GET, POST, and DELETE calls.

All the endpoints take the "id" parameter, which takes the form of a string.

Supported Methods

• checkIn

• checkOut

• createFile

• createFolder

• createVersion

• deleteACL

• deleteFolder

• deleteObjectByID

• deleteVersion

• getACLs

• getFileContent

• getObjectProperties

• getTypes

• getVersionContent

• getVersionProperties

• listFolderItems

• listVersions

• revertVersion

• setACLs

• updateFile

• updateProperties

---

API Keys

Documentum DFC Connector:Read=true:Write=true:MIP=false

Repo (Read) Specs

Key	Description	Data Type
specdfcquery	Query	String
specmaxdoclength	Content Max length	Long
dfcqueuesize	Document Queue Size	Long
maxretries	Max Document Retries	Integer
specbfsmigration	BFS Migration	Boolean
specinheritparentprops	Include Parent Folder Properties	Boolean
parentfolderdepth	Parent Folder Properties Depth	Integer
specincludeacls	Include ACLs	Boolean
specincludefolders	Include Folders	Boolean
specfsstaging	Filesystem Staging Location	String
specusemountdrive	Use Mounted Drive for Binary	Boolean
specallversions	All Versions	Boolean
specuserenditions	Use Renditions	Boolean
specignoreuseren	Ignore Use Renditions Mime Types	String
specuserenditionasbinary	Use First Matching Rendition as Binary?	Boolean
specfirstrenditionmimetouse	First Rendition MimeType to match and use as Binary	String
processDeletes	Process Deletes?	String
dfcDeleteQuery	Process Deletes Query	String
dfcDeleteQueryStartDate	Start Date Range for Process Deletes Query (replaces first %s)	String
dfcDeleteQueryEndDate	End Date Range for Process Deletes Query (replaces second %s)	String
specdfccacheitems	Max Number of Items in Cache	Integer

Output (Write) Specs

Key	Description	Data Type
versionLabelField	Version Label Field	String
rootPath	Root Path	String
contentTypeRule	Content Type Rules	String
multivalueseparator	Multi-value field separator	String

---

Looking to integrate with Documentum? We can help.