Connectors for Data Product Hub
Most methods for creating a data product require a connection to a data source. You can add connections to access a broad selection of data sources to create and deliver data products. Connections are used as either a source for accessing the items in a data product, or as a target for storing data extracts. Source connections are used to create data products and require Read or Read-Only permissions. Target connections are used as a location to save data extracts to deliver data products to consumers. When you create a target connection for your data extracts, assign Read/Write permissions to provide access to the data extracts.
When a connection is created, the credentials entered by the connection owner are automatically saved for delivering a data product. Read-Only access to the data source is recommended.
Connections and delivery methods
Download: The consumer receives a URL to download the data product directly from the source. The connection requires Read permissions.
Live access with the Flight service: The consumer receives a code snippet to include in their client or notebook.
Download data extract: Data extracts require two connections: a source connection from where the files are extracted and a target connection where the files are saved. Consumers access the target connection to download data extracts. Thus the credentials for a target connection require Read/Write permissions, so that the producer can save the file for the data extract and the consumer can download the extracted files.
Each type of connector supports one or more delivery methods. For more information, see Delivery methods for connectors.
Platform connections
Platform connections are not enabled in Data Product Hub, and you cannot create platform connections. However, you can add assets to a data product from catalogs or projects that use a platform connection. In this case, the platform connection is copied as a regular connection source.
Supported connectors for Data Product Hub
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Redshift Supports SQL assets.
- Amazon S3
- Apache Cassandra Supports SQL assets.
- Apache Derby
- Apache HDFS
- Apache Hive Supports source connections only and SQL assets.
- Apache Impala Supports source connections only.
- Cloudant
- Dremio Supports source connections only.
- Dropbox
- Elasticsearch
- Google BigQuery Supports SQL assets.
- Google Cloud Storage
- Google Looker Supports source connections only.
- HTTP Supports source connections only.
- IBM Cloud Data Engine
- IBM Cloud Databases for MongoDB
- IBM Cloud Databases for PostgreSQL
- IBM Cloud Object Storage
- IBM Cognos Analytics Supports source connections only.
- IBM Data Virtualization Supports SQL assets.
- IBM Data Virtualization Manager for z/OS
- IBM Db2 Big SQL
- IBM Db2 for i
- IBM Db2 for z/OS
- IBM Db2 on Cloud
- IBM Db2 Warehouse on Cloud
- IBM Db2 Supports SQL assets.
- IBM Informix
- IBM Netezza Performance Server
- IBM Planning Analytics
- IBM watsonx.data Presto Supports SQL assets.
- MariaDB
- Microsoft Azure Blob Storage
- Microsoft Azure Cosmos DB
- Microsoft Azure Data Lake Storage
- Microsoft Azure File Storage
- Microsoft SQL Server Supports SQL assets.
- MongoDB Supports source connections only.
- MySQL Supports SQL assets.
- OData
- Oracle Supports SQL assets.
- PostgreSQL Supports SQL assets.
- Presto Supports source connections only.
- Salesforce.com Supports source connections only.
- SAP OData
- SingleStoreDB
- Snowflake Supports SQL assets for 5.0.1 and later.
- Teradata Supports SQL assets.