Alteryx Analytics

Technical Specifications

System Requirements

Installation Machine Requirements OS Requirements Chip Processor RAM Disk Size
Desktop
Minimum:
32-bit
Microsoft Windows 7
or later (32-bit)
Dual Core   4G RAM 500GB - 1TB
Recommended:
64-bit
Microsoft Windows 7
or later (64-bit)
Quad core I7
(single chip)
3GHz or faster 8G RAM 500GB - 1TB
High Performance:
64-bit
Microsoft Windows 7
or later (64-bit)
Quad core I7
(single chip)
3GHz or faster 16G RAM 500GB - 1TB
Server 32-bit not supported
Recommended:
64-bit
Microsoft Windows
Server 2008R2 or later
Quad core I7
(single chip)
3GHz or faster 8G RAM >1 Terabyte
High Performance:
64-bit
Microsoft Windows
Server 2008R2 or later
with current
service pack (64-bit)
Quad core I7
(single chip)
3GHz or faster 16G RAM >1 Terabyte

 

^Top

 

Supported Formats

Technology Configurations

Data Options

 

Data Sources

Please see the Alteryx Help within the product or visit the on-line Help documentation for more information on the specific credentials required to use the tools and macros listed below.

 

Vendor Data Sources Supported Versions of Data Sources Access from Alteryx Details
Alteryx Alteryx Database file All versions File Formatted as .yxdb
Can hold spatial objects in addition to data fields and values.
There is no record limit.
  Alteryx Calgary Database file All versions File Formatted as .cydb
  Alteryx Spatial Zip file All versions File Formatted as .sz (Alteryx Streetware Reference Map layer)
  Alteryx Web -- File Formatted as .vlmn
Amazon Amazon Redshift Released in 2014 DB connection The ODBC driver can be downloaded from Amazon Redshift and will require an account for AWS.
Tested with version 09.02.01.00.
  Amazon S3 -- Tool Requires an AWS account and credentials.
ASCII ASCII -- File Formatted as .asc, .flat
Apache Hadoop Apache Avro -- File Formatted as .avro
  Hadoop Distributed File System -- Tool Formatted as .csv, .avro
  Hadoop Hive 0.7.1 and later DB connection The ODBC driver is installed with Alteryx.
Read-only support to Hive Server 1 and Hive Server 2 is available.
Autodesk Autodesk -- File Formatted as .sdf
Install the Autodesk tool kit.
Cloudera Cloudera Impala 1.1.1 and later DB connection The ODBC driver is installed with Alteryx. Certified with CDH5.
  Hadoop Hive 0.7.1 and later DB connection The ODBC driver is installed with Alteryx.
Read-only support to Hive Server 1 and Hive Server 2 is available.
Certified with CDH5.
CSV Comma Separated Value -- File Formatted as .csv
DataSift DataSift Released in 2014 Macro Register and obtain credentials from DataSift.
First time users get $10 credit.
dBase dBase -- File Formatted as .dbf
ESRI Esri File GeoDatabase 10.0 and later DB connection The driver is installed with Alteryx.
Formatted as .gdb
Read-only support is available.
  Esri Personal GeoDatabase -- File Formatted as .mdb
  Esri Shapefile -- File Formatted as .shp, .dbf, .shx, .prj
Foursquare Foursquare No version (Venue) Macro Register and obtain credentials from Foursquare.
GeoJSON GeoJSON -- File Formatted as .gjsn
GIS GIS -- File Formatted as .grd, .grc (Grid and Classified Grid)
Google Google Analytics Released in 2014 Macro Create a Google Analytics account and obtain credentials.
  Google BigQuery Released in 2014 DB connection Create a Google account and obtain credentials.
  Google Earth/Maps -- File Formatted as .kml
KML multi-geometry elements are not supported.
Hortonworks Hadoop Hive 0.7.1 and later DB connection The ODBC driver is installed with Alteryx.
Read-only support to Hive Server 1 and Hive Server 2 is available.
Certified with HDP 2.1
HP HP Vertica 6.1.3 and later DB connection The ODBC driver can be downloaded from HP Vertica.
Tested with version 6.1.3.
IBM IBM DB2 9.5.0 and later DB connection The ODBC or OleDB driver can be downloaded from IBM DB2.
Tested with versions 9.01.301.314 and 9.5.0.808.
  IBM Netezza/Pure Data Systems 4, 4.5, 7.0 DB connection The ODBC or OleDB driver can be downloaded from IBM Netezza.
Tested with versions versions 4.05.00.7623 and 4.05.0.7443.
  IBM SPSS All versions File Formatted as .sav
MapInfo MapInfo Professional Interchange Format -- File Formatted as .mid, .mif
  MapInfo Professional Table -- File Formatted as .tab, .dat, .map, .id, .ind
MapR Hadoop Hive 0.7.1 and later DB connection The ODBC driver is installed with Alteryx.
Read-only support to Hive Server 1 and Hive Server 2 is available.
Compatible with MapR-FS for MapR versions 2.1-3.1.
Marketo Marketo 2.2 and later Tool Register and obtain credentials from Marketo.
Microsoft Microsoft Access 2000-2003 2000-2003 File Formatted as .mdb
  Microsoft Excel 1997-2003 1997-2003 File Formatted as .xls
  Microsoft Office Access 2007, 2010, 2013 File Formatted as .accdb
This driver is installed with Microsoft Office.
If Microsoft Office is not installed on your machine you may download and install the driver only from Access Database Engine.
  Microsoft Office Excel 2007, 2010, 2013 File Formatted as .xlsx
Microsoft Office or Access Database Engine is required if you are not using the "New Microsoft Excel Beta" option.
  Microsoft Sharepoint 2010 and later Tool Register and obtain credentials from Microsoft Sharepoint.
  Microsoft MySQL 5.1 and later DB connection The ODBC or OleDB driver can be downloaded from Microsoft MySQL.
Tested with version 5.01.12.00.
  Microsoft SQL Server 2005 9.0 DB connection The native client for ODBC or OleDB drivers can be downloaded from Microsoft SQL Server.
  Microsoft SQL Server 2008 10.0 DB connection The native client for ODBC or OleDB drivers can be downloaded from Microsoft SQL Server.
  Microsoft SQL Server 2012 11.0 DB connection The native client for ODBC or OleDB drivers be downloaded from Microsoft SQL Server.
  Microsoft SQL Server 2014 12.0 DB connection The native client for ODBC or OleDB drivers can be downloaded from Microsoft SQL Server.
MongoDB MongoDB 2.4, 2.6 Tool Download and register for credentials from MongoDB.
OpenGIS Geography Markup Language -- File Formatted as .gml
Oracle Oracle 10g, 11g, 12c DB connection The ODBC or OleDB driver can be downloaded from Oracle.
Tested with driver versions 10.02.00.03, 10.02.00.01, and 11.02.00.01.
Pivotal Pivotal Greenplum 8.2.15 DB connection The ODBC driver can be downloaded from PostgreSQL.
Tested with driver version 09.02.01.00.
PostgreSQL PostgreSQL 8.4 DB connection The ODBC driver can be downloaded from PostgreSQL.
Qlik QlikView
QlikSense
All versions (Tested with 11.0) File Formatted as .qvx
Output-only support is available.
Salesforce.com Salesforce Built against 26.0 Tool Establish remote access on Salesforce and obtain credentials.
SAP Sybase Adaptive Server Enterprise 15.0.2 DB connection The ODBC or OleDB driver can be downloaded from Sybase.
Tested with driver version 15.00.00.152.
  Sybase SQL Anywhere 10 10.0.1 DB connection The ODBC or OleDB driver can be downloaded from Sybase.
Tested with driver version 10.00.01.3619.
SAS SAS 7.0-9.4 File Formatted as .sas7bdat
SQLite SQLite 3.76.12 and later File Formatted as .sqlite
SRC Geography SRC Geography file -- File Formatted as .geo
Tableau Tableau Data Extract 7.0 and later File Formatted as .tde
Teradata Teradata 13.0, 14.0, 14.1 DB connection The relevant ODBC driver can be downloaded from Teradata.
  Teradata Aster 5.0, 6.0 DB Connection --
Twitter Twitter 1.1 Macro Register and obtain credentials from Twitter.
Supports retrieving data from the past 7 days.
  Twitter Gnip Search API Macro Register and obtain credentials from Gnip.
Supports retrieving Twitter data from the past 30 days.
XML XML -- File Formatted as .xml

 

^Top

 

Reporting formats

  • PNG ­ Portable Network Graphics
  • HTML - Hyper Text Markup Language
  • PCXML - Alteryx Markup Language
  • PDF - Adobe® Portable Document Format
  • RTF - Rich Text Format
  • DOC/DOCX - Microsoft Word
  • XLS/XLSX - Microsoft Excel
  • PPT/PPTX - Microsoft PowerPoint

^Top

 

Alteryx Technology Configurations


 

Alteryx APIs

The Alteryx APIs are now a standard component of the standard Alteryx install. Component APIs of the Alteryx engine server offering are also available for individual licensing, as listed below:

  • Alteryx engine - Alteryx functionality, including all of the components listed below
  • Drivetime - Drivetime calculation engine and supporting spatial data
  • Geocoder - Open source geocoder that assigns lat/long to address information
  • Allocate - Organizes and retrieves data using spatial objects
  • Calgary - Creates high-performance indexing and searchable lists of data
  • Profiler - Using standard segmentation products, profile your customers for any level of geography from household to neighborhood to custom trade areas and drivetimes

Alteryx SDK

The Alteryx Software Development Kit (SDK) allows developers to easily add their own C and C++ programs to the Alteryx toolbox.

^Top

 

Data Options


 

Alteryx Analytics Data Sets

To make the best most informed business decisions, you need access to all relevant data at your fingertips. Alteryx Analytics enables you to make decisions with real-world context. Combine our data with your local, corporate and cloud-based sources to get everything you need to improve your organization’s strategic decision making.

Trusted Partnerships, Trusted Data

Partnerships with leading data providers enable more effective analytics for critical decisions such as where to build new retail locations or distribution centers, or estimate the effectiveness of targeted promotions from the national down to the household level.

High-resolution satellite images from DigitalGlobe with street overlays provide a spatial frame of reference for decision makers.
More than 125 million global business records, which have been enhanced by D&B’s proprietary DUNSRight® Quality Process, to provide the highest-quality information on businesses worldwide.
Lifestyle, attitude, brand preference, and media use data as well as five-year projections, so you can accurately estimate customer demand today, tomorrow, and in the long term. Also includes the largest and most comprehensive source for data on more 113 million households and 235 million consumers.
Visual presentation of over 50 layers of cartographic data (including roads, highways, parks, etc.) enables you to incorporate spatial data for more accurate analytic results.
More than 3,000 population characteristics, such as racial and ethnic information as well as family, household, and housing unit details to identify market potential and trends.

^Top

Try Alteryx Designer for Free Download Now