Connectors for watsonx.ai
You can add connections to a broad array of data sources for working with data in watsonx.ai. Source connections can be used to read data; target connections can 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.
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.
With the Download delivery method, the consumer receives a URL to download the data product directly from the source. The connection requires Read permissions.
With the Live access with the Flight service delivery method, the consumer receives a code snippet to include in their client or notebook.
Each type of connector supports one or more delivery methods. For more information, see Delivery methods for connectors.
When you create a data product using the Download data extract method, you need two connections, a source connection 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.
IBM services
- IBM Cloud Data Engine. Supports source connections only.
- IBM Cloud Databases for MongoDB. Supports source connections only.
- IBM Cloud Databases for MySQL
- 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 Big SQL
- IBM Db2 for i
- IBM Db2 for z/OS
- IBM Db2 on Cloud
- IBM Db2 Warehouse
- IBM Informix
- IBM Netezza Performance Server
- IBM Planning Analytics
- IBM watsonx.data
Third-party services
Many of the third-party services, data sources for working with data in watsonx.ai, are part of the ecosystem of watsonx technology partners. For information about watsonx integrations, see watsonx technology partners.
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Redshift
- Amazon S3
- Apache Cassandra
- Apache Derby
- Apache HDFS
- Apache Hive. Supports source connections only.
- Box
- Cloudera Impala. Supports source connections only.
- DataStax Enterprise
- Dremio. Supports source connections only.
- Dropbox
- Elasticsearch
- FTP
- Generic S3
- Google BigQuery
- 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 Storage
- Microsoft Azure File Storage
- Microsoft Azure SQL Database
- Microsoft SQL Server
- Milvus
- MongoDB. Supports source connections only.
- MySQL
- OData
- Oracle
- PostgreSQL
- Presto. Supports source connections only.
- Salesforce.com. Supports source connections only.
- SAP ASE
- 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) 2024 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..
Supported connectors by tool
The following tools support connections:
Learn more
Parent topic: Preparing data