How can i connect to external Cassandra database?
How can we retrieve data from the external Cassandra database table and put the retrieved data onto data set?
Step1:- Retrieve data from external Cassandra Database table.
Step2:- Use retrieved data into to Data set.
Thanks,
Anil G
Pegasystems Inc.
IN
Hi,
Can you check if this link helps ?
https://collaborate.pega.com/discussion/connecting-external-database-pega-personal-edition
Adqura
IN
Thanks for your response.
I am unable to connect external Cassandra database through jdbc URL or jdbc connection pool from data base rule.
Accepted Solution
Pegasystems Inc.
IN
Hi Anil,
Nodes assigned to the Decision Data Store service can use an external Cassandra cluster. So that data can be loaded into, or extracted from, the D-Node cluster, you must enable external connections. Once you have enabled this setting, you can connect to the D-Node cluster using third party or custom tools to do the data loading/extraction through the Thrift protocol on port 9160, or CQL3 Cassandra protocol on port 9042. Based on the schema the data is added to, it is stored through the Cassandra process. Cassandra being a distributed database, and configured to be fault tolerant to a degree, the data is distributed and replicated across the cluster and stored in SSTable format in the node's file system. When enabling external connections, you must provide the user name and password. A default user name (dnode_ext) is added when you enable external connections for the first time.
Please refer the DSM Operations guide for more details.
Thanks & Regards,
Santhosh