Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| BatchSize | The maximum size of each batch operation to submit. |
| ConnectionLifeTime | The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. |
| ConnectOnOpen | This property specifies whether to connect to the SAP ByDesign when the connection is opened. |
| ExpandAsterisk | Indicates whether the asterisk should be expanded in the $select query parameter. |
| MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
| MaxSelectLength | To avoid the query risks failing with [414] URI Too Long error, we apply a length limit of the columns in projection($select) which defaults to 1000. This property is useful to increase the limit in case there are circumstances where the service does not restrict the URI length or the user wants the limit to be higher for $select. To disable length limitation set this property to -1. This property can not be used when the ServiceType connection property is set to AnalyticsService. |
| NavigationPropertiesAsViews | A boolean indicating navigation properties should be promoted to full views. |
| Other | These hidden properties are used only in specific use cases. |
| PoolIdleTimeout | The allowed idle time for a connection before it is closed. |
| PoolMaxSize | The maximum connections in the pool. |
| PoolMinSize | The minimum number of connections in the pool. |
| PoolWaitTime | The max seconds to wait for an available connection. |
| Readonly | You can use this property to enforce read-only access to SAP ByDesign from the provider. |
| RTK | The runtime key used for licensing. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UseConnectionPooling | This property enables connection pooling. |
| UseDisplayNames | Boolean determining whether or not to use SAP labels. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |