You can add connections to a broad array of data sources in projects and catalogs. 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.
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 Data Virtualization, you can create connections on the Connectivity page or on the Data virtualization > Data sources page. For more information, see Adding and connecting to data sources in Data Virtualization.
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. Supports source connections only.
- IBM Data Virtualization Manager for z/OS
- IBM Db2
- IBM Db2 for DataStage. DataStage only.
- IBM Db2 Big SQL
- IBM Db2 for i
- IBM Db2 for z/OS
- IBM Db2 on Cloud
- IBM Db2 Warehouse
- IBM Informix
- IBM Match 360
- IBM MQ. DataStage only.
- IBM Netezza Performance Server
- IBM Netezza Performance Server for DataStage. DataStage only.
- IBM Planning Analytics
- IBM watsonx.data Milvus
- IBM watsonx.data Presto
Third-party services
-
Apache Cassandra for DataStage DataStage only.
-
Apache Hive. Supports source connections only.
-
Apache Impala. Supports source connections only.
-
Dremio. Supports source connections only.
-
Google Cloud Pub/Sub. DataStage only.
-
Google Looker. Supports source connections only.
-
HTTP. Supports source connections only.
-
MongoDB. Supports source connections only.
-
ODBC. DataStage only.
-
Oracle Database for DataStage. DataStage only.
-
Presto. Supports source connections only.
-
Salesforce.com. Supports source connections only.
-
Salesforce API for DataStage. DataStage only.
-
SAP IQ. Supports source connections only.
-
Tableau. Supports source connections only.
-
Teradata database for DataStage. DataStage only.
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 and services support connections:
- AutoAI
- Cognos Dashboards
- Data Refinery
- Data Replication
- Data Virtualization
- DataStage
- Decision Optimization
- IBM Knowledge Catalog (Data quality rules, Metadata enrichment, Metadata import)
- IBM Match 360
- Notebooks
- SPSS Modeler
Learn more
Parent topic: Preparing data