Connectors for projects and catalogs
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
-
Hive via Execution Engine for Hadoop. Supports source connections only.
-
IBM Cloud Data Engine. Supports source connections only.
-
IBM Cloud Databases for MongoDB. Supports source connections only.
-
IBM Cognos Analytics. Supports source connections only.
-
IBM Data Replication Access Server. Data Replication only.
-
IBM Data Virtualization. Supports source connections only.
-
IBM Db2 for DataStage. DataStage only.
-
IBM MQ. DataStage only.
-
IBM Netezza Performance Server for DataStage. DataStage only.
-
IBM SPSS Analytic Server. Supports source connections only.
-
Impala via Execution Engine for Hadoop. Supports source connections only.
Third-party services
- Amazon RDS for MySQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Redshift
- Amazon S3
- Apache Cassandra
- Apache Cassandra for DataStage DataStage only.
- Apache Derby
- Apache HBase. DataStage only.
- Apache HDFS
- Apache Hive. Supports source connections only.
- Apache Hive Metastore
- Apache Impala. Supports source connections only.
- Apache Kafka
- Apache Spark SQL
- Box
- Collibra
- DataStax Enterprise
- Denodo
- Dremio. Supports source connections only.
- Dropbox
- Elasticsearch
- Elastic Cloud
- Exasol
- FTP
- Generic S3
- Google BigQuery
- Google Cloud Pub/Sub. DataStage only.
- Google Cloud Storage
- Google Looker. Supports source connections only.
- Greenplum
- HTTP. Supports source connections only.
- MariaDB
- Microsoft Azure Blob Storage
- Microsoft Azure Cosmos DB
- Microsoft Azure Data Lake Storage
- Microsoft Azure Databricks
- Microsoft Azure Fabric Warehouse
- Microsoft Azure File Storage
- Microsoft Azure PostgreSQL
- Microsoft Azure SQL Database
- Microsoft Azure Synapse Analytics
- Microsoft OneDrive
- Microsoft SharePoint Lists
- Microsoft Power BI (Azure). Metadata import (IBM Knowledge Catalog) only.
- Microsoft Power BI Desktop. Metadata import (IBM Knowledge Catalog) only.
- Microsoft SQL Server
- Microsoft SQL Server Integration Services. Metadata import (IBM Knowledge Catalog) only.
- Microsoft SQL Server Reporting Services. Metadata import (IBM Knowledge Catalog) only.
- MicroStrategy. Metadata import (IBM Knowledge Catalog) only.
- Milvus
- MinIO
- MongoDB. Supports source connections only.
- MySQL
- OData
- ODBC. DataStage only.
- Oracle
- Oracle Database for DataStage. DataStage only.
- Oracle Business Intelligence Enterprise Edition. Metadata import (IBM Knowledge Catalog) only.
- Oracle Data Integrator. Metadata import (IBM Knowledge Catalog) only.
- PostgreSQL
- Presto. Supports source connections only.
- Qlik Sense. Metadata import (IBM Knowledge Catalog) only.
- Salesforce.com. Supports source connections only.
- Salesforce API for DataStage. DataStage only.
- SAP ASE
- SAP BAPI. DataStage only.
- SAP Bulk Extract. DataStage only. Supports source connections only.
- SAP BusinessObjects. Metadata import (IBM Knowledge Catalog) 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
- Slack
- Snowflake
- Tableau. Supports source connections only.
- Teradata
- 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. - Trino
- Vertica.
User-defined
- Custom JDBC connector. The name, details, and properties of the connection are defined by the administrator who creates the connector.
- Generic JDBC
Supported connectors by tool
The following tools and services support connections:
- AutoAI
- Cognos Dashboards
- Data Refinery
- Data Virtualization
- DataStage
- Decision Optimization
- Flight service
- IBM Knowledge Catalog (Data quality rules, Metadata enrichment, Metadata import)
- Notebooks
- SPSS Modeler
- Synthetic Data Generator
- Tuning Studio in the watsonx documentation.