Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Anil Kumar Ginjupalli (Anil Ginjupalli)
Ocbc Bank
System Analyst
Ocbc Bank
SG
Anil Ginjupalli Member since 2020 9 posts
Ocbc Bank
Posted: Feb 13, 2017
Last activity: Mar 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

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 8 years ago
Posted: 21 Feb 2017 5:41 EST
Santhosh Holla Kayyar (Santhosh_Holla)
PEGA
Fellow Technical Support Engineer
Pegasystems Inc.
AU

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

To see attachments, please log in.
Posted: 8 years ago
Posted: 13 Feb 2017 8:00 EST
Anil Kumar Ginjupalli (Anil Ginjupalli)
Ocbc Bank
System Analyst
Ocbc Bank
SG

Thanks for your response. 

I am unable to connect external Cassandra database through jdbc URL or jdbc connection pool from data base rule.

 

 

 

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 21 Feb 2017 5:41 EST
Santhosh Holla Kayyar (Santhosh_Holla)
PEGA
Fellow Technical Support Engineer
Pegasystems Inc.
AU

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice