Supported connectors for InfoSphere Information Server, Version 11.7
IBM® InfoSphere® Information Server supported connectors enable jobs to transfer data between InfoSphere Information Server and data sources.
IBM
InfoSphere
DataStage® and QualityStage®
jobs can access data in enterprise applications and data sources such as:
- Relational databases
- Mainframe databases
- Enterprise resource planning (ERP) or customer relationship management (CRM) databases
- Online analytical processing (OLAP) or performance management databases
- Business and analytic applications
The following table contains an alphabetized list of the connectors supported by InfoSphere
Information Server:
| Connectors | Type of data source |
|---|---|
| Amazon S3 | File |
| Azure Storage | File |
| Big data files | File |
| BigQuery | Database |
| Cassandra | Database |
| Cloud Object Storage | File |
| Cognos® TM1® | Database |
| Complex flat files | File |
| Data sets | File |
| Distributed transactions | Real-time processing data source |
| External sources | File |
| External targets | File |
| Files | File |
| File sets | File |
| Greenplum | Database |
| Hbase | Database |
| Hierarchical data | Real-time processing data source |
| Hive | Database |
| IBM Db2® | Database |
| IBM Informix® | Database |
| IBM InfoSphere Change Data Capture | Real-time processing data source |
| IBM InfoSphere Classic Federation Server for z/OS® | Database |
| IBM InfoSphere Master Data Management | Enterprise application |
| IBM Red Brick® Warehouse | Database |
| IBM UniVerse and UniData | Database |
| IBM WebSphere® ILOG® JRules (IBM Operational Decision Manager) | Business and analytic application |
| IBM WebSphere MQ | Real-time processing data source |
| InfoSphere Streams | Business and analytic application |
| iWay | Database |
| Java™ code | Custom connection |
| JDBC data sources | Multiple data sources |
| Kafka | Real-time processing data source |
| Lookup file sets | File |
| Microsoft SQL Server and MS OLE | Database |
| Netezza® | Database |
| ODBC data sources | Multiple data sources |
| Oracle | Database |
| Salesforce.com | Enterprise application |
| SAP applications | Enterprise application |
| SAP BW | Enterprise application |
| Sequential files | File |
| Siebel | Enterprise application |
| Snowflake | Database |
| Stored procedures | Multiple data sources |
| Sybase | Database |
| Teradata | Database |
| Unstructured data | File |
| Various relational database systems (DRS connector) | Multiple data sources |