0 / 0
Supported data sources in DataStage

Supported data sources in DataStage

Data source connectors provide data connectivity and metadata integration to external data sources, such as relational databases, cloud storage services, or messaging software.

DataStage® supports the following data sources. To establish the connection for the DataStage connector for these data sources, see Connecting to a data source in DataStage.

The "for DataStage" version of a connection gives you increased performance and more features such as before and after SQL statements and reject links. However, you cannot use the "for DataStage" connection outside of the DataStage service. You can use connections that are available to other tools and services (for example, the Salesforce.com connection), if you already created the connection, and you want to reuse it in DataStage.

Connection Corresponding DataStage connector
Amazon RDS for MySQL Amazon RDS for MySQL
Amazon RDS for Oracle Amazon RDS for Oracle
Amazon RDS for PostgreSQL Amazon RDS for PostgreSQL
Amazon Redshift Amazon Redshift
Amazon S3 Amazon S3
Apache Cassandra Apache Cassandra
Apache Cassandra for DataStage* Apache Cassandra for DataStage
Apache Cassandra data source in ODBC* ODBC
Apache Derby Apache Derby
Connection Corresponding DataStage connector
Apache HDFS Apache HDFS
Apache Hive

Supports source connections only.

Apache Hive
Apache Hive data source in ODBC* ODBC
Apache Kafka Apache Kafka
Box Box
Apache Impala

Supports source connections only.

Apache Impala
DataStax Enterprise DataStax Enterprise
Dremio Dremio
Dropbox Dropbox
Elasticsearch Elasticsearch
Connection Corresponding DataStage connector
FTP FTP
Generic S3 Generic S3
Google BigQuery Google BigQuery
Google BigQuery data source in ODBC* ODBC
Google Cloud Pub/Sub* Google Cloud Pub/Sub
Google Cloud Storage Google Cloud Storage
Greenplum Greenplum
Greenplum data source in ODBC* ODBC
HTTP

Supports source connections only.

HTTP
Connection Corresponding DataStage connector
IBM Cloud® Data Engine IBM Cloud Data Engine
IBM Cloud Databases for MongoDB

Supports source connections only.

IBM Cloud Databases for MongoDB
IBM Cloud Databases for MySQL IBM Cloud Databases for MySQL
IBM Cloud Databases for PostgreSQL IBM Cloud Databases for PostgreSQL
IBM Cloud Object Storage IBM Cloud Object Storage
IBM Cognos Analytics

Supports source connections only.

IBM Cognos Analytics
IBM Data Virtualization

Supports source connections only.

IBM Data Virtualization
IBM® Data Virtualization Manager for z/OS® IBM Data Virtualization Manager for z/OS
IBM Db2® IBM Db2
IBM Db2 for DataStage* IBM Db2 for DataStage
IBM Db2 Big SQL IBM Db2 Big SQL
Connection Corresponding DataStage connector
IBM Db2 data source in ODBC* ODBC
IBM Db2 for i IBM Db2 for i
IBM Db2 for z/OS IBM Db2 for z/OS
IBM Db2 on Cloud IBM Db2 on Cloud
Connection Corresponding DataStage connector
IBM Db2 on iSeries (AS400) data source in ODBC* ODBC
IBM Db2 on Linux on System z data source in ODBC* ODBC
IBM Db2 Warehouse IBM Db2 Warehouse
IBM Informix® IBM Informix
IBM Informix data source in ODBC* ODBC
IBM Match 360 IBM Match 360
IBM MQ* IBM MQ
IBM Netezza® Performance Server IBM Netezza Performance Server
Connection Corresponding DataStage connector
IBM Netezza Performance Server for DataStage* IBM Netezza Performance Server for DataStage
IBM Netezza data source in ODBC* ODBC
IBM Planning Analytics IBM Planning Analytics
IBM watsonx.data Presto IBM watsonx.data Presto
Impala data source in ODBC* ODBC
Google Looker

Supports source connections only.

Google Looker
MariaDB MariaDB
Microsoft Azure Blob Storage Microsoft Azure Blob Storage
Microsoft Azure Cosmos DB Microsoft Azure Cosmos DB
Microsoft Azure Data Lake Storage Microsoft Azure Data Lake Storage
Microsoft Azure Databricks Microsoft Azure Databricks
Microsoft Azure File Storage Microsoft Azure File Storage
Microsoft Azure SQL Database Microsoft Azure SQL Database
Connection Corresponding DataStage connector
Microsoft SQL Server Microsoft SQL Server
Microsoft SQL Server data source in ODBC* ODBC
MongoDB

Supports source connections only.

MongoDB
MongoDB data source in ODBC* ODBC
MySQL MySQL
MySQL data source in ODBC* ODBC
ODBC*

Multiple data sources are available from the ODBC connection, which is optimized for DataStage.

Oracle Oracle
Oracle Database for DataStage* Oracle Database for DataStage
Oracle data source in ODBC* ODBC
PostgreSQL PostgreSQL
Connection Corresponding DataStage connector
PostgreSQL data source in ODBC* ODBC
Presto

Supports source connections only.

Presto
Salesforce API for DataStage* Salesforce API for DataStage
Salesforce.com

Supports source connections only.

Salesforce.com
SAP ASE SAP ASE
SAP ASE data source in ODBC* ODBC
SAP IQ

Supports source connections only.

SAP IQ
Connection Corresponding DataStage connector
SAP IQ data source in ODBC* ODBC
SAP OData SAP OData
SingleStoreDB SingleStoreDB
Snowflake Snowflake
Tableau Tableau
Teradata Teradata
Teradata database for DataStage* Teradata database for DataStage

* Denotes a connection that is available for DataStage only.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more