Connecting to IBM Cloud Object Storage in Data Virtualization

Before you begin

Copy link to section

To access data that is stored in Cloud Object Storage, you must create a connection to the data source where the files are located. Data Virtualization 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

Copy link to section

To connect to IBM Cloud Object Storage in Data Virtualization, follow these steps.

Authenticating for Data Virtualization object storage connections is standard for all supported platforms.

1. On the navigation menu, click Data > Data virtualization. The Data sources page appears.

2. Click Add connection > New connection to view a list of data sources.

3. Select the Cloud Object Storage data source connection.

4. Enter the connection name and description.

5. To configure a Cloud Object Storage connection, you must provide values for the following parameters.

   • Bucket
   • Endpoint URL

   Note: Only Access key and Secret key authentication methods are supported when you create a connection to Cloud Object Storage.
6. Select your authentication method.

   To find the values for the Access key and Secret key, complete the following steps.

   Note: The Secret key field is not enabled until you enter an Access key.
   1. Go to the Cloud Object Storage Resource list at https://cloud.ibm.com/resources.
   2. Expand the Storage resource.
   3. Click the Cloud Object Storage service, and then click Service credentials.
   4. Expand the Key name that you want to use. Copy the following values without the quotation marks.
      • Access key: access_key_id
      • Secret key: secret_access_key

7. Click Create to add the connection to the data source environment.

Results

Copy link to section