Tableau Connector for SAP ERP

Build 25.0.9540

PaginationScheme

Determines how to handle the pagination query.

Possible Values

Default, Key, MaxRows

データ型

string

デフォルト値

"Default"

解説

Allowed values are:

  • Default: Performs LIMIT and OFFSET clauses to retrieve each page via the Remote Function Call (RFC) function.
  • Key: Paginates the query by the primary key and LIMIT (page size). If the table does not support a server-side ORDER BY clause or lacks a primary key, the driver automatically falls back to Default.
  • MaxRows: Retrieves the entire table in a single request rather than using pagination. While full ACID guarantees are not provided, this approach reduces the likelihood of inconsistent results caused by concurrent writes when querying small tables.

Note: When PaginationScheme is set to Default or Key, the driver orders results by the table's primary key(s) only when the table class supports a server-side ORDER BY clause. This behavior prevents duplicate records across paginated result sets.

If a table does not support server-side ORDER BY, the driver does not apply primary-key ordering by default. In this case, if an ORDER BY clause is explicitly specified in the query, it is not sent to SAP; instead, the driver applies the ordering client-side.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540