Connectors for projects and catalogs
You can add connections to a broad array of services (data sources) in analytics projects and catalogs. Source connections can only be used to read data; target connections can only be used to load (save) data. When you create a target connection, be sure to use credentials that have Write permission or you won't be able to save data to the target.
From a project, you must create a connection to a data source before you can read data from it or load data to it.
From a catalog, you must add a connection asset before you can add data assets for the tables you can access from the connection.
From Watson Query, you can create connections on the Platform connections page or on the Data virtualization > Data sources page. For more information, see Adding and connecting to data sources in Watson Query.
IBM services
- Analytics Engine HDFS
- HDFS via Execution Engine for Hadoop
- Hive via Execution Engine for Hadoop (Supports source connections only)
- IBM Cloud Compose for MySQL
- IBM Cloud Data Engine (Supports source connections only)
- IBM Cloud Databases for DataStax
- IBM Cloud Databases for MongoDB (Supports source connections only)
- IBM Cloud Databases for PostgreSQL
- IBM Cloud Object Storage
- IBM Cloud Object Storage (infrastructure)
- IBM Cloudant
- IBM Cognos Analytics (Supports source connections only)
- IBM Data Virtualization Manager for z/OS
- IBM Db2
- IBM Db2 (optimized) (DataStage only)
- IBM Db2 Big SQL
- IBM Db2 Event Store
- IBM Db2 for i
- IBM Db2 for z/OS
- IBM Db2 Hosted
- IBM Db2 on Cloud
- IBM Db2 Warehouse
- IBM Informix
- IBM Match 360
- IBM MQ (DataStage only)
- IBM Netezza Performance Server
- IBM Planning Analytics
- IBM SPSS Analytic Server (Supports source connections only)
- IBM Watson Query (Supports source connections only)
- Impala via Execution Engine for Hadoop (Supports source connections only)
- Storage volume
Third-party services
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Redshift
- Amazon S3
- Apache Cassandra
- Apache Derby
- Apache HBase (DataStage only)
- Apache HDFS
- Apache Hive (Supports source connections only)
- Apache Kafka
- Box
- Cloudera Impala (Supports source connections only)
- Dremio (Supports source connections only)
- Dropbox
- Elasticsearch
- Exasol
- FTP
- Generic S3
- Google BigQuery
- Google Cloud Pub/Sub (DataStage only)
- Google Cloud Storage
- Greenplum
- HTTP (Supports source connections only)
- Looker (Supports source connections only)
- MariaDB
- Microsoft Azure Blob Storage
- Microsoft Azure Cosmos DB
- Microsoft Azure Data Lake Store
- Microsoft Azure File Storage
- Microsoft Azure SQL Database
- Microsoft Power BI (Azure)
- Microsoft Power BI (Local)
- Microsoft SQL Server
- MinIO
- MongoDB (Supports source connections only)
- MySQL
- OData
- ODBC (DataStage only)
- Oracle
- PostgreSQL
- Presto (Supports source connections only)
- Salesforce.com (Supports source connections only)
- Salesforce.com (optimized) (DataStage only)
- SAP ASE (Supports source connections only)
- SAP Bulk Extract (DataStage only. Supports source connections only)
- SAP Delta Extract (DataStage only. Supports source connections only)
- SAP HANA
- SAP IDoc (DataStage only)
- SAP IQ (Supports source connections only)
- SAP OData
- SingleStoreDB
- Snowflake
- Tableau (Supports source connections only)
- Teradata
Teradata JDBC Driver 17.00.00.03 Copyright (C) 2020 by Teradata. All rights reserved. IBM provides embedded usage of the Teradata JDBC Driver under license from Teradata solely for use as part of the IBM Watson service offering.
User-defined
Supported connectors by tool
The following tools and services support connections:
Learn more
Parent topic: Supported data sources