Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AllowNavigationDisassociation | Specifies whether the provider binds navigation properties to null values. |
| BatchSize | Specifies the maximum number of rows included in each batch submitted during batch operations. To submit the entire batch as a single request, set BatchSize to 0 . |
| ConnectOnOpen | Specifies whether the provider establishes a connection to OData immediately upon opening the connection. Set ConnectOnOpen to True if immediate connectivity verification is necessary. |
| ContinueOnError | Specifies whether batch requests should continue after encountering an error. (OData 4.0 and higher only.). |
| Cookies | This property can be manually specified in the format of name=value pairs, which are separated by semicolons. |
| CustomHeaders | Specifies additional HTTP headers to append to the request headers created from other properties, such as ContentType and From. Use this property to customize requests for specialized or nonstandard APIs. |
| CustomURLParams | A string of custom URL parameters to be included with the HTTP request, in the form field1=value1&field2=value2&field3=value3. |
| DataFormat | Specifies the formatting of data when interacting with an OData service. The two formats supported are ATOM and JSON. |
| DecodeXMLNames | Specifies whether to decode column names containing Unicode characters. |
| DefaultDomain | This property is used for the Oracle Database Gateway for ODBC. |
| EnableAtomicBatchOperations | This property indicates that all Create, Update, and Delete (CUD) requests in a batch are handled as a single action. The success of the entire batch depends on the outcome of all requests. If any single request fails, the whole batch fails and no changes are applied. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| ExcludeControlInformationRootType | Indicates whether OData should use the odata.type control information for the root element. |
| ExpandAsterisk | The OData service should return everything if the $select query parameter is not specified by default. In certain cases, this functionality can be set to true, allowing retrieval of every column from the specified dataset. This applies specifically to SQL queries. |
| IncludeDualTable | Set this property to mock the Oracle DUAL table for better compatibility with Oracle database. |
| IncludeNavigationParentColumns | Specifies whether the columns that serve as parent navigational elements should be incorporated within the navigation views. |
| IncludeReferenceColumn | Adds an input-only ParentReference column designed for bulk INSERT operations, ensuring that child records are correctly linked to their respective parents during a deep INSERT process. |
| LimitKeySize | The maximum length of a primary key column. |
| MapBigintToVarchar | This property controls whether or not the bigint type maps to SQL_VARCHAR instead of SQL_BIGINT. This property is false by default. |
| MapToInt | This property controls whether or not the long type maps to SQL_INTEGER instead of SQL_BIGINT. This property is false by default. |
| MapToLongVarchar | This property controls whether or not a column is returned as SQL_LONGVARCHAR. |
| MapToWVarchar | This property controls whether or not string types map to SQL_WVARCHAR instead of SQL_VARCHAR. This property is set by default. |
| MaxFilterLength | Specifies the maximum number of characters permitted in the $filter query parameter of a OData request. |
| MaximumColumnSize | The maximum column size. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| MaxSelectLength | This property limits the number of characters allowed in the $select query option. If the length of the generated $select parameter exceeds the values specified, the column selection is instead processed client-side. Setting this property to 0 prevents the provider from submitting the $select parameter to the service, which is useful for services that do not support it. |
| NavigationPropertiesAsViews | A boolean indicating navigation properties should be promoted to full views. |
| ODataVersion | The version of OData that should be utilized. By default, the provider is designed to automatically detect and adapt to the appropriate version, ensuring seamless integration and functionality. |
| 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. |
| Pagesize | Specifies the maximum number of records per page the provider returns when requesting data from OData. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'. |
| Readonly | Toggles read-only access to OData from the provider. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key. |
| ServerTimeZone | The timezone for representing or interpreting the server's Edm.DateTime values. The value of this property affects how Edm.DateTime filters and results are converted between the server and the client. |
| StoredProceduresAsViews | A boolean value indicating whether stored procedures returning collections of entities should be treated as views. |
| SupportsExpand | Determines whether navigation properties can be retrieved from the base entity set, which is more accurate. If this property is false, it prevents the provider from retrieving navigation properties. |
| SupportsFilter | Specifies whether the OData service supports the $filter query parameter. |
| SupportsFormulas | A boolean indicating if the odata service supports server side formulas. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UpperCaseIdentifiers | This property reports all identifiers in uppercase. This is the default for Oracle databases and thus allows better integration with Oracle tools such as the Oracle Database Gateway. |
| UseClientSidePaging | Specifies whether or not OData should return data using client-side paging, if your source supports it. To use client-side paging, set this to True. To use server-side paging, set this to False. |
| UseEtags | The purpose of this property is to optionally hide the Etag column if the service does not return a value for it. Otherwise, it will be included but remain empty. |
| 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. |
| UseSimpleNames | Specifies whether or not simple names should be used for tables and columns. |