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

I/O Features

  • CLIPBOARD (Windows only)
  • DDE (Windows only)
  • EMAIL (via SMTP or MAPI)
  • FTP
  • HTTP
  • PIPE (Windows and UNIX only)
  • URL

Hadoop Big Data