We have a lot of customer data being stored in a Cassandra clusternal external to pega. We want to be able to use this data in rules but also to manipulate some of that data using CDH (by creating an activity rule for example that updates some fields).
What is the most efficient way to do this? Is it possible to use the power of cassandra and not simply first retrieve all data inside pega, do some stuff, query filter and join inside pega and then update the resultset back in Cassandra. Because first getting all data inside pega doesn't sound like a scalable option since we are talking about a lot of data (big data size).