Locations & Analytics 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  Robin
Locations & Analytics Practice

Contact Practice Director

Robin Bevan

Director, Locations & Analytics

Robin Bevan runs our Locations & Analytics practice. He has over 25 years’ experience in retail property, including location strategies for retailers, geographic channel strategies for brands, shopping centre strategies for developers and owners, due diligence for private equity investors and commercial space planning for travel hub operators, and has wide international experience, having worked in 20 countries. Robin also leads our Ignite m-commerce initiative, which brings digital into the heart of the physical environment (e.g. shops, shopping centres, travel hubs). A PPE graduate from Oxford University, Robin contributed recently as part of the industry taskforce which published the influential Beyond Retail report for central government.