Connect Cassandra put method

Pega-as-a-Service
, , , , , ,
1

Hi All,

I am doing a POC on connect cassandra where in I am trying to access external Cassandra DB and persist some properties on a table including primary keys and exposed columns in cassandra table. Despite mapping them in the ruleform, I am unable to persist the “non-primary” key columns in table.

Is this a limitation or am I missing anything ?

2

Any help is appreciated

3

@vijaa do you see any errors in the logs?

4

@MarijeSchillern No errors were seen in the logs. The latest is that - Both primary and exposed key values are persisted in the table(chcked by connecting to external cassandra and running a CQL query on the table) but when we perform a dataset-execute browse method to retrieve the information based on primary keys, it doesnt returned the exposed column values.

5

@vijaa I think that this requires a more in-depth analysis which can only be carried out by our Support team.

Can you log this as a support incident ticket and let us know the INC id once you have submitted it?

6

@MarijeSchillern INC-214351 has been created for further investigation

7

I checked the status of INC-214351.

Issue statement:

Cassandra Put Method works and client able to persist the data into the DDS table.When client run a dataset browse on the dataset to see the values - it returns only the “primary key”

The conclusion of the problem is listed below:

Explanation:
We cannot club Connect-Cassandra and Data set methods together. Connect Cassandra is very much specific to connecting to external Cassandra tables and updating records using Get/Put methods.

If we want to write / read records from external Cassandra, we need to use only “Get/Put” methods to do so.

DataSet-Execute methods of save/browse work differently because they are OOTB code and they use a different data model for storing the records and encryption internally.

Using a combination of dataset and connect Cassandra methods is not supported by Pega product.

The connect cassandra rule form allows you to provide more than one host of a single cluster as comma-separated list. If you want to connect to multiple hosts , then you can provide the comma-separated list of hosts in the connect cassandra rule.