0 / 0
Supported data sources (SPSS Modeler)

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 and its subsections.

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

Connector Read Only Read & Write SQL Pushback Notes
Amazon RDS for MySQL   Replace the data set option isn't supported for this connection.
Amazon RDS for Oracle    
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    
Box    
Connector Read Only Read & Write SQL Pushback Notes
Cloud Object Storage  
Cloud Object Storage (infrastructure)  
Cloudant
Cloudera Impala  
Cognos Analytics  
Db2    
Db2 Big SQL    
Connector Read Only Read & Write SQL Pushback Notes
Db2 for i    
Db2 for z/OS    
Db2 on Cloud    
Db2 Warehouse    
Dropbox  
FTP (remote file system transfer)  
Google BigQuery SPSS Modeler does not support the Delete Then Insert option for SQL pushback.
Google Cloud Storage      
Greenplum    
Connector Read Only Read & Write SQL Pushback Notes
HTTP      
IBM Cloud Databases for MySQL    
IBM Cloud Data Engine      
IBM Cloud Databases for MongoDB      
IBM Cloud Databases for PostgreSQL    
Informix      
Looker      
MariaDB    
Microsoft Azure Blob Storage      
Connector Read Only Read & Write SQL Pushback Notes
Microsoft Azure Cosmos DB    
Microsoft Azure Data Lake Storage  
Microsoft Azure File Storage      
Microsoft Azure SQL Database  
Microsoft SQL Server   SQL pushback isn't supported when Active Directory is enabled.
MongoDB      
MySQL      
Netezza Performance Server    
OData      
Oracle    
Connector Read Only Read & Write SQL Pushback Notes
Planning Analytics (formerly known as "IBM TM1")     Only the Replace the data set option is supported.
PostgreSQL    
Presto      
Salesforce.com      
SAP ASE      
SAP IQ      
SAP OData      
SingleStoreDB      
Snowflake    
Tableau      
Teradata    

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
Avro
CSV, Delimited
JSON
ORC
Parquet
SAS
SAV (SPSS Statistics)  
SHP
XLS, XLSX (Excel)
XML  
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