Adding a connection to Ceph in Watson Query

Connecting to Ceph in Watson Query

The Ceph connector requires specific information to create a connection to it in Watson Query.

For more information, see Data sources in object storage in Watson Query.

Before you begin

To access data that is stored in Cloud Object Storage, you must create a connection to the data source where the files are located. Watson Query integrates with object storage connections and supports PARQUET (or PARQUETFILE), Optimized Row Columnar (ORC), comma-separated values (CSV), tab-separated values (TSV), and JSON data formats. All other file formats are not supported.

Procedure

To connect to Ceph in Watson Query, follow these steps.

On the navigation menu, click Data > Data virtualization. The service menu opens to the Data sources page by default.
Click Add connection > New connection to see a list of data sources that can be added to Watson Query.
Select the Ceph data source connection.
Enter the connection name and description.
Enter the access key ID (username) for authorizing access to Ceph in the Object store access ID.
Do not enter Additional properties. This field is not supported.
Enter the name of the Bucket that contains the files to access in Bucket.

You can enter a specific bucket to connect to as a data source or you can leave this field blank and specify a bucket when you virtualize the data source. For more information, see Creating a virtualized table from files in Cloud Object Storage in Watson Query.
Enter the endpoint URL to use for access to Ceph in the Object store service endpoint.
Enter the Object store service secret.
If the connection requires a custom SSL certificate, enter the certificate in the SSL certificate field.
Click Create to add the connection to the data source environment.

Results

You can now use your Ceph database as a data source in Watson Query.