Connecting to MinIO in Data Virtualization

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. 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

To connect to MinIO in Data Virtualization, follow these steps.

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 MinIO data source connection.

4. Enter the connection name and description.

5. Enter the access key ID (username) for authorizing access to MinIO in the Object store access ID field.

6. Do not enter a value in the Additional properties field. This field is not supported.

7. Enter the name of the bucket that contains the files to access in the Bucket field.

   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 navigate the data source. For more information, see Creating a virtualized table from files in Cloud Object Storage in Data Virtualization.

8. Enter the endpoint URL to use for access to MinIO in the Object store service endpoint field. MinIO URLs typically use the format http://endpoint:9000 or https://endpoint:9000.

9. Enter the secret in the Object store service secret field.

10. If the connection requires a custom SSL certificate, enter the certificate in the SSL certificate field.

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

Results