Table of contents

Supported data sources for SPSS Modeler

Refer to this section for details about data source support when using SPSS Modeler.

IBM data sources

The following table lists the IBM data sources that you can connect to from SPSS Modeler.

For additional details about SQL pushback—including lists of nodes, CLEM expressions, and operators that support SQL pushback—see SQL optimization and its subsections.

For a list of databases that support using custom SQL queries to pull in data, see Data Asset node.

Connector Cloud Pak for Data as a Service Cloud Pak for Data Notes
Read Only Read & Write SQL Pushback Read Only Read & Write SQL Pushback
Analytics Engine HDFS    
Cloud Object Storage    
Cloud Object Storage (infrastructure)    
Cloudant  
Cognos Analytics    
Compose for MySQL      
Data Virtualization      
Data Virtualization Manager for z/OS        
Databases for PostgreSQL   SQL pushback not supported on Watson Machine Learning Server.
Db2   SQL pushback not supported on Watson Machine Learning Server.
Db2 Big SQL   SQL pushback not supported on Watson Machine Learning Server.
Db2 for i   SQL pushback not supported on Watson Machine Learning Server.
Db2 for z/OS   SQL pushback not supported on Watson Machine Learning Server.
Db2 Hosted   SQL pushback not supported on Watson Machine Learning Server.
Db2 on Cloud   SQL pushback not supported on Watson Machine Learning Server.
Db2 Warehouse   SQL pushback not supported on Watson Machine Learning Server.
HDFS via Execution Engine for Hadoop     You can write to an existing data asset, but writing to a new asset isn't supported currently.
Hive via Execution Engine for Hadoop  
Informix        
Netezza (PureData System for Analytics)   SQL pushback not supported on Watson Machine Learning Server
Planning Analytics ( formerly known as "IBM TM1")       Only the Replace the data set option is supported.
SPSS Analytic Server    
Storage volume     If your data contains a column or row delimiter such as a comma (,), your flow may fail when attempting to write to a storage volume. As a workaround, you can first use a Filler node to replace the delimiters.

Third-party data sources

The following table lists the third-party data sources that you can connect to from SPSS Modeler across three different product offerings. For additional details about SQL pushback—including lists of nodes, CLEM expressions, and operators that support SQL pushback—see SQL optimization and its subsections.

Connector Cloud Pak for Data as a Service Cloud Pak for Data Notes
Read Only Read & Write SQL Pushback Read Only Read & Write SQL Pushback
Amazon RDS for MySQL   Replace the data set option isn't supported for this connection.
Amazon RDS for PostgreSQL   Replace the data set option isn't supported for this connection.
Amazon Redshift SQL pushback not supported on Watson Machine Learning Server.
Amazon S3    
Apache Cassandra    
Apache Derby    
Apache HDFS (formerly known as "Hortonworks HDFS")        
Apache Hive      
Box    
Cloudera Impala SQL pushback not supported on Watson Machine Learning Server.
Dropbox    
FTP (remote file system transfer)    
Google BigQuery   SQL pushback not supported on Watson Machine Learning Server
HTTP            
Looker        
MariaDB        
Microsoft Azure Cosmos DB        
Microsoft Azure Data Lake Store    
Microsoft Azure SQL Database    
Microsoft SQL Server     SQL pushback not supported on Watson Machine Learning Server.
MinIO            
MongoDB            
MySQL        
OData          
Oracle     SQL pushback not supported on Watson Machine Learning Server.
Pivotal Greenplum     SQL pushback not supported on Watson Machine Learning Server.
PostreSQL     SQL pushback not supported on Watson Machine Learning Server.
Salesforce.com          
SAP HANA          
SAP OData          
Snowflake      
Sybase          
Sybase IQ          
Tableau          
Teradata           SQL pushback not supported on Watson Machine Learning Server

File types

The following file extensions are also supported for SPSS Modeler.

Connector Cloud Pak for Data as a Service Cloud Pak for Data
Read Only Read & Write Read Only Read & Write
CSV/delimited
Excel (XLS, XLSX)
JSON
SAV