Maximum connections in pool

SAP JCo parameter specifying the maximum number of simultaneous connections in an SAP connection pool.

Maximum idle connections in pool

SAP JCo parameter specifying the maximum number of simultaneous idle connections in an SAP connection pool kept open by the destination. A value of 0 has the effect that there is no connection pooling. That is, connections will be closed after each request.

Table row count

Maximum number of records to retrieve from SAP for any query against a Table resource. The default is 250,000. If queries are taking too long to run, setting this value to 1,000 can help troubleshoot the issue and prevent “runaway queries.” Setting this value to 0 means there is no restriction on the number of rows returned. TDV must be restarted for a change to table row count to take effect.

Function thread pool size

Maximum number of threads available to invoke SAP functions in parallel for a single query. Setting this property to a value greater than 0 enables TDV to make function calls in parallel to SAP. This can improve performance when many function calls are required to process a SQL query. For example, if a table containing 10 customer IDs is joined with an SAP function to retrieve customer details by ID, the function will be invoked 10 times. Setting this property to 5 would result in 5 of the function calls being executed simultaneously. The default is 0, which means this feature is disabled and function calls are processed serially.

ABAP Query DB access limit

Maximum number of database accesses SAP allows during execution of queries against ABAP Queries and InfoSets. This does not correlate to number of rows returned, because database access patterns vary significantly between ABAP Queries. In general, reducing the database access limit results in fewer rows returned and provides faster response times. Valid values range from 1 to 99,999,999. The default is 1,000.

Table read function

An SAP function to be used for accessing table resources. Default is RFC_READ_TABLE.

Table row length

Length of data field returned by table read function, in bytes. Default is 512.

Table decimal fix

If checked, SAP Note 758278 or equivalent has been applied to SAP such that the table read function encodes decimal values properly. Default is unchecked.

Table maximum options

Maximum number of filter options that can be sent to SAP when querying a table resource. Default is 500. Filter options are created from the WHERE clause for SQL queries, so this setting is important when tuning queries containing semijoins. The number of options allowed by SAP depends on its version and configuration. Too many options typically results in a core dump error from SAP.

Load-balance configuration options

Message Server

Host name of the SAP Message Server.

Message Server Port

Port of the SAP Message Server.

System ID

Logical name of the SAP system, also known as R3Name.

Logon Group

Represents a group of SAP Application Servers.