Try DataDirect Cloud Now
skip to main content
Mapping tab options : Uppercase Identifiers
 

Uppercase Identifiers

The Uppercase Identifiers mapping option is applicable to the following data stores:
*Salesforce
*ServiceMax
*Veeva CRM
*FinancialForce
*Microsoft Dynamics CRM
*Rollbase
The Uppercase Identifiers parameter defines how DataDirect Cloud maps identifiers. By default, the connectivity service maps all unquoted identifier names to uppercase.
Identifiers are object names. Classes, methods, variables, interfaces, and database objects, such as tables, views, columns, indexes, triggers, procedures, constraints, and rules, can have identifiers.
Valid values for Uppercase Identifiers are:
Table 183. Valid values for Uppercase Identifiers
Value
Description
true
DataDirect Cloud maps identifiers to uppercase.
false
DataDirect Cloud maps identifiers to the mixed case name of the object being mapped. If mixed case identifiers are used, those identifiers must be quoted in SQL statements, and the case of the identifier, must exactly match the case of the identifier name.
If an unquoted identifier name was used when the object was created, the value passed to the catalog function must be uppercase because unquoted identifiers are converted to uppercase before being used. If a quoted identifier name was used when the object was created, the value passed to the catalog function must match the case of the name as it was defined. Object names in results returned from catalog functions are returned in the case that they are stored in the database.
For example, if the Uppercase Identifiers check box is selected, to query the Account table you would need to specify:
SELECT "id", "name" from "Account"