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.
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 | ✓ |