SSIS Components for Alfresco

Build 21.0.7930

Query Options

This section provides a complete list of the Query Options properties you can configure in the connection settings for this provider.


PropertyDescription
DataModelOptionsDetermines what metadata the driver exposes for the Alfresco table. If set to 'Curated', the driver will expose metadata for the curated set of fields returned in your Alfresco instance by a 'SELECT *' query. If set to 'Extended', the driver will expose metadata for all of the fields associated with the Alfresco table.
LocalesThe Alfresco locales for which you would like to get data. Supply as a comma-separated list. Example: en_US, en_UK.
TimezoneDetermines the timezone sent to Alfresco in API requests. Per Alfresco API documentation, the timezone identifier must follow the specification for java.time.ZoneId.
AlfrescoDatetimesAsStringsExtends support for Alfresco datetime functions by allowing datetimes to be returned as strings. For example, for Alfresco functions that extract and return the month and year for a datetime stored in Alfresco, certain platforms will automatically assign a day value to this month and year. Set this connection property to TRUE to return the exact value of the extracted month and year as a string.

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