Retail Analytics & Data Insights Practice

Alteryx Technical Specifications

alteryx_tech_specSupported File Formats

  • Flat Files ASCII
  • CSV – Comma Separated Value
  • MDB/ACCDB – Microsoft® Access database
  • DBF – dBASE Database File format
  • XLS/XLSX – Microsoft Excel® spreadsheet
  • HTM/HTML/XML – Hyper Text/Extensible Markup Language
  • QVX – QlikView data eXchange
  • SAV – IBM SPSS file format
  • SAS7BDAT – SAS binary file format
  • TDE- Tableau
  • Relational Database Files ODBC – Open Database Connectivity
  • OLE-DB – Object Linking and Embedding Database
  • OCI – Oracle® Spatial Database
  • Spatial Files GRD/GRC – Grid and Classified Grid
  • KML – Google Keyhole Markup Language
  • MDB/PGDB – ESRI Personal Geodatabase®
  • MID/MIF – MapInfo Professional® Interchange Format
  • SDF – Autodesk® Spatial Data Files
  • SHP – ESRI® ArcMap® Shape (includes *.SHP,*.DBF, *.SHX,*.PRJ)
  • SZ – Alteryx Spatial Zip
  • TAB – MapInfo Professional Table (includes *.TAB, *.DAT, *.MAP, *.ID, *.IND)
  • YXDB – Alteryx database

Supported Databases

  • Apache Hive (read only support)
  • Amazon Redshift
  • Amazon S3 **
  • Cassandra ***
  • Cloudera Impala
  • ESRI GeoDatabase – ­(read only support)*
  • Hortonworks
  • HP Vertica **
  • IBM DB2
  • IBM Netezza® *
  • Microsoft SQL Server® *
  • MongoDB
  • MySQL®
  • Oracle *
  • Pivotal Greenplum Database
  • SQLite
  • Sybase®
  • Teradata and SQL server **
  • Teradata®

* includes support for vendor-specific spatial functionality
** now include bulk load support
***ODBC Driver Available upon Request

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
Contact  Carl
Retail Analytics & Data Insights Practice

Contact Practice Director

Carl Bradbrook

Associate Director, Retail Analytics & Data Insights

Carl Bradbrook is an Associate Director at Javelin Group. He leads the Retail Analytics & Data Insights practice and manages key partner relationships.  Carl has experience across a wide range of industry sectors, helping organisations with their site location strategy, analytics and data visualisation.