Illustration | Laptop

Increase efficiency in OpenText Documentum with dqMan: Six key features

By Lucian Stanus | 03 June 2024

Illustration | Clipboard

OpenText Documentum is a powerful enterprise content management system designed to manage and store vast amounts of digital content securely. In this blogpost, we’ll explore the top 6 functionalities of dqMan, our specialized administration tool, for managing your Documentum applications. From enhancing efficiency to streamlining processes, discover how our administration software dqMan can optimize your Documentum experience and drive productivity.

1. Multiple line editor with history

The dqMan OpenText Documentum Edition offers the possibility to maintain numerous DQL statements simultaneously within the editor. This enables users to easily navigate between various statements, so you can see all statements but select/execute only the one that you need for a more efficient DQL management.

Additionally, previously used commands that are no longer in the current window can be searched for and retrieved from the history.

01 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Multiple DQL statements can be selected and executed independently.
  2. History of DQL statements that were previously in the editor window.

Each connection/session has its own window, allowing each window to have its own DQL statements and history.

2. Robust session handling

dqMan supports multiple concurrent sessions to the same repository or to multiple repositories. After a while, a DFC session expires. At this point, dqMan automatically creates a new DFC session for that window, thus saving you time and avoiding repeated logins without causing performance issues.

02 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Multiple concurrent sessions to the same repository (with the same user).
  2. Multiple concurrent sessions to the same repository (with different users).
  3. Multiple concurrent sessions to different repositories.
  4. Each editor window can have its own color.

Expert tip: User and repository password combinations can be saved in dqMan (see Extras > Options > General > Login).

3. Attribute modification

Do you need to modify attribute values? Just make sure that the results contain the r_object_id attribute, navigate to the attribute to be modified, and press F2. No matter if you want to modify single value attributes or repeating attributes, dqMan helps you to simplify the modifying process, directly within the results window:

03 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Ensure the result contains the r_object_id.
  2. Go to the attribute whose value needs modification.
  3. Go to the index of the value that needs to be modified and simply update the value. Press Enter when finished.
  4. This is how repeating attributes are displayed.

Expert tip: dqMan now supports UTF-8 charset for displaying or updating values that contain special characters.

4. Export of DQLs query results

For creating reports based on query results and integrating data with other sources, export the data from dqMan in Excel or CSV format.

04 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Select the results you want to export.
  2. Right-click on the selected results and choose the Export to menu item.
  3. Select the desired format (Excel/CSV).

Expert tip: As dqMan does not use pagination in the Results window, you can select tens of thousands of results and export all of them in one go, so if you can display it in the Results windows, then you can export it.

Btw, you can find an overview of the functionalities dqMan offers for handling DQL queries and scripts on our dqMan OpenText Documentum Edition landing page.

5. Script generation from the results

Query results can be used to generate scripts for further activities. For instance, to add users from one group to another, create a query to retrieve the users from the first group, and generate the necessary DQLs to add them to the second group.

Selecting the results can be done as below:

05 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Execute the required query.
  2. Ensure the query results contain the information you need for the script creation.
  3. Click on the Generate Script menu item.

Expert tip: The Results window can also be populated with external data by using the Extras > Import From File menu (dqMan makes no distinction compared to data loaded via executing DQLs).

In order to generate the script:

06 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Set the script type (DQL Script, API Script, Other).
  2. Add the necessary queries.
  3. Use attributes from the Results window in the queries (using the {} syntax).
  4. Generate the script (execute the script in the same window or copy-paste it to another window or file).

With the generated script you can:

07 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Save it to a file.
  2. Modify the template if needed.
  3. Copy it into another session for execution.

Proactively, scripts can be generated just to revert to a specific point in time (e.g. CS upgrades usually require inactivating all the jobs so scripts can be generated to deactivate them before the upgrade and to activate them again afterwards).

6. Job execution and reporting

Monitoring job execution can easily be done via other tools, but dqMan provides functionality for executing jobs and viewing comprehensive job reports, including historical reports. It can display all old job reports, which is useful for analyzing the execution of periodic jobs.

08 | Blogpost | Streamline OpenText Documentum tasks with dqMan: Six must-have features

  1. Open the Jobs window (the usual authentication is required).
  2. Select the job or search for it using the Filter functionality.
  3. Use the Show Report menu item.
  4. Choose from older job reports or the current one.

Experience the power of dqMan yourself

Sign up for a 14-day free Trial Version and see how dqMan can revolutionize your Documentum management!
Optimize your admin workflows, enhance efficiency, and drive productivity with ease.