Toolkit for Alteryx
White circuit Node

Teknion Toolkit for Alteryx

Seven (7) Tools - One (1) Download

We have packaged a set of seven (7) tools together designed to streamline and automate the process of building out Alteryx workflows, removing manual steps and enabling faster, more accurate work.

Download Toolkit 

XML

Complex XML Input Tool

  • Input tool which reads an XML file
  • Parses the entire schema as key value pairs
  • Derives key from the current depth and iteration within the XML tree
  • Capable of outputting the XML schema keys with information regarding its parent and type

SQL

SQL Input Tool

  • Functions as an input, blocking input or a batch tool
  • Executes non-query SQL commands:
    • UPDATE
    • INSERT
    • DELETE
  • Optionally executes queries following non-query executions, returning execution statistics
  • Pass both DSN & Command in batch mode to enable sequenced execution against multiple databases
File System Tool

File System Tool

  • Functions as an input, blocking input, or batch tool
  • Enables file system functions such as:
    • LIST
    • MOVE
    • COPY
    • REMOVE
    • COMPRESS
    • DECOMPRESS
  • Also works with network UNC paths using network credentials

Terminator Tool

Functions as a gate keeper to prevent a process from executing until a minimum amount of input records are present.

  • Prevents records from being passed to an output until a minimum amount of input records are present.  
  • As soon as the minimum amount of input records are present, all records are released and proceed to the output as designed.
  • If all of the records have been received but the minimum number of input records has not been met, the output is not initialized and no downstream tools are executed. 
REST

REST w/ Certificate Tool

  • Functions as a transformation tool which takes URL, headers and JSON payload (for POST) on the input data stream
  • Enables access to API’s which require a p12 certificate for authentication


 

sFTP RSA

sFTP w/ RSA Tool

  • Functions as an input, blocking input or a batch tool
  • Enables sFTP functions with the option of using an RSA token for authentication
  • sFTP functions include:
    • LIST
    • UPLOAD
    • DOWNLOAD
    • REMOVE


S3 Objects

AWS S3 Objects Tool

  • Functions as an input, blocking input or a batch tool
  • Enables access to S3 buckets via IAM credentials
  • S3 Object functions include:
    • LIST
    • UPLOAD
    • DOWNLOAD
    • COPY
    • MOVE