Supported data sources for SPSS Modeler

In SPSS Modeler, you can connect to your data no matter where it lives.

Connectors

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

For more information about SQL pushback (such as lists of nodes, CLEM expressions, and operators that support SQL pushback), see SQL optimization.

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

Note: If you enable SSL and use a custom certificate for the connection, many of the connectors that support SQL pushback can no longer use it. Only these connectors still support SQL pushback:
  • Db2
  • Db2 Big SQL
  • Db2 for z/OS
  • Db2 Warehouse
  • Microsoft SQL Server
Connector Read Only Read & Write SQL Pushback Notes
Amazon RDS for MySQL ✓ ✓ AWS IBM Cloud
  • IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
  • Replace the data set option isn't supported for this connection.
Amazon RDS for Oracle ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Amazon RDS for PostgreSQL ✓ ✓ Replace the data set option isn't supported for this connection.
Amazon Redshift ✓ ✓  
Amazon S3 ✓    
Apache Cassandra ✓    
Apache Derby ✓    
Apache HDFS (formerly known as "Hortonworks HDFS")   ✓    
Apache Hive ✓   ✓  
Apache Impala ✓ ✓  
Box   ✓  
Cloud Object Storage ✓  
Cloud Object Storage (infrastructure) ✓  
Cloudant ✓
Cognos Analytics ✓  
Connector Read Only Read & Write SQL Pushback Notes
DataStax Enterprise   ✓    
Db2   ✓ ✓  
Db2 Big SQL   ✓ ✓  
Db2 for i   ✓ ✓  
Db2 for z/OS   ✓ ✓  
Db2 on Cloud   ✓ ✓  
Db2 Warehouse   ✓ ✓  
Dremio ✓      
Dropbox ✓  
FTP (remote file system transfer) ✓  
Google BigQuery ✓ ✓ Google BigQuery has these limitations when SQL pushback is enabled:
  • Data streaming isn't used to insert data in a Data Asset Export node
  • Special characters aren't allowed in column names
  • You can't use the Delete Then Insert option

For more information, see Known issues and limitations for SPSS Modeler.
Google Cloud Storage   ✓    
Greenplum   ✓ ✓  
HTTP ✓      
Connector Read Only Read & Write SQL Pushback Notes
IBM Cloud Databases for MySQL   ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
IBM Cloud Data Engine ✓      
IBM Cloud Databases for MongoDB ✓      
IBM Cloud Databases for PostgreSQL   ✓ ✓  
IBM watsonx.data Presto ✓   ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Informix   ✓    
Looker ✓    
MariaDB ✓    
Microsoft Azure Blob Storage   ✓    
Microsoft Azure Cosmos DB ✓    
Microsoft Azure Databricks   ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Microsoft Azure Data Lake Storage ✓  
Microsoft Azure File Storage   ✓    
Microsoft Azure SQL Database ✓ ✓  
Microsoft Azure Synapse Analytics   ✓ ✓  
Microsoft SQL Server   ✓ ✓ You cannot use SQL pushback when Active Directory is enabled.
Connector Read Only Read & Write SQL Pushback Notes
MongoDB ✓      
MySQL   ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Netezza Performance Server   ✓ ✓  
OData   ✓    
Oracle   ✓ ✓  
Planning Analytics (formerly known as "IBM TM1")   ✓   Only the Replace the data set option is supported.
PostgreSQL   ✓ ✓  
Presto ✓   ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Salesforce.com   ✓    
SAP ASE   ✓    
SAP IQ ✓      
SAP OData   ✓    
SingleStoreDB   ✓    
Snowflake   ✓ ✓ You cannot use SQL pushback when key-pair authentication is enabled. You must use username and password instead.
Tableau ✓      
Teradata   ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.
Vertica   ✓ ✓ AWS IBM Cloud IBM Cloud SQL Pushback is available only in the Sydney and Toronto regional data centers.

Data files

In addition to using data from remote data sources or integrated databases, you can use data from files. You can work with data from the following types of files in SPSS Modeler.

Connector Read Only Read & Write Notes
Avro ✓  
CSV, Delimited ✓
Attention: If your .csv file contains any malicious payloads in an input field (in formulas for example), these payloads might be executed.
JSON ✓  
ORC  
Parquet ✓  
SAS ✓  
SAV (SPSS Statistics)   ✓  
SHP  
XLS, XLSX (Excel) ✓  
XML   ✓