Thursday, 31 March 2016

Alteryx Engine

  • The Alteryx Engine, which is written in C++, executes the workflows that are built in the Alteryx Designer and produces the output. 
  • The Engine supports direct connections to various data sources for accessing the data and then processes it in-memory during the execution of the workflow.
  • Processing that exceeds memory limitations is written to temp files on disk, which are deleted once the processing is complete. 
  • The Engine can be entirely self-contained in an Alteryx Designer deployment, scaled across an organization via the Alteryx Server, or deployed in the cloud via the Alteryx Analytics Gallery.
Depending on the workflow and process, the Alteryx Engine may:              
 1.Read or write to input/output files.
 2.Read or write to one or more databases.
 3.Upload or download data from the web.
 4.Submit email to an email server through SMTP protocols.
 5.Execute external runtime commands.

  • The Alteryx Engine seamlessly integrates with R. When users choose to install the suite of R-based tools and macros used for predictive analysis, Alteryx also installs the R program and the additional packages that provide connectivity between Alteryx and R and are required for the tools and macros to work. 
  • Users can use R scripts or the R-based macros to process data directly within a workflow. 
  • When the workflow is run, the Alteryx Engine communicates with the R engine via a command line executable to process and send back the data.


  • Developers can write applications that call directly into the Alteryx Engine using the Application Programming Interfaces (APIs) and the Alteryx Software Development Kit (SDK) gives developers an easy way to add their own programs to the Alteryx toolbox.
  • Both the Alteryx API and SDK are available with an Alteryx Server deployment.
  • Whether the Alteryx Engine is running on the desktop, through the API, or via the Alteryx Service, workflows may leverage tools that communicate with databases, output files,web services, email servers, or run commands.
Thanks Guru's,
Prazval.ks




DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks