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 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 Watson Studio Desktop Cloud Pak for Data Notes
Read Only Read & Write SQL Pushback Read Only Read & Write SQL Pushback Read Only Read & Write SQL Pushback
Analytics Engine HDFS (formerly known as "BigInsights HDFS")    
Cloud Object Storage    
Cloud Object Storage (infrastructure)    
Cloudant   You can write to an existing data asset, but writing to a new asset isn't supported currently.
Cognos Analytics    
Compose for MySQL      
Data Virtualization          
Data Virtualization Manager for z/OS            
Databases for PostgreSQL     Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 Big SQL   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 for i   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 for z/OS   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 Hosted   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 on Cloud   Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Db2 Warehouse   Cloud Pak for Data as a Service and Cloud Pak for Data: 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 Watson Studio Desktop Cloud Pak for Data Notes
Read Only Read & Write SQL Pushback 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 Cloud Pak for Data as a Service and Cloud Pak for Data: 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 Cloud Pak for Data as a Service and Cloud Pak for Data: 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       Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
MinIO                  
MongoDB                  
MySQL            
OData              
Oracle       Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
Pivotal Greenplum       Cloud Pak for Data as a Service and Cloud Pak for Data: SQL pushback not supported on Watson Machine Learning Server.
PostreSQL       Cloud Pak for Data as a Service and Cloud Pak for Data: 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 Watson Studio Desktop Cloud Pak for Data
Read Only Read & Write Read Only Read & Write Read Only Read & Write
CSV/delimited
Excel (XLS, XLSX)
JSON
SAV