Question

2
Replies
274
Views
 Pawel Nowak (nowap)
PEGA
Principal System Architect - Pega Consulting
Pegasystems Inc.
US
nowap Member since 2016 13 posts
PEGA
Posted: October 28, 2019
Last activity: October 29, 2019
Posted: 28 Oct 2019 11:39 EDT
Last activity: 29 Oct 2019 13:08 EDT
Closed

Using CQL (the Cassandra Query Language) from Pega to query Cassandra

Hi Team,

Does anyone have an experience using CQL (the Cassandra Query Language) queries directly from Pega? I am not interested in using DDS Data Set, or Connect-Cassandra rules, as I am looking more for execution of the CQL query, which allows to write a light and flexible statements for data aggregation. Will that be possible from an activity?

I really appreciate replies in that topic.

Pawel

Pega Platform Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 1 year ago
Posted: 29 Oct 2019 13:08 EDT
Pawel Nowak (nowap)
PEGA
Principal System Architect - Pega Consulting
Pegasystems Inc.
US

Thanks Kevin. I also configured the Pega Database rule to connect to the Cassandra DB, so after that I configured the Pega Data Type with the Concrete Class on Cassandra Table, so with that we can create the Pega Report Definitions and the Pega Data Pages to consume the Cassandra data. This solution has some limitations in comparison to the SQL tables queried from Pega, so will it be an easier way from the Pega Activity to query the Cassandra Table, having the Pega Data Type linked into the Cassandra Table, in comparison to using Java driver in Java step? I know that the Connect-SQL cannot be used with CQL, but maybe Pega has something similar, which is supported.