Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AllOrNone | Specifies whether all insert, update, or delete operations in a request should fail if any individual record fails. |
| ArchiveMode | Specifies whether to include deleted and archived records in standard SELECT queries. |
| ContinueOnAlterException | Specifies whether the provider should continue executing subsequent ALTER statements after one fails. |
| ExposeConceptualEntities | Specifies whether Certinia Record Types should be exposed as separate tables. |
| FilterScope | Specifies an optional scope to limit the records returned in queries using Salesforce's USING SCOPE keyword. |
| IncludeItemURL | Boolean determining if the ItemURL column should be exposed for every table. |
| IncludeMetadataDescription | Specifies whether to retrieve descriptions for columns, tables, or both from the Salesforce Metadata API. |
| IncludeReports | Specifies whether Certinia Reports should be exposed as views in the schema. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| NullBooleanBehavior | This property determines how the NULL values should be treated for the Boolean columns. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| QueryPassthrough | Specifies whether to allow SOQL queries to be passed directly to Salesforce instead of translating SQL queries into SOQL. |
| Readonly | Toggles read-only access to Certinia from the provider. |
| RemoveBOMCharacter | Specifies whether the provider should remove the Byte Order Mark (BOM) character (0xFEFF) from content. |
| RemovePrivateChar | Specifies whether to replace private use characters with a '?' character in the retrieved content. |
| ReplaceInvalidUTF8Chars | Specifies whether to replace invalid UTF-8 characters in the content with a '?' character. |
| ReportExactPicklistLength | Specifies whether to report the exact length of picklist fields as defined in Certinia, or to report them with a default length of 255. |
| ServerSideAggregation | Specifies whether aggregation operations such as SUM, COUNT, and GROUP BY should be performed on the Certinia server or handled by the client. |
| SessionTimeout | Specifies the duration, in minutes, for which a Certinia login session is reused before expiring. |
| SkipFormulaFields | Specifies whether formula fields should be excluded when listing columns for Certinia objects. |
| SkipPickListTranslation | Specifies a comma-separated list of columns for which picklist translation should be skipped when retrieving data. |
| SortColumns | Specifies whether table columns should be sorted alphabetically by name or reported in the order provided by Certinia. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| TranslatePickListFields | Specifies whether picklist field values should be translated into the language of the currently authenticated Certinia user. |
| UseDisplayNames | Specifies whether to use display names for columns instead of their API names when listing metadata and querying data. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UseToolingAPI | Specifies whether to use the Certinia Tooling API for retrieving and modifying metadata and development-related objects. |