To access your data in IBM Cloud Databases for DataStax, create a connection asset for it.
IBM Cloud Databases for DataStax is a scale-out NoSQL database in IBM Cloud that is built on Apache Cassandra. It’s designed to power real-time applications with high availability and massive scalability.
Create a connection to IBM Cloud Databases for DataStax
To create the connection asset, you need these connection details:
- Host name
- Port number
- Username and password
- Keyspace
- SSL certificate (if required by the database server)
Recommended values to insert into "SSL certificate", "Key certificate" and "Private key" fields can be found in secure-connect-bundle.zip. It can be downloaded from the Databases for DataStax instance
(tab Overview). After downloading secure connect bundle, unzip it, and you'll find the following:
- SSL certificate property: contents of
ca.crt - Private key property: contents of
key
In order to paste contents of key into Private key property, it has to be parsed to one-line. It can be done for example by executing following in the console: tr -d '\n' < key. The output from this command can be
put into Private key property.
- Key certificate property: contents of
cert
For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.
Choose the method for creating a connection based on where you are in the platform
- In a project
- Click Assets > New task > Connect to a data source. See Adding a connection to a project.
- In a deployment space
- Click Add to space > Connection. See Adding connections to a deployment space.
- In the Platform assets catalog
- Click New connection.
Next step: Add data assets from the connection
Where you can use this connection
Projects
- Data Refinery
- SPSS Modeler
Catalogs
- Platform assets catalog
IBM Cloud Databases for DataStax setup
Learn more
IBM Cloud Databases for DataStax Documentation
Parent topic: Supported connections