Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
type | Yes | - | No | The value must be " |
documentum-DQL". | " |
documentum-DQL" | |||||
description | Yes | - | No | Name of the connection object. | " |
documentum-DQL connection" | |||||
credential | Yes | - | No | The ID of the credential to be used with this seed. The credential type must match the seed type. | "602d3700-28dd-4a6a-8b51-e4a663fe9ee6" |
properties | Yes | - | No | Configuration object | |
webtopUrl | Yes | - | No | Hostname where the shared directory is located. | "shared.example.com" |
serverUrl | Yes |
- | No |
The default URL for your Documentum server. | " |
dctm://server-name:port" |
dfcPropsFilePath | Yes | - | No |
Specify the filepath where the dfc.properties file is located. Typically, this is placed in the "config" directory inside your Aspire Home. | "config/dfc.properties" | ||
errorTolerant | No | false | No |
If selected, the connector |
will index only the item's metadata in case there is no document content available. If not selected, an error will be reported when there is no content (the item won't be indexed). | true / false |
useRenditionType |
No | false | No |
If selected, include a list of rendition formats for documents to be extracted and indexed. | true / false |
renditionType | No |
[] |
Yes | If enabled, the crawl will stop if there is an error on the scan phase. |
"html,jpg" |
useAttributes |
No | false | No |
If selected, include a list of attributes names to index |
. If not selected, all document/folder's metadata fields will be indexed. | true / false |
attributeList | No | [] | Yes |
resolveSIDs
Check to resolve retrieved SIDs from owner, group and ACL.
addACLSID
addACLEncodedSID
addACLFlags
addACLType
addACLAccessMask
enableDFS
connectionTimeout
maxRetries
baseBackoff
backoffMultiplier
lastAccessedUpdates
[ ]
List of metadata field names to index separated by a comma (','). | "object_name,r_object_type,r_creation_date,r_modify_date,i_chronicle_id,title" | ||||
fullSelectDQL | No | - | No | Full crawl SELECT statement. Aspire needs at least these key fields in the SELECT: r_object_id and i_chronicle_id. This query will return the object_id value of all items that will be crawled and indexed. | SELECT r_object_id, i_chronicle_id FROM dm_document |
incrementalStrategy | Yes | - | No | Incremental Strategy. | Audit trail / Event queue |
incrementalSelectDQL | Yes | - | No | Incremental crawl SELECT statement. Aspire needs at least these key fields in the SELECT: r_object_id and i_chronicle_id. This query will return the object_id value of all items that will be crawled and indexed. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, i_chronicle_id FROM dm_document WHERE r_modify_date > ${crawlTimeStamp} |
selectAuditAclChangesDQL | No | - | No | Audit ACL updates SELECT statement for incremental. Aspire needs at least these key fields in the SELECT - r_object_id and chronicle_id. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, chronicle_id FROM dm_audittrail |
selectAuditDeletesDQL | No | - | No | Audit deletes SELECT statement for incremental. Aspire needs at least these fields in the SELECT - r_object_id and chronicle_id. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, chronicle_id FROM dm_audittrail WHERE (event_name = 'dm_destroy' OR event_name = 'dm_prune') AND time_stamp_utc > ${crawlTimeStamp} |
selectAuditSafeguardDQL | No | - | No | Check to include SID value on ACL output.Audit safeguard SELECT statement for incremental. The variable ${auditChronicleId} will be expanded for current audit chronicle ID. | SELECT r_object_id FROM dm_document WHERE i_chronicle_id = ${auditChronicleId} AND -whereFromFullCrawl- |
deleteAuditItems | No | false | No | If selected, audit items used to track document changes will be deleted after incremental. | true / false |
repositoryZoneId | No | - | No | Valid repository time zone ID. Not mandatory. UTC is the default value | Europe/Minsk, UTC+3, UTC-6 |
selectEventsSafeguardDQL | No | - | No | Event safeguard SELECT statement for incremental. Not mandatory. The variable ${eventId} will be expanded for current event itemId. | SELECT i_chronicle_id FROM dm_document WHERE r_object_id = ${eventId} AND -whereFromFullCrawl- |
deleteEvents | No | - | No | List of delete events names separated by comma ','. | "dm_destroy, dm_prune" |
maxFileSize | No | Unlimited | Yes | Specify the limit for the size of the content to be crawled. Value should be submitted as MB. Type UNLIMITED if you do not wish to set a max content size. | "10" |
Code Block | ||||
---|---|---|---|---|
| ||||
{
| ||||
Code Block | ||||
| ||||
{ "type": "smb", "description": "SMB Test Connector", "credential": "2a5ca234-e328-4d40-bb2a-2df3e550b065", "properties": { "host": "192.168.0.80", "port":"445", "disableFetch": false, "verboseSMBJtype": false"documentum-DQL", "stopOnScanErrordescription": true"DQL_event_queue_connection", "indexContainerscredential": true"8153ae2e-7260-40d4-91e6-2501ce62fc91", "scanExcludedItemsproperties": true,{ "includes": ".*\\.txt", "excludesserverUrl": ".*\\.pngdctm://10.89.26.139:1489/", "fetchACLs":true, "resolveSIDs": true, "addACLSID": false, "addACLEncodedSID": false, "addACLFlags": false, "addACLType" : false, "addACLAccessMask": false, "enableDFS "dfcPropsFilePath": true, "connectionTimeout": 60000, "maxRetries": 5, "baseBackoff": 500, "backoffMultiplier": 2.0, "lastAccessedUpdates": false, "config/dfc.properties", "errorTolerant": true, "useRenditionType": true, "renditionType": "html,jpg", "staticAcluseAttributes": [{true, "nameattributeList": "test-userobject_name,", "domain": "test-domain"webtopUrl": "http://10.89.26.139:8080/da/component/main", "entityfullSelectDQL": "userSELECT r_object_id, i_chronicle_id FROM dm_document", "accessincrementalStrategy": "allow" }, {eventQueue", "nameselectEventsSafeguardDQL": "test-group", "domain": ""SELECT i_chronicle_id FROM dm_document WHERE r_object_id = ${eventId} AND -whereFromFullCrawl-", "entitydeleteEvents": "groupdm_destroy, dm_prune", "accessmaxFileSize": "denyUnlimited" } ] } } |
Field | Required | Default | Multiple | Notes | Example | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
type | Yes | - | No | The value must be "documentum-DQL". | "documentum-DQL" | ||||||
description | Yes | - | No | Name of the connection object. | "documentum-DQL connection" | ||||||
credential | Yes | - | No | The ID of the credential to be used with this seed. The credential type must match the seed type. | "602d3700-28dd-4a6a-8b51-e4a663fe9ee6" | ||||||
properties | Yes | - | No | Configuration object | |||||||
webtopUrl | Yes | - | No | Hostname where the shared directory is located. | "shared.example.com" | ||||||
serverUrl | Yes | - | No | The default url URL for your documentum Documentum server | "dctm://server-name:port" | ||||||
dfcPropsFilePath | Yes | - | No | Specify the filepath where the dfc.properties file is located. Typically, this is placed in the "config" directory inside your Aspire Home. | "config/dfc.properties" | ||||||
errorTolerant | No | false | No | If selected, the connector will index only the item's metadata in case there is not no document content available. If not selectselected, an error will be reported when there is no content (the item won't be indexindexed). | true / false | ||||||
useRenditionType | No | false | No | If selected, include a list of rendition formats for documents to be extracted and indexed | true / false | ||||||
renditionType | No | [] | Yes | If enabled, the crawl will stop if there is an error on the scan phase. | "html,jpg" | ||||||
useAttributes | No | false | No | If selected, include a list of attributes names to index. If not selected, all document/folder's metadata fields will be indexed.", | true / false | ||||||
attributeList | No | [] | Yes | List of metadata fields name field names to index separated by a comma (','). | "object_name,r_object_type,r_creation_date,r_modify_date,i_chronicle_id,title" | fullSelectDQL | No | - | No | Full crawl SELECT statement. Aspire needs at least these key fields in the SELECT - r_object_id and i_chronicle_id. This query will return the object_id value of all items that will be crawled and indexed | SELECT r_object_iddate,r_modify_date,i_chronicle_id FROM dm_document |
incrementalStrategy | Yes | - | No | Incremental Strategy | Audit trail / Event queue | ||||||
,title" | |||||||||||
fullSelectDQL | No | incrementalSelectDQL | Yes | - | No | Incremental Full crawl SELECT statement. Aspire Aspire needs at least these key fields in the SELECT - : r_object_id and i_chronicle_id. This query will return the object_id value of all items that will be crawled and indexed. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, i_chronicle_id FROM dm_document WHERE r_modify_date > ${crawlTimeStamp} | ||||
incrementalStrategy | Yes | - | No | Incremental Strategy. | Audit trail / Event queue | ||||||
incrementalSelectDQLselectAuditAclChangesDQL | Yes | - | No | Audit ACL updates Incremental crawl SELECT statement for incremental. Aspire needs at least these key fields in the SELECT: - r_object_id and i_chronicle_id. This query will return the object_id value of all items that will be crawled and indexed. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, i_chronicle_id FROM dm_audittrail document WHERE event_name = 'dm_save' AND time_stamp_utc > r_modify_date > ${crawlTimeStamp} | ||||||
selectAuditAclChangesDQL | Yes | - | No | Audit | deletesACL updates SELECT statement for incremental. | AspireAspire needs at least these key fields in the SELECT | -: r_object_id and chronicle_id. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, chronicle_id FROM dm_audittrail | (event_name = 'dm_ | destroy' OR event_name = 'dm_prune') AND save' AND time_stamp_utc > ${crawlTimeStamp}selectAuditSafeguardDQL | |
selectAuditDeletesDQL | Yes | - | No | Check to include SID value on ACL output.Audit safeguardAudit deletes SELECT statement for incremental. | The variable ${auditChronicleId} will be expanded for current audit chronicle id.SELECTAspire needs at least these fields in the SELECT: r_object_id | FROM dm_document WHERE i_and chronicle_id | = ${auditChronicleId} AND -whereFromFullCrawl-|||||
deleteAuditItems | No | false | No | Check to include Encoded SID (Base 32) value on ACL output. | true / false | ||||||
addACLFlags | No | false | No | Check to include ACL flags on ACL output. | true / false | ||||||
addACLType | No | false | No | Check to include ACL type on ACL output. | true / false | ||||||
. The variable ${crawlTimeStamp} will be expanded upon incremental start. | SELECT r_object_id, chronicle_id FROM dm_audittrail WHERE (event_name = 'dm_destroy' OR event_name = 'dm_prune') AND time_stamp_utc > ${crawlTimeStamp} | ||||||||||
selectAuditSafeguardDQL | Yes | - | addACLAccessMask | No | false | No | Check to include ACL access mask SID value on ACL output. | true / false | |||
enableDFS | No | true | No | Distributed File System (DFS) resolution | true /false | ||||||
connectionTimeout | Yes | 6000 | No | Timeout in milliseconds for each SMB request. | "6000" | ||||||
maxRetries | Yes | 5 | No | Maximum retries permitted per document. | "5" | ||||||
baseBackoff | Yes | 500 | No | Base time for the back off sleeps (in ms). | "500" | ||||||
backoffMultiplier | Yes | 2.0 | No | Multiplier factor to be used for the back off time. | "2.0" | ||||||
lastAccessedUpdates | No | false | No | Check to restore the last accessed date on the documents processed by the connector. WARNING: Requires a user with permissions for writing. This is not supported by windows. | true /false | staticAcl | No | [ ] | Yes | Static ACL configuration object | |
name | Yes | - | No | Name of the static ACL. | "group1" | ||||||
domain | No | "" | No | Domain of the static ACL. | "testDomain" | ||||||
entity | No | "user" | No | Entity (user / group) represented by the static ACL. | "user" / "group" | ||||||
access | No | "allow" | No | Access (allow / deny) granted by the ACL. | "allow" / "deny" |
Audit safeguard SELECT statement for incremental. The variable ${auditChronicleId} will be expanded for current audit chronicle ID. | SELECT r_object_id FROM dm_document WHERE i_chronicle_id = ${auditChronicleId} AND -whereFromFullCrawl- | ||||
deleteAuditItems | No | false | No | If selected, audit items used to track document changes will be deleted after incremental. | true / false |
repositoryZoneId | No | - | No | Valid repository time zone ID. Not mandatory. UTC is the default value. | Europe/Minsk, UTC+3, UTC-6 |
selectEventsSafeguardDQL | No | - | No | Event safeguard SELECT statement for incremental. Not mandatory. The variable ${eventId} will be expanded for current event itemId. | SELECT i_chronicle_id FROM dm_document WHERE r_object_id = ${eventId} AND -whereFromFullCrawl- |
deleteEvents | No | - | No | List of delete events names separated by comma (','). | "dm_destroy, dm_prune" |
maxFileSize | No | Unlimited | Yes | Specify the limit for the size of the content to be crawled. Value should be submitted as MB. Type UNLIMITED if you do not wish to set a max content size. | "10" |
Code Block | ||||
---|---|---|---|---|
| ||||
{ "id": "1a1da314-4ccb-49fa-ac0c-aa3a726e0e3a", "type": "documentum-DQL", "description": "DQL_audit_trail_connection", "credential": "8153ae2e-7260-40d4-91e6-2501ce62fc91", "properties": { "serverUrl": "dctm://10.89.26.139:1489/", "dfcPropsFilePath": "config/dfc.properties", "errorTolerant": true, "useRenditionType": true, "renditionType": "html,jpg", "useAttributes": true, "attributeList": "object_name,", "webtopUrl": "http://10.89.26.139:8080/da/component/main", "fullSelectDQL": "SELECT r_object_id, i_chronicle_id FROM dm_document", "incrementalStrategy": "auditTrail", "incrementalSelectDQL": "SELECT r_object_id, i_chronicle_id FROM dm_document WHERE r_modify_date > ${crawlTimeStamp}", "selectAuditAclChangesDQL": "SELECT r_object_id, chronicle_id FROM dm_audittrail WHERE event_name = 'dm_save' AND time_stamp_utc > ${crawlTimeStamp}", "selectAuditDeletesDQL": "SELECT r_object_id, chronicle_id FROM dm_audittrail WHERE (event_name = 'dm_destroy' OR event_name = 'dm_prune' ) AND time_stamp_utc > $>${crawlTimeStamp}", "selectAuditSafeguardDQL": "SELECT r_object_id FROM dm_document WHERE i_chronicle_id = ${auditChronicleId}", "deleteAuditItems": false, "repositoryZoneId": "", "maxFileSize": "Unlimited" } } |
Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
seed | Yes | - | No | The repository to crawl. This value will be appended to the URL of the connection. | "/repository" |
type | Yes | - | No | The value must be "documentu-DQL". | "documentu-DQL" |
description | Yes | - | No | Name of the seed object. | "documentu-DQL seed" |
connector | Yes | - | No | The ID of the connector to be used with this seed. The connector type must match the seed type. | "82f7f0a4-8d28-47ce-8c9d-e3ca414b0d31" |
connection | Yes | - | No | The ID of the connection to be used with this seed. The connection type must match the seed type. | "602d3700-28dd-4a6a-8b51-e4a663fe9ee6" |
workflows | No | [ ] | Yes | The IDs of the workflows that will be executed for the documents crawled. | ["f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"] |
throttlePolicy | No | - | No | ID of the throttle policy that applies to this connection object. | "f5587cee-9116-4011-b3a9-6b235b333a1b" |
routingPolicies | No | [ ] | Yes | The IDs of the routing policies that this seed will use. | ["313de87c-3cb9-4fe0-a2cb-17f75ce7d0c7", "b4d2579f-1a0a-4a8b-9fd4-d42780003b36"] |
tags | No | [ ] | Yes | The tags of the seed. These can be used to filter the seed. | ["tag1", "tag2"] |
Code Block | ||||
---|---|---|---|---|
| ||||
{ "type":"documentum-DQL", "description":"dql_seed", "connector":"d859a13d-db0b-457b-bc4f-e0311cf8162c", "seed":"/repository", "priority":"medium", "connection":"2a5ca234-e328-4d40-bb2a-2df3e550b065" "workflows": ["b255e950-1dac-46dc-8f86-1238b2fbdf27", "f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"], "tags": ["tag1", "tag2"], "throttlePolicy": "6b8b5f23-fc77-47a1-9b58-106577162e7b", "routingPolicies": ["313de87c-3cb9-4fe0-a2cb-17f75ce7d0c7", "b4d2579f-1a0a-4a8b-9fd4-d42780003b36"] } |
Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
id | Yes | - | No | ID of the seed to update. | "2f287669-d163-4e35-ad17-6bbfe9df3778" |
seed | No | - | No | The repository to crawl. This value will be appended to the URL of the connection. | "/repository" |
description | No | - | No | Name of the seed object. | "documentum-DQL seed" |
connector | No | - | No | The ID of the connector to be used with this seed. The connector type must match the seed type. | "82f7f0a4-8d28-47ce-8c9d-e3ca414b0d31" |
connection | No | - | No | The ID of the connection to be used with this seed. The connection type must match the seed type. | "602d3700-28dd-4a6a-8b51-e4a663fe9ee6" |
workflows | No | [ ] | Yes | The IDs of the workflows that will be executed for the documents crawled. | ["f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"] |
workflows.add | No | [ ] | Yes | The IDs of the workflows to add. | ["f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"] |
workflows.remove | No | [ ] | Yes | The IDs of the workflows to remove. | ["f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"] |
throttlePolicy | No | - | No | ID of the throttle policy that applies to this connection object. | "f5587cee-9116-4011-b3a9-6b235b333a1b" |
routingPolicies | No | [ ] | Yes | The IDs of the routing policies that this seed will use. | ["313de87c-3cb9-4fe0-a2cb-17f75ce7d0c7", "b4d2579f-1a0a-4a8b-9fd4-d42780003b36"] |
routingPolicies.add | No | [ ] | Yes | The IDs of the routingPolicies to add. | ["b4d2579f-1a0a-4a8b-9fd4-d42780003b36"] |
routingPolicies.remove | No | [ ] | Yes | The IDs of the routingPolicies to remove. | ["313de87c-3cb9-4fe0-a2cb-17f75ce7d0c7"] |
tags | No | [ ] | Yes | The tags of the seed. These can be used to filter the seed. | ["tag1", "tag3"] |
tags.add | No | [ ] | Yes | The tags to add. | ["tag4"] |
tags.remove | No | [ ] | Yes | The tags to remove. | ["tag2"] |
Code Block | ||||
---|---|---|---|---|
| ||||
{
"id":"2f287669-d163-4e35-ad17-6bbfe9df3778",
"type":"documentum-DQL",
"description":"dql_seed",
"connector":"d859a13d-db0b-457b-bc4f-e0311cf8162c",
"seed":"/repository",
"priority":"medium",
"connection":"2a5ca234-e328-4d40-bb2a-2df3e550b065"
"workflows": ["b255e950-1dac-46dc-8f86-1238b2fbdf27", "f8c414cb-1f5d-42ef-9cc9-5696c3f0bda4"],
"tags": ["tag1", "tag2"],
"throttlePolicy": "6b8b5f23-fc77-47a1-9b58-106577162e7b",
"routingPolicies": ["313de87c-3cb9-4fe0-a2cb-17f75ce7d0c7", "b4d2579f-1a0a-4a8b-9fd4-d42780003b36"]
} |
Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
type | Yes | - | No | The value must be "documentum-DQL". | "documentum-DQL" |
description | Yes | - | No | Name of the credential object. | "documentum-DQL Credential" |
authentication | Yes | - | No | It can be just "basic" for now. | "basic" |
username | Yes | - | No | Account user. | "admin" |
password | Yes | - | No | Account password. | "234dfc22re!?" |
Code Block | ||||
---|---|---|---|---|
| ||||
{ "type":"documentum-DQL", "description": "documentum DQL - description", "authentication":"basic", "username":"docuser", "password":"encrypted:A9AC6E19DF4ECFA129A3F2FA23C326E6B280D901E0E20958BD51A0B2FFE2C14D" } |
Field | Required | Default | Multiple | Notes | Example |
---|---|---|---|---|---|
type | Yes | - | No | The value must be "documentum-DQL". | "documentum-DQL" |
description | Yes | - | No | Name of the credential object. | "documentum-DQL Credential" |
authentication | Yes | - | No | It can be just "basic" for now. | "basic" |
username | Yes | - | No | Account user. | "admin" |
password | Yes | - | No | Account password. | "234dfc22re!?" |
Code Block | ||||
---|---|---|---|---|
| ||||
{ "id":"2a5ca234-e328-4d40-bb2a-2df3e550b065", "type":"documentum-DQL", "description": "documentum DQL - description", "authentication":"basic", "username":"docuser", "password":"encrypted:A9AC6E19DF4ECFA129A3F2FA23C326E6B280D901E0E20958BD51A0B2FFE2C14D" } |