Types of Data Set rules
Learn about the types of data set rules that you can create in Pega Platform.Your data set configuration depends on the data set type that you select.
Define the keys.
- The Database Table section displays the database table name that the class is mapped to.
- In the Selectable Keys section, add as many keys as necessary, and map each key to a property.
- In the Partitioning key section, select the property used to split the data into as many equal segments as possible, across the Pega Platform nodes.
- To ensure a balanced distribution, select a property that is suitable for partitioning. For example, if the table contains customer information, country information is a suitable property for partitioning because it contains enough shared distinct values, but email address is not because it typically has as many distinct values as customer entries.
- Another consideration is the correlation between number of segments (the grouped distinct values delivered by the property) and number of Pega Platform nodes. An ideal distribution would have as many segments as Pega Platform nodes.
Decision Data Store
This data set stages data for fast decision management. You can use it to quickly access data by using a particular key.
Define the keys when you create the data set.
- The keys that you specify in a data set define the data records managed in the Cassandra internal storage. Add as many keys as necessary, and map each key to a property.
- The first property in the list of keys is the partitioning key used to distribute data across different decision nodes. To keep the decision nodes balanced, make sure that you use a partitioning key property with many distinct values.
- Changing keys in an existing data set is not supported. You have to create another instance.
To troubleshoot and optimize performance of the data set, you can trace its operations. For more information, see Tracing Decision Data Store operations.
The File data set reads data from a file in the CSV or JSON format that you upload and stores the content of the file in a compressed form in the
pyFileSourcePreview clipboard property. You can use this data set as a source in Data Flow rules instances to test data flows and strategies.
For configuration details, see Creating a File data set record for embedded files.
The HBase data set reads and saves data from an external Apache HBase storage. You can use this data set as a source and destination in Data Flow rules instances.
For configuration details, see Creating an HBase data set record.
The HDFS data set reads and saves data from an external Apache Hadoop File System (HDFS). You can use this data set as a source and destination in Data Flow rules instances. It supports partitioning so you can create distributed runs with data flows. Because this data set does not support the Browse by key option, you cannot use it as a joined data set.
For configuration details, see Creating an HDFS data set record.
The Kafka data set is a high-throughput and low-latency platform for handling real-time data feeds that you can use as input for event strategies in Pega Platform. Kafka data sets are characterized by high performance and horizontal scalability in terms of event and message queueing. Kafka data sets can be partitioned to enable load distribution across the Kafka cluster. You can use a data flow that is distributed across multiple partitions of a Kafka data set to process streaming data.
Kinesis data set connects to an instance of Amazon Kinesis Data Streams to get data records from it. Kinesis Data Streams capture, process, and store high volume of data in real time. The type of data includes IT infrastructure log data, application logs, social media, market data feeds, and web clickstream data . The data records in a stream are distributed into groups that are called shards. For more information on the Amazon Kinesis Data Streams, see the Amazon Web Services (AWS) documentation.
For configuration details, see Creating a Kinesis data set.
The Monte Carlo data set is a tool for generating any number of random data records for a variety of information types. When you create an instance of this data set, it is filled with varied and realistic-looking data. This data set can be used as a source in Data Flow rules instances. You can use it for testing purposes in the absence of real data.
For configuration details, see Creating a Monte Carlo data set record.
You can create the following data set records for analyzing text-based content that is posted on social media:
A Stream data set processes a continuous data stream of events (records).
Use a Pega REST connector rule to populate the Stream data set with external data. The Stream data set also exposes REST and WebSocket endpoint but Pega recommends that you use a Pega REST connector rule instead whenever possible.
You can use the default load balancer to test how Data Flow rules that contain Stream data sets are distributed in multinode environments by specifying partitioning keys.
For configuration details, see Creating a Stream data set.
Visual Business Director
The Visual Business Director data set stores data that you can view in the Visual Business Director planner to assess the success of your business strategy. To save data records in the Visual Business Director data set, you can, for example, set it as a destination of a Types of data flows.
One instance of the Visual Business Director data set called Actuals is always present in the Data-pxStrategyResults class. This data set contains all the Interaction History records. For more information on Interaction History, see the Pega Community article Interaction History data model.
For configuration details, see Creating a Visual Business Director data set record.
- About Data Set rules
Data sets define collections of records, allowing you to set up instances that make use of data abstraction to represent data stored in different sources and formats. Depending on the type selected when creating a new instance, data sets represent Visual Business Director (VBD) data sources, data in database tables or data in decision data stores. Through the data management operations for each data set type, you can read, insert and remove records. Data sets are used on their own through data management operations, as part of combined data
- Data Set rules - Completing the Create, Save As, or Specialization form