Supported data sources (SPSS Modeler) | IBM Data Product Exchange

Supported data sources for SPSS Modeler

Last updated: Oct 09, 2024

Supported data sources (SPSS Modeler)

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

Connectors
Data files

Connectors

The following table lists the 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	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 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	✓
Data Virtualization Manager for z/OS	✓
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		✓
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 DataStax		✓
IBM Cloud Databases for MongoDB	✓
IBM Cloud Databases for PostgreSQL		✓
IBM Watson Query	✓
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		✓	✓
Salesforce.com	✓
SAP ASE		✓
SAP IQ	✓
SAP OData		✓
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		✓
Excel (XLS, XLSX)		✓
JSON		✓
ORC
Parquet
SAS	✓
SAV		✓
SHP
XML		✓