Alfresco Software has announced the availability of Alfresco Federation Services. This new capability that runs on the Alfresco Digital Business Platform helps organizations manage, connect, and protect their important information across multiple, disparate content applications, network file shares, and email systems. The tool enables designated employees to conduct simultaneous searches across over sixty different business […]
OpenText today launched OpenText Cloud Editions (CE) 20.2, with a strengthened information infrastructure. OpenText Cloud Editions (CE) 20.2 offers flexible cloud-deployment options with managed service expertise, new Core SaaS applications and services, developer-centric innovations, and the latest Trading Grid cloud integration platform. “We are operating in unprecedented times as we together face a global pandemic […]
Documentum Query Language is a derivative of SQL which can be used to interact with Documentum repository. These examples are meant to give you a head-start on the basic DQL syntax. For more information on DQL, please refer to latest version of Content Server DQL Reference guide Change Object type: These scripts illustrate how to modify an […]
Alfresco has just released Enterprise Edition 25.2, bringing exciting improvements for content management professionals. Whether you’re running an existing Alfresco instance or planning an upgrade, this release ensures better stability, performance, and modern deployment options.
In this post, we’ll break down the key highlights of version 25.2 and why upgrading is a smart move.
Version 25.2 includes clear guidance for both traditional and containerized deployments, including Docker Compose, Helm charts, and Ansible playbooks. The updated upgrade documentation helps organizations plan a smooth migration from older Alfresco versions while minimizing downtime.
Alfresco 25.2 continues to enhance security, performance, and standards compliance. With updates to JVM compatibility, database support, and logging frameworks (like Log4j2), your content platform becomes more reliable and easier to maintain.
While targeted at the Community Edition, 25.2 aligns closely with the enterprise release, giving users early access to key features and improvements. This ensures community users can enjoy better performance and stability without waiting for the enterprise rollout.
Upgrading to Alfresco 25.2 is not just about new features; it’s about future-proofing your ECM platform. Here’s why:
Alfresco Community Edition 25.2 is a strategic release for organizations aiming to maintain a secure, reliable, and future-ready content management platform. By upgrading now, you can reduce technical debt, improve stability, and unlock new deployment possibilities.
Stay up to date and make the most of Alfresco’s powerful ECM capabilities!
I. Introduction
II. Benefits of Using ChatGPT in ECM
III. ChatGPT Applications in ECM
IV. Implementation Considerations
V. Conclusion
Enterprise Content Management (ECM) refers to the systems, processes, and strategies that organizations use to manage their content and information assets. ECM encompasses the entire lifecycle of content, from creation and storage to dissemination and archive. The goal of ECM is to ensure that the right information is delivered to the right people at the right time, and in the right format.
ECM solutions are designed to help organizations effectively manage their digital assets, including documents, images, videos, and audio files. These systems provide a centralized repository for storing and organizing content, as well as tools for managing and delivering content to users. ECM systems also provide robust security and access controls, ensuring that only authorized users have access to sensitive information.
ECM systems are often integrated with other enterprise applications, such as Customer Relationship Management (CRM) systems and Human Resource Management Systems (HRMS), to provide a complete view of the organization’s information. This integration allows ECM systems to provide a single source of truth for the organization, improving efficiency and reducing errors.
In addition to improving the management and delivery of content, ECM systems can also help organizations meet compliance requirements, such as those related to data privacy and preservation. ECM systems can enforce retention policies and automatically archive content that is no longer needed, reducing the risk of data loss and ensuring that the organization remains compliant with relevant regulations.
ChatGPT is an advanced language model developed by OpenAI. It uses cutting-edge artificial intelligence techniques to generate human-like text based on the input it receives.
One of the key features of ChatGPT is its ability to generate text that is not just grammatically correct, but also contextually appropriate. This is achieved through its training on massive amounts of diverse text data, which allows it to understand and generate text in a wide range of styles and topics.
In addition to generating text, ChatGPT can also answer questions, summarize long text, translate between languages, and much more. Its versatility makes it a valuable tool for a variety of applications, from customer support to content creation.
Another advantage of ChatGPT is its speed and efficiency. It can generate high-quality text in real-time, making it ideal for use in conversational systems like chatbots. And because it is based on state-of-the-art AI techniques, it can continue to improve over time as it is exposed to more data and fine-tuned through training.
ChatGPT is a powerful and versatile language model that can help businesses and individuals accomplish a wide range of tasks. Its ability to understand and generate text in a human-like way makes it a valuable tool for anyone looking to automate language-related tasks or improve their communication skills.
ChatGPT, an advanced language model developed by OpenAI, has the potential to revolutionize the field of Enterprise Content Management (ECM). ECM refers to the management of an organization’s unstructured and structured data, including documents, images, videos, and more.
One of the main challenges in ECM is to effectively categorize, store, and retrieve this data. ChatGPT can help in this regard by generating high-quality metadata for these files. This metadata, which includes information such as the date created, author, and keywords, can be used to search for and organize the data in a more efficient manner.
Another potential use of ChatGPT in ECM is for text summarization. This can be useful for large reports or documents that are difficult to digest in their entirety. ChatGPT can generate a concise summary of these documents, making it easier for organizations to quickly understand the key points and make informed decisions.
In addition, ChatGPT can also be used to automate document-related tasks such as document translation, classification, and redaction. This can save organizations a significant amount of time and resources compared to manual processes.
The use of ChatGPT in ECM can help organizations to better manage their content, improve their data retrieval process, and automate tedious tasks. By leveraging the capabilities of this advanced language model, organizations can streamline their ECM processes and stay ahead in the digital age.
In today’s fast-paced business environment, content creation and retrieval play a critical role in ensuring efficiency and competitiveness. Whether it’s creating marketing materials, developing presentations, or finding relevant information, the ability to generate and access content quickly and effectively can be the difference between success and failure.
Enter ChatGPT, an advanced language model developed by OpenAI. ChatGPT can significantly improve efficiency in both content creation and retrieval by using its cutting-edge artificial intelligence techniques.
In content creation, ChatGPT can help generate high-quality text, summaries, and translations, freeing up time and resources that would otherwise be spent on manual processes. This can also improve the consistency and quality of the content, as ChatGPT can generate text that is grammatically correct and contextually appropriate.
In content retrieval, ChatGPT can assist in searching for and categorizing information more efficiently. For example, ChatGPT can generate metadata for files that includes information such as the date created, author, and keywords, making it easier for organizations to search for and retrieve the data they need.
ChatGPT has the potential to revolutionize the way organizations approach content creation and retrieval. By leveraging the advanced capabilities of this language model, organizations can improve efficiency, save time and resources, and stay ahead in the ever-evolving digital landscape.
Hyland, a leading content services provider, has signed a definitive agreement to acquire Alfresco, a content services platform and solution provider. The transaction, which is expected to close in the fourth quarter of 2020, is subject to customary closing conditions and regulatory approvals.
Boston-based Alfresco is developing a state-of-the-art, cloud-native digital business platform that provides content service solutions to connect, manage and protect the most important information of companies. Upon completion of the transaction, it is expected that all of Alfresco’s business will be managed by Hyland Software, Inc.
“We are continuing to grow our business and develop our platform organically and through acquisitions,” said Bill Priemer, President and CEO of Hyland. “This acquisition will expand our global reach and enable us to help more companies achieve their digital transformation goals and be better informed, empowered and connected.”
“For 15 years, Alfresco has had a vision of delivering the most open platform for native cloud content services,” said Jay Bhatt, President and CEO of Alfresco. “With this acquisition, Alfresco brings significant geographic and industry expertise to Hyland, as well as a community of origin as a new source of product innovation. Both companies share the same passion for customer success and innovation and together will deliver more value for customers and partners.”
About Hyland
Hyland is a leading content services provider that enables thousands of organizations to deliver better experiences to the people they serve. Find us at Hyland.com.
Hyland is a leading content services provider that enables thousands of organizations to deliver better experiences to the people they serve. Find us at Hyland.com.
Alfresco is the leading open source content services and solutions provider for information-rich enterprises with huge volumes of unstructured content.
Alfresco Software has announced the availability of Alfresco Federation Services. This new capability that runs on the Alfresco Digital Business Platform helps organizations manage, connect, and protect their important information across multiple, disparate content applications, network file shares, and email systems. The tool enables designated employees to conduct simultaneous searches across over sixty different business and content repositories from a single, controlled interface in order to deliver relevant information quickly.
Recently, the open source content management, process automation, and information governance software provider also announced significant product updates to the company’s Digital Business Platform. These updates include support for Amazon Elastic Container Service for Kubernetes (Amazon EKS) and Amazon Glacier. The company’s support for Amazon Web Services (AWS) enables solution architects to simply develop cloud-ready applications.
With Alfresco Federation Services, users can find the information they need faster and then be able to perform the tasks they need to from their desktop, regardless of where they are located. Additionally, the platform enables businesses to keep their information stored in its current repository or application, but still utilize the Alfresco Digital Business Platform by creating a connection between the content and repository to facilitate retention, holds, dispositions, and workflow.
In a press statement, Chief Product Officer at Alfresco, Tony Grout said, “In these unprecedented times, having the ability to manage information in their current locations (‘Manage in Place’) and control the content and records that are distributed across different systems is a critical capability that Alfresco Federation Services delivers. Regardless of where the content lives, employees can search and govern documents (as well as apply consistent retention policies across their content) irrespective of whether it is stored in Alfresco or non-Alfresco applications — without ever leaving their Alfresco environment — and take action upon the search results.”
About Alfresco
Alfresco Software, Inc. (“Alfresco”) is a commercial, open source software company that builds and markets a cloud-native, process, content and governance intensive Digital Business Platform. It is a single, integrated platform built from the ground up by Alfresco and is used to digitize processes, manage content and securely govern information. Alfresco is used by more than 1,300 industry-leading organizations, including Cisco, Canadian Museum for Human Rights, Delta Dental, Liberty Mutual, LexisNexis, Pitney Bowes, the Joint Chiefs of Staff, NASA, RBC Capital Markets and the US Navy Department. Founded in 2005, Alfresco has its headquarters in Boston, Massachusetts, USA and operations in Atlanta, GA., Maidenhead and London, UK, and Sydney, Australia. For more information about Alfresco, please visit http://www.alfresco.com.
OpenText Cloud Editions (CE) 20.2 offers flexible cloud-deployment options with managed service expertise, new Core SaaS applications and services, developer-centric innovations, and the latest Trading Grid cloud integration platform.
“We are operating in unprecedented times as we together face a global pandemic that is changing the very nature of work, life, and supply chains,” said Mark Barrenechea, OpenText’s CEO and chief technology officer, in a statement. “OpenText Cloud Editions (CE), OpenText OT2 Applications, and our new Business Network are designed to help customers manage and transition to new priorities. Our latest software and services provide cyber resilience, secure information platforms, and allow customers to digitize business processes and work from anywhere. We proudly stand with our customers and partners who are on the front line of this global pandemic.”
OpenText Cloud Editions (CE) introduces new cloud-native software from OpenText. Designed with a containerized architecture, OpenText Cloud Editions (CE) lets users run software in their data centers, through hybrid deployments, or within their cloud platforms.
Along with OpenText Cloud Editions, this release includes the following features and capabilities:
OpenText OT2 20.2 features new purpose-built Core SaaS applications that extend the value of existing OpenText on or off cloud deployments.
OpenText Core for Building Information Modeling is the latest addition to OpenText’s growing roster of next-generation purpose-built SaaS applications. Core for Building Information Modeling reduces operational costs and complexity, while increasing efficiency in building operations by facilitating the efficient capture and verification of incoming data.
Core SaaS applications include Share, Capture, Signature, Experience, Insights, Federated Compliance,, SAP Solutions, and Capital Projects, designed to help business leaders manage processes and improve productivity.
OT2 20.2 delivers new Core services to help developers build customized applications to solve specific information management challenges. This includes an intelligent capture service for automating data extraction and an eSignature service for document preparation, and rapid, secure electronic signing.
OpenText also announced the OpenText Trading Grid, a unified B2B and A2A integration platform delivered as a managed service. This release combines multi-enterprise integration capabilities with a microservices architecture and data visualization from OpenText Alloy. Data visualization provides real-time insight into supply and demand fluctuations. Self-service innovations in Trading Grid, including self-service connectivity in Global Partner Directory, enable customers to move disrupted supplier orders to available suppliers already connected to Trading Grid.
Documentum Query Language(DQL) is a derivative of SQL which can be used to interact with Documentum repository. DQL is used to query Documentum which is a content management system used to create, manage, deliver, and archive all types of content.
DQL uses syntax that is a super set of ANSI-standard SQL (Structured Query Language) DQL statements operate on objects and sometimes on tables/rows but SQL statements operate only on tables/rows. In fact, part of your DQL statements are translated automatically into SQL before being executed by the eContent Server
For more information on DQL, please refer to latest version of Content Server DQL Reference guide
A DQL query is sent to the eContent Server using one of four API methods (readquery, execquery, query, or cachequery)
A DQL engine on eContent Server generates
– SQL queries for the RDBMS
– Verity queries for the full-text search engine
The results of the query are stored on the server in a non-persistent collection object. Typically, a Documentum client will automatically present the results of the query to the user in some useful way. Alternatively, a Developer may want to use the resulting collection object or manipulate the results programming languages like Java.
These examples are meant to give you a head-start on the basic DQL syntax.
This script creates an object type edoccustomtype with supertype as dm_document
CREATE TYPE "edoccustomtype" (firstname string(64), country string(64) , age int, height double, phone string(10) REPEATING) WITH SUPERTYPE "dm_document" PUBLISH
ALTER TYPE "edoccustomtype" Add lastname string (60), height double, weight double PUBLISH
There are many constraints on modifying an existing attribute Refer to DQL Manual for more information
ALTER TYPE edoccustomtype MODIFY firstname String (200)
ALTER TYPE edoccustomtype drop weight
DROP Type "edoc_custom_object"
Delete all objects
DELETE edoc_custom_object objects
Delete all versions of of all objects
DELETE edoc_custom_object (all) objects
DESCRIBE edoccustomtype
CREATE edoccustomtype OBJECT SET firstname = 'First Name', SET country= 'US', SET age=30 SET phone [0]= '12345678'
phone is a repeated attribute, age is a integer and firstname and country are strings
UPDATE dm_document object SET object_name = 'new_name' WHERE object_name = 'old_name'
UPDATE dm_document objects SET keywords[0]='value' WHERE r_object_id='09xxxxxx'
DELETE dm_document object WHERE object_name='object_name'
SELECT r_object_id, object_name FROM dm_document WHERE object_name='test'
SELECT r_version_label FROM dm_document WHERE any r_version_label in ('CURRENT')
SELECT r_object_id, r_version_label FROM dm_document (ALL) WHERE object_name='MyDocument'
SELECT r_object_id, object_name FROM dm_document WHERE r_modify_date > DATE('01/01/2008 00:00:00','MM/DD/YYYY hh:mm:ss') AND r_modify_date < DATE('TODAY')<br>(This will return object id and name of all the objects that was created between today and 01-01-2008)
DATEDIFF(date_part, date1, date2) – DATEDIFF function returns the number that represents the difference between given two dates. Valid values for date_part are a year, month, week, and day and date1 is subtracted from date2.
SELECT * FROM dm_document WHERE DATEDIFF(week, "r_creation_date" , DATE(TODAY))<=2<br>(This query will return all dm_documents that are created between today and the last 2 weeks)
SELECT object_name as name FROM dm_document WHERE r_object_id='09xxxxxx'
This returns all the unique object names of type dm_document.
SELECT DISTINCT object_name FROM dm_document
This Query will return Object name of all the objects that have my_attributes as blank
SELECT object_name FROM my_object_type WHERE my_attribute is NULLSTRING
This Query will return Object name of all the objects that have some values in my_attributes (non-blanks)
SELECT object_name FROM my_object_type WHERE my_attribute is not NULLSTRING
SELECT * FROM dm_document SEARCH document contains 'test'
SELECT group_name FROM dm_group WHERE any users_names in ('user_name')
SELECT r_folder_path FROM dm_folder WHERE r_object_id in (SELECT i_folder_id FROM dm_document WHERE object_name='object_name')Find Objects those have Same (Duplicate) Name
SELECT object_name, count(*) FROM dm_document GROUP BY object_name HAVING count (*) > 1 ORDER BY object_name
SELECT r_object_id, r_lock_date FROM dm_document WHERE r_lock_owner is not NULLSTRING and r_lock_date is NOT NULLDATE and r_lock_machine is not NULLSTRING and DATEDIFF(day, r_lock_date, DATE(TODAY))<=1 ORDER BY r_lock_date
SELECT * FROM dm_sysobject ENABLE (RETURN_TOP 10)<br>This RETURN_TOP hint returns the number of records specified.
This query will return only 10 records.
SELECT user_name, user_os_name, user_address, user_group_name, r_modify_date FROM dm_user WHERE r_modify_date > date('12/16/2008 00:00:00')
SELECT file_system_path FROM dm_location WHERE object_name='log'
Question and Answers Session
Q: Does Adlib support e-signing of documents via digital signatures?
A: tbd
Q: Is webdav supported with D2? Also, is there is plans to remove dependecy on Java on the client?
A: D2 does not offer a webdav function. Regarding java, there are currently no specific plans to remove the java dependency. EMC agrees that the java dependency has difficulties but there is no good replacement in sight for the moment.
Q: Can I assume that TBOs are still used by D2? Things such as auto-linking and auto-population of attributes have been implemented in TBOs so that any Documentum client can take advantage of such customizations.
A: Yes, TBOs are used by D2. But you have to be careful that the TBOs do not conflict with the D2 configurations that are in place.
Q: D2- bocs , webtop-bocs-Ucf what could be the difference?
A: We are not aware of any big difference here. The same backend functionalities with ACS will be used.
Q: Does D2 provide any enhanced reporting on content/attributes and workflows?
A: Out of the box you can build complex query forms for reporting purposes. Additionally there is a reporting plugin available from an external vendor.
Q: For D2 What is min requirements Content Server?
A: D2 4.2 requires at least Content Server version 6.6
Q: Are there any limitations using workflows designed in Process Builder with D2?
A: D2 workflows support all functionalities of Process Builder that are also available in Workflow Manager. Everything that goes beyond Workflow Manager capabilities is currently not supported by D2.
Q: Is there a best practice/standard methodology to migrate wdk customizations to D2 client?
A: Please review our sample project approach as shown in the webinar. There has to be an analysis and evaluation phase in the beginning to look into the current Webtop customizations and to decide what it could look like in D2 – whether it is simple configuration, complex configuration, customization or maybe not possible at all. Please note that it might also make sense to go back to the original requirements to look for alternative approaches on how to implement it.
Q: Does D2 still use Java for any purpose?
A: Yes, java is still being used for the content transfer.
Q: Equivalent of Quickflow in D2?
A: D2 offers different configuration possibilities for similar functionalities, for example distribution lists.
Q: Can I do federated search in D2? (across docbases or different ECM systems)
A: There is no federated search mechanism included in D2.
Q: Does D2 support Centera storage?
A: The Centera connection happens in the backend, on server side, and is therefore independent from the client such as D2.
Q: How is the performance compared to webtop?
A: From our experience the performance is better, the underlying technology is executing more functionality directly on client side avoiding long refresh times.
Q: What about the consistency issues with different browsers for D2?
A: We are not aware of consistency issues between different browsers.
Q: What is the maximum size D2 supports for drag and drop functionalities?
A: We are not aware of any drag&drop size limitations provided by EMC.
Q: Does D2 work with xCP 2.x?
A: D2 and xCP are two different client technologies. It has to be looked at the specific integration requirements to see what options could be used. Via external widgets D2 allows for example to integrate any web pages / web components to add additional functionality to the client – those could be using xCP as an example.
Q: Is there a CMIS adapter in D2?
A. Documentum provides a CMIS 1.0 API but there is no specific D2 CMIS API available.
Q: If D2 is not using UCF, what has replaced UCF?
A: D2 does either use an applet or HTTP for content transfer.
Q: Could you explain little bit more on shared service in adlib?
A: tbd
Q: Does D2 do any Publishing such as virtual documents into a single PDf with Cover sheet, Table of Contents, etc that is compliant with the FDA and EMA regulations?
A: tbd
Q: Do I have to create ACLs in D2 or it support existing ACLs created in DA?
A: If you want to dynamically set ACLs based on the D2 configuration matrix, then the ACLs needs to be defined in D2. D2 auto generates the ACL the first time it is used. If an ACL with the same name already exists it will be overwritten.
Q: What is the difference between ADTS & ADLIB?
A: tbd
Q: How about Rention Policy Services support in D2?
A: A plugin for Retention Policies was provided with the last D2 version.
Q: Do you see any drawbacks of D2 over Webtop?
A: No, we haven’t come across any major drawbacks.
As expected, EMC has released Documentum Content Server v7.2 (along with all of the other core stack components that accompany the Content Server). Here is the official announcement from EMC.
Here are a few highlights I have gleaned from the release notes so far:
EMC says they have added over 30 new features and also fixed 2,700 bugs which is great news. See the Release Notes for complete list of features.
Support: Please note – The Primary Support window for Documentum 7.2 is through 20 February 2019, after which Extended Support is available through 28 February 2022.
Existing customers current on maintenance can access the latest release of EMC Documentum by visiting our EMC Support Site at support.emc.com. New customers should approach their account managers to generate a sales order to obtain the software.
The locations for some of these downloads is not always obvious. It looks like most of the v7.2 updates are listed as “DCTM”. You can find most of what you need under the DCTM Platform heading; others you will have to search for
The long-awaited D7.1 Developer’s Edition is finally available.
The Developer Edition provides an easily deployed infrastructure for developing applications that incorporate content management functionality. It combines Documentum Content Server, Documentum REST services, and Documentum Administrator within a single virtual image package. The image leverages Open Source components including a relational database (PostgreSQL), application server (Apache Tomcat) and operating system (CentOS). Installation of the Developer Edition is a simple matter of opening up the vmdk file using either VMWare workstation or VMware player. No additional licensing is required.
With this release of the Developer Edition, the focus is on learning and applying the new Documentum REST Services. Additionally one can always utilize the setup to build traditional Documentum Foundation Classes (DFC) based application integration. In general, we’re following a perpetual beta model with the Developer Edition to get feedback from the developer community on our products and on the use of the Open Source components. In future releases we hope to add additional components and functionality from the Documentum stack.
This new incarnation of the Dev Edition is built upon a completely open source stack and is freely available for non-production use. This release of the Dev Edition focuses on the new Documentum REST web services, and includes the following Documentum components:
The open source infrastructure consists of the following: