Difference between DataSet and Report Definition

General
, , , , , ,
1

Can someone please help in understanding the difference between DataSet and Report definition in terms of :

a) how they query the database?

b) Which one to use in what scenario?

c) How can we trace the queries performed by Data Set?

For the same number of records, read operation works better with DataSet (with source as Database Table) than Report definition.

2

Hi @NikhilA17,

In Pega, DataSet and Report Definition are both used to retrieve and display data from a database, but they serve slightly different purposes and have different characteristics.

a) How they query the database:

  • DataSet:

    • A DataSet is used to retrieve a specific set of data from a database.
    • It can use SQL or other methods to query the database directly.
    • It’s more flexible and allows you to define custom SQL queries or use activities to fetch data.
    • DataSet is typically used for more complex and custom data retrieval scenarios.

  • Report Definition:

    • A Report Definition is for retrieving and presenting data from the PegaRULES database.
    • It is designed to generate reports based on predefined criteria and aggregates data.
    • Report Definitions use a visual designer to specify the criteria, groupings, and calculations for the report.

b) Which one to use in what scenario:

  • DataSet:

    • Use DataSet when you need to perform complex data operations, join multiple tables, or execute custom SQL queries.
    • It’s suitable for scenarios where you need fine-grained control over the data retrieval process.

  • Report Definition:

    • Use Report Definition for generating standard reports and dashboards.
    • It’s suitable for scenarios where you want to define reports using a visual interface without writing SQL queries.

c) How can we trace the queries performed by DataSet:

  • To trace queries performed by a DataSet in Pega, Follow these steps:

    1. Open the Pega Tracer tool in Pega Developer Studio.
    2. Start a new trace session.
    3. While tracing, perform the action that involves the DataSet.
    4. In the trace results, look for entries related to the DataSet and database interactions. It should show you the SQL queries executed.

d) Performance note:

  • It’s mentioned that for the same number of records, read operation works better with DataSet (with source as Database Table) than Report definition in Pega. This aligns with the fact that DataSet allows for more direct control over the database queries, potentially leading to more optimized queries.

Keep in mind that while DataSet offers more flexibility, it also requires a deeper understanding of database interactions, potentially making it more complex to set up compared to Report Definitions.

In summary, DataSet is best suited for scenarios where you need fine-grained control over data retrieval, while Report Definitions are more suitable for generating standard reports and dashboards using a visual interface.

Regards,

Mohd Qizer Uddin

3

@NikhilA17

a) Data Sets and Report Definitions both query the database but in different ways. Data Sets define collections of records and can represent data stored in different sources and formats. They can read, insert, and remove records. Report Definitions generate SQL queries to retrieve and sort information from the PegaRULES database, an external database, or an Elasticsearch index.

b) The choice between Data Sets and Report Definitions depends on the specific use case. If you need to perform operations like insert and remove records, or if you need to work with data stored in different sources and formats, Data Sets would be a better choice. If you need to retrieve and sort information from the database and display the results in a variety of formats, Report Definitions would be more suitable.

Thanks

4

@Mohd Qizer Uddin

This is so usefull.