SSIS Components for Alfresco

Build 21.0.7930

Alfresco

Alfresco Search SQL API table

Table Specific Information

Queries to the Alfresco table are sent to and executed by the Search SQL API. The Alfresco table is then populated with the results from the API's query execution.

Below is a sample schema for the Alfresco table. The exact schema available in the Alfresco table will depend on the content models and entities available in the user's Alfresco instance. What schema the driver exposes for the Alfresco table can be controlled by the DataModelOptions connection property.

Columns

Name Type Description
cm_name String
cm_created String
cm_creator String
cm_modified String
cm_modifier String
OWNER String
TYPE String
LID String
DBID Long
cm_title String
cm_description String
cm_content.size Long
cm_content.mimetype String
cm_content.encoding String
cm_content.locale String
cm_lockOwner String
SITE String
PRIMARYPARENT String
PARENT String
PATH String
ASPECT String
QNAME String

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930