Accessing Data

Use different types of data from any source

Home 5 Products 5 Information 5 Accessing data

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

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)
  • URL

Hadoop Big Data

Accessing data with Workflows

Build workflows with drag-and-drop blocks to access data


  • 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

Have a question?

Get in touch with our sales team

Try or buy

Standard Edition
Academic Edition
Community Edition