In-Database Processing

Finally, intuitive data preparation without sacrificing in-database processing power.

Visual Data Preparation Meets In-Database Performance

Preparing the largest data sets means utilizing every ounce of your database’s native intelligence. Alteryx automatically creates native database-specific queries that apply filters, formulas and more to your database investments to maximize preparation performance—without requiring coding or specific expertise. Finally, intuitive data preparation without sacrificing in-database processing power.

In-Database Blending for Big Data Preparation


Data Preparation at Scale

Analyzing customers, inventory, transactions, or sales data, is better, in-place. In-database processing for data preparation enables you to prepare more data—and cut the time coding or waiting for processing.

  • Work with large data sets easily – Apply more of the data preparation processing at the database level to create efficient extracts
  • Code-less scalability – Built-in database intelligence creates queries that take advantage of your database functionality without requiring hand-coded queries to scale up
  • Blend in-database processing into broader workflows – Easily apply in-database processing, and flow the results into downstream workflows and analysis


Native Processing Across Your Database Assets

Alteryx pushes down data preparation queries to a broad range of relational, columnar, NoSQL and Hadoop databases, so you can combine preparation speed with database power across your landscape.

  • Comprehensive support – Amazon Redshift, Apache Hive, Cloudera Impala, Microsoft (Azure SQL Data Warehouse, SQL Database, SQL Server), SAP HANA, IBM Netezza, Teradata, Spark, Oracle and more
  • In-database processing logic – Select, Filter, Formula, and Summarize operations enable maximum data preparation processing where the data lies
  • Stream in additional data – Visual Stream, Join and Union in-DB tools make it simple to import and join external data, all in-database


Scale Up Data Preparation With In-Database Processing

Getting the most out of your databases native power needn’t require hand-crafted SQL, HQL, or other technical database queries―so more of your analysts can confidently prepare bigger datasets.

  • Empower analysts and business users – Visual in-database tools enable analysts to work with large datasets, without requiring IT or technical staff
  • Drag and drop ease of use – Create workflows that use in-database processing via Alteryx Designer’s intuitive, drag-and-drop environment
  • Complete visually compose queries – Complete suite of intuitive, visual components instantly turn clicks into native, optimized database queries