Question

3
Replies
1086
Views
 Anil Kumar Ginjupalli (AnilG502)
Adqura

Adqura
IN
AnilG502 Member since 2015 9 posts
Adqura
Posted: February 13, 2017
Last activity: March 7, 2017
Posted: 13 Feb 2017 4:24 EST
Last activity: 7 Mar 2017 2:35 EST
Closed
Solved

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

Data Integration
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: 4 years ago
Posted: 13 Feb 2017 8:00 EST
Anil Kumar Ginjupalli (AnilG502)
Adqura

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

Posted: 4 years ago
Posted: 21 Feb 2017 5:41 EST
Santhosh Holla Kayyar (Santhosh_Holla)
PEGA
Technical Lead
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