Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| SAPEdition | The edition of SAP being used. Set either SAP cloud or SAP OnPremise. |
| BAPINameSeparator | A separator for concatenating table and column names when the output of the stored procedure contains a table type parameter. |
| BatchSize | The maximum size of each batch operation to submit. |
| Charset | The system code page used for Unicode to multibyte translations. |
| CheckDecimalNotation | A boolean indicating if you need to use the Decimal Notation of the SAP user profile to format the decimal data. |
| DefaultDomain | This property is used for the Oracle Database Gateway for ODBC. |
| Destination | Reference to an existing destination that is specified in a local saprfc.ini or sapnwrfc.ini file. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| EndianType | The endian type for the SAP server. Enter either Big or Little. |
| GatewayHost | The gateway host you wish to connect to. |
| GatewayService | The gateway service you wish to connect to. |
| GenerateSchemaFiles | Determines how schema files should be generated. |
| IncludeDualTable | Set this property to mock the Oracle DUAL table for better compatibility with Oracle database. |
| InitialValueMode | How to treat initial values in SAP. |
| Language | The language value to be used when connecting to the SAP system. |
| LimitKeySize | The maximum length of a primary key column. |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures to work with your chosen data source. This must be set in order to add new tables to provider. |
| 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. |
| MaximumColumnSize | The maximum column size. |
| MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
| Other | These hidden properties are used only in specific use cases. |
| Pagesize | The number of results to return per page from SAP. Only used for SAP tables. |
| PseudoColumns | Specify a set of pseudocolumns to expose as columns. |
| QueryMode | Determines which SAP queries will be displayed as views, if any. |
| ReadTableDelimiter | The delimiter is submitted to the ReadTableFunction . |
| ReadTableFunction | The function to use for reading table data. |
| RTK | The runtime key used for licensing. |
| StoredProcedureFilter | A filter indicating which function modules to report as stored procedures. |
| SupportServerSideCount | Determines if the count function of the simple query is executed in the SAP server. For example, select count(*) from ADRC. |
| TableMode | Determines which SAP tables will be displayed as views if any. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| TrimStrings | A boolean indicating if varchar columns should be trimmed or not. |
| 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. |
| UseInternalNames | Specifies the whether to use the internalName of columns. |
| UseLabels | Set this property to determine if labels should be used for table and column names. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |
| UseUnicodeRFC | A boolean indicating if you want to use RFC_GET_UNICODE_STRUCTURE to get structure information. |
| WhitespaceToNull | Indicates whether to read the empty value as original value or as null. |