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

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

Actian Matrix
 DB2
 Greenplum
 Informix
 Kognitio
 MySQL
 MariaDB
 Netezza
 ODBC
OLEDB
Oracle
PostgreSQL
SAND
SQL Server
Sybase
Sybase IQ
Teradata
Vertica
 dBase Files
 Flat Files
 JSON
 Microsoft Access
 Microsoft Excel
 SAS Dataset Files
 SAS Transport Files
Sequential Files
SPSS Data Files
Tableau (write only)
VSAM Files
WPD (WPS dataset)
XML

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?

Get in touch with our sales team

Try or buy

Standard Edition
Academic Edition
Community Edition