Documentum 6.5 New Features

I attended some of the Interactive Content Management webinar today. D6.5 is still scheduled for July 31st.

CTS

• Real-time (synchronous) invocation
• New transformations included
• DOES NOT include any new Adobe capabilities yet (Version 7 will include updates)
• In the future, EMC intends to supply a transform that will convert many vector formats into a Flash-based lightweight vector format so the typical web user can view vector graphics without a special plug-in.

XTS

• Bundles new DITA targets out-of-the-box using DITA OT 1.4.1 (1.4.2 coming with D6.5SP1)
• DITA bookmap, etc.

Site Caching / Delivery Services

• SDS is end-of-life due to Marimba licensing issues
• In D6.5 major change is that SCS can publish to a standalone XHive store (no plugin for MarkLogic)
• Web Service enhancement allows two-way interaction, i.e., user-supplied content can be sucked into the repository. Optionally a workflow may be launched based on this "repatriated" content to control ingestion.
• EMC will rewrite the SDS functionality for D7

Digital Asset Management

• DAM client has bugfixes, not much new functionality, still based on WDK
  
• Storyboard enhancements / video sub-clips can be manually extracted
• Loupe tool can run through firewall
• Launch MediaSpace directly from DAM targeting a specific folder

MediaSpace (Media Workspace)

• Moving towards a DAM Replacement
• Not all functionality will be available in D6.5 vs. DAM (new product)
• No additional license required beyond DAM 6.5
• Adobe Flex rich interface
• Target the Everyday consumer / contributor
• Visually Appealing and low learning curve
• Componentized "Flex Miniapp" is the architectural model
• Interacts with repository via DFS (Unclear if DFC is still in the mix from the client-side)
• Built in Digital Asset approval process (workflow), not sure if this is fully configurable/customizable yet.
• Launch DAM directly from MediaSpace targeting a specific folder
• Launch OS Explorer / Finder into a File-Share-Services exposed repository folder

Media WorkSpace Pro

• Additional Cost, advanced tool for viewing, annotating and modifying content
• Integrated with WCM so can target Wiki and Blogs

Media WorkSpace Marketing Edition

• Built on top of Media WorkSpace Pro
• Solution to provide a leg-up for building a Marketing campaign
• Quick publish to various channels
• Analytics
• Offer composer
• Dashboard (maybe based on workflow?)

AIS: Authoring Integration Services

• FSS: File Share Services
• FTP: FTP Services
• WebDAV services
• Feature set of FTP and WebDAV are similar to prior releases
• Focus on FSS
• OS Level Access to Explorer / Finder as a network file share
• Plugins for InDesign and Quark to support compound documents
• Scalability, WAN and Firewall enhancements
• Better integration and user-adoption by being more hidden
• Can prompt the user for synchronous / asynchronous interaction
• D7 intends to support triggers so the files can be immediately committed back ALA eRoom plugin.
• AutoUpdate can upgrade FSS clients on login to simplify deployment
• Certified to work with RPS / Records Manager
• Macintosh OSX 10.5

FSS 6.5 SDK

• Expose Repository services such as version history and renditions
• Custom context menus in Explorer/Finder
• Replace dialogs to customize Import / Checkin / Properties dialogs
• System Tray menu customizations
• Scheduled Commit
• Leverage the client-side cache

FSS Roadmap (D7)

• 6.5sp1: My Documentum (FSS+offline+appConnectors)
• Center Stage Integration (triggers, etc.)
• Silent Login / SSO
• Clustering / HA
• Tighter Windows Integration, .net client, etc. (no Java runtime needed)

In the future other clients such as Knowledge Worker and Center Stage will be able to embed the various WorkSpace clients.

For D7, the Task/Media/Work/Space products will interoperate and transparently hand-off to each other. E.g., you won't have to logon to TaskSpace to perform workflows and then go back to MediaSpace to view Videos. Sounds like in D6.5 the products are not all that integrated.

DQL and Folder Paths

I came across this blog entry on dm_notes. While what Rajendra posts will work, it is not the best choice for production use.

The problem with his query is that the _r tables are not automatically accessible to non-superuser accounts unless they are explicitly registered. And the problem with registering the repeating tables is that then users can see things that the Documentum ACL security would not normally allow them to see. This is a Bad Thing in production.

In Documentum 5, EMC introduced a DQL hint called ROW_BASED that allows us to circumvent the DM_QUERY2_E_REPEAT_TYPE_JOIN error. Essentially the ROW_BASED hint disables Documentum's normal repeating property validation and post-processing and allows all the query results to be returned by the RDBMS through the Documentum server. The following DQL does the same thing as Rajendra's query, but is subject to normal Docbase security and doesn't require any special setup:

SELECT doc.r_object_id, doc.object_name, fld.r_folder_path
FROM dm_document doc, dm_folder fld
WHERE
doc.i_folder_id = fld.r_object_id AND
fld.r_folder_path like '/System/%'
ENABLE(ROW_BASED, RETURN_TOP 10)

The RETURN_TOP hint is only there so the example query completes quickly. Note that both queries will return all locations where each document is linked. If you only want to know the first folder into which each document is linked, then add the following to the WHERE clause:

AND doc.i_position=-1 AND fld.i_position=-1

The i_position column can be used for other interesting queries, but that is a subject for a different post.

UPDATE: As long as I'm talking about "production ready" queries, I should point out that using r_folder_path LIKE '/System/%' is very slow since it forces a full-table-scan by the underlying database of the dm_folder_r table. It is better to use FOLDER('/System', descend) instead.