Supported connectors for Flight service
Flight service is a library of connectors as a service that provides a single interfact to connect to a variety of data sources. Flight service's supported library of connectors includes connectors for IBM, third-party, and user-defined data sources.
From a catalog, you must add a connection asset before you can add data assets for the tables you can access from the connection.
Required services
To see a full list of services that accept custom Python or R code for the Flight service APIs, see "Services and tools" in Accessing data sources with Flight service.
Supported connectors
Flight service includes the following connectors in its library of connectors:
IBM services
- HDFS via Execution Engine for Hadoop
- 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 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 Match 360
- IBM Netezza Performance Server
- IBM Planning Analytics
- IBM Product Master
- IBM SPSS Analytic Server. Supports source connections only.
- IBM watsonx.data Presto
- 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 HDFS
- Apache Hive. Supports source connections only.
- Apache Impala. Supports source connections only.
- Box
- DataStax Enterprise
- Dremio. Supports source connections only.
- Dropbox
- Elasticsearch
- Exasol
- FTP
- Generic S3
- Google BigQuery
- 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 File Storage
- Microsoft Azure SQL Database
- Microsoft SQL Server
- Milvus
- MinIO
- MongoDB. Supports source connections only.
- MySQL
- OData
- Oracle
- PostgreSQL
- Presto. Supports source connections only.
- Salesforce.com. Supports source connections only.
- SAP ASE
- SAP HANA
- 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.
- 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
For a list of supported properties per data source, see [Data and AI Common Core API Datasource types] list defined types of data source.|