If advanced SQL is required to access an external database, which option should be used?

When advanced SQL is necessary to access an external database, utilizing a SQL connector is the most appropriate choice. SQL connectors facilitate direct interaction with external databases, allowing for complex queries and manipulation of data beyond standard operations.

These connectors are specifically designed to support advanced SQL features, enabling developers to write custom SQL queries that can include joins, subqueries, and other sophisticated SQL techniques. This capability is vital when working with complex data structures or when needing to leverage specific database functionalities that are not achievable through higher-level abstractions like data pages or report definitions.

In contrast, data pages are primarily meant for retrieving and storing data in a more simplified manner, focusing on Pega’s internal structures and operational needs rather than executing complex SQL statements. The Database Table Class Mapping tool is used for configuring the mapping of Pega classes to database tables but does not execute queries itself. Report definitions are useful for generating data reports and analytics but are limited in their capability to handle intricate SQL queries.

Thus, a SQL connector stands out as the optimal tool for executing advanced SQL against an external database, ensuring robust and versatile data manipulation capabilities.