Accessing Data
Use different types of data from any source
Use any data
WPS Analytics can connect to and use most industry-standard data sources and data files, including Hadoop big data environments, data warehouses, databases, datasets, data files and spreadsheets
Superior data handling
The SAS language support built into the WPS Processing Engine provides unbounded scalability and performance for processing large data volumes
Accessing data with Workflows
Build workflows with drag-and-drop blocks to access data
Databases*
- Amazon Redshift
- Azure SQL Data Warehouse
- DB2
- Google BigQuery
- MySQL
- ODBC
- Oracle
- PostgreSQL
- Snowflake
- SQL Server
Data Files*
- FLat Files
- Microsoft Excel
- WPD (WPS dataset)
Other data sources
- Use a code block to access more data sources
* The dedicated database and data file Workflow blocks do not need coding skills to use
SAS language
Use SAS language syntax to access many types of data
Databases and Data Warehouses
Data File Formats
I/O Features
- CLIPBOARD (Windows only)
- DDE (Windows only)
- EMAIL (via SMTP or MAPI)
- FTP
- HTTP
- PIPE (Windows and UNIX only)
- SOCKET
- STDIO
- URL
Hadoop Big Data
- Apache Hadoop, Cloudera, Hortonworks, MapR
- Dataset Support – Hive, Impala
WPS Engine for Hadoop - Language Support – HDFS, MapReduce, Pig
WPS Interop for Hadoop
Have a question?
Get in touch with our sales team
Try or buy
Standard Edition
Academic Edition
Community Edition