Connect Cassandra put method
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 ?
Accepted Solution
Pegasystems Inc.
GB
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.
Pegasystems Inc.
IN
@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.
Pegasystems Inc.
GB
@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?
Pegasystems Inc.
IN
@MarijeSchillern INC-214351 has been created for further investigation
Accepted Solution
Pegasystems Inc.
GB
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.