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 *

  • DB2
  • Oracle
  • MySQL
  • PostgreSQL
  • SQL Server

Data files *

  • CSV
  • 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

Have a question?

Have a question?

Get in touch with our sales team

WPS Try or Buy

Try or buy

  • Standard Edition
  • Academic Edition
  • Community Edition