Last updated: Nov 07, 2024
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.
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
- Microsoft SQL Server
| 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 | ✓ | ✓ | ||
| Apache Impala | ✓ | ✓ | SPSS Modeler supports only the Username and password authentication method. | |
| 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 Cloud Storage | ✓ | |||
| Greenplum | ✓ | ✓ | ||
| HTTP | ✓ | |||
| Connector | Read Only | Read & Write | SQL Pushback | Notes |
| 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 | ✓ | |||
| Microsoft Azure Cosmos DB | ✓ | |||
| Microsoft Azure Databricks | ✓ | |||
| Microsoft Azure Data Lake Storage | ✓ | |||
| Microsoft Azure File Storage | ✓ | |||
| Microsoft Azure SQL Database | ✓ | ✓ | ||
| Microsoft Azure Synapse Analytics | ✓ | ✓ | ||
| Microsoft SQL Server | ✓ | ✓ | SQL pushback isn't supported when Active Directory is enabled. | |
| Connector | Read Only | Read & Write | SQL Pushback | Notes |
| MongoDB | ✓ | |||
| MySQL | ✓ | |||
| Netezza Performance Server | ✓ | ✓ | ||
| OData | ✓ | |||
| Oracle | ✓ | ✓ | ||
| 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 | ✓ | |||
| Vertica | ✓ |
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 | ✓ |