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.
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 SPSS Analytic Server. Supports source connections only.
-
Impala via Execution Engine for Hadoop. Supports source connections only.
Third-party services
- Amazon Aurora for MySQL
- Amazon Aurora for PostgreSQL
- 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 Hive Metastore
- Apache Impala. Supports source connections only.
- Apache Kafka
- Apache Spark SQL
- Box
- ClickHouse
- Collibra
- Confluence
- DataStax Enterprise
- DataStax HCD
- 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.
- Iceberg metastore
- 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 watsonx.data intelligence) only.
- Microsoft Power BI Desktop. Metadata import (IBM watsonx.data intelligence) only.
- Microsoft SQL Server
- Microsoft SQL Server Integration Services. Metadata import (IBM watsonx.data intelligence) only.
- Microsoft SQL Server Reporting Services. Metadata import (IBM watsonx.data intelligence) only.
- MicroStrategy. Metadata import (IBM watsonx.data intelligence) only.
- Milvus
- MinIO
- MongoDB. Supports source connections only.
- MySQL
- OData
- OpenSearch
- Oracle
- Oracle Business Intelligence Enterprise Edition. Metadata import (IBM watsonx.data intelligence) only.
- Oracle Data Integrator. Metadata import (IBM watsonx.data intelligence) only.
- PostgreSQL
- Presto. Supports source connections only.
- Qlik Sense. Metadata import (IBM watsonx.data intelligence) only.
- Salesforce.com. Supports source connections only.
- SAP ASE
- SAP HANA
- SAP IQ. Supports source connections only.
- SAP OData
- SingleStoreDB
- Slack
- Snowflake
- Tableau. Supports source connections only.
- Teradata
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:
-
IBM watsonx.data intelligence (Data quality rules, Metadata enrichment, Metadata import)