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 item's metadata in case there is not document content available. If not select, an error will be reported when there is no content (the item won't be index). | 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 to index separated by 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 | Yes | - | 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 | Yes | - | 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 | Yes | - | 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 being 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" |
{ "type": "documentum-DQL", "description": "DQL_event_queue_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": "eventQueue", "selectEventsSafeguardDQL": "SELECT i_chronicle_id FROM dm_document WHERE r_object_id = ${eventId} AND -whereFromFullCrawl-", "deleteEvents": "dm_destroy, dm_prune", "maxFileSize": "Unlimited" }
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 item's metadata in case there is not document content available. If not select, an error will be reported when there is no content (the item won't be index). | 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 to index separated by 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 | Yes | - | 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 | Yes | - | 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 | Yes | - | 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 being 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" |
{ "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"] |
{ "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"] |
{ "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!?" |
{ "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!?" |
{ "id":"2a5ca234-e328-4d40-bb2a-2df3e550b065", "type":"documentum-DQL", "description": "documentum DQL - description", "authentication":"basic", "username":"docuser", "password":"encrypted:A9AC6E19DF4ECFA129A3F2FA23C326E6B280D901E0E20958BD51A0B2FFE2C14D" }