Try DataDirect Cloud Now
skip to main content
Mapping tab options : Map System Column Names
 

Map System Column Names

The mapSystemColumnNames parameter defines whether DataDirect Cloud maps the integration name of standard columns that appear in each object to a new name. By default, DataDirect Cloud maps the id column to ROWID, and maps the remaining standard columns to a new name prefixed with SYS_ .
Note: The mapSystemColumnNames map option is applicable only to the Rollbase and Oracle Service Cloud data stores.
Table 176. Mapped Integration column names
Integration Name
Mapped Name
id
ROWID
name
SYS_NAME
updatedBy
SYS_UPDATED_BY
updatedAt
SYS_UPDATED_AT
createdBy
SYS_CREATED_BY
createdAt
SYS_CREATED_AT
comment
SYS_COMMENT
To control whether DataDirect Cloud remaps the column names of the objects, add a mapSystemColumnNames parameter in the Map Options parameter, or specify a value in the Map System Column Names field on the Mapping tab of your data source definition. Valid values for mapSystemColumnNames are:
Table 177. Valid values for mapSystemColumnNames
Value
Description
0
DataDirect Cloud does not map the names of standard columns of database objects to new names.
1
DataDirect Cloud prefixes the names of standard columns of database objects with SYS_ or ROWID.
The default value for mapSystemColumnNames is 1.