Alteryx Analytics

Input and Output Tools

Data can be stored in a number of locations such as on a local desktop, in a relational database, in the cloud, or third-party systems. Alteryx Analytics allows users to access and deliver data from and to a wide variety of formats and sources. Listed below are examples of the types of tools available in Alteryx Analytics for inputting and outputting data.

This is a sample of the tools available in the Alteryx Designer. For the full list of tools, click here.

Icon Tool Description
Browse Browse Add one or more points in your data stream to review and verify your data.
Date Time Now Date Time Now Input the current date and time at module runtime, in a format of the user's choosing. (Useful for adding a date-time header to a report.)
Directory Directory Input a list of file names and attributes from a specified directory.
Input Input Bring data into your module by selecting a file or connecting to a database (optionally, using a query).
Map Input Map Input Manually draw or select map objects (points, lines, and polygons) to be stored in the module.
Output Output Output the contents of a data stream to a file or database.
Text Input Text Input Manually add data which will be stored in the module.
XDF Input XDF Input This tool enables access to an XDF format file (the format used by Revolution R Enterprise's RevoScaleR system to scale predictive analytics to millions of records) for either: (1) using the XDF file as input to a predictive analytics tool or (2) reading the file into an Alteryx data stream for further data hygiene or blending activities.
XDF Output XDF Output This tool reads an Alteryx data stream into an XDF format file, the file format used by Revolution R Enterprise's RevoScaleR system to scale predictive analytics to millions of records. By default, the new XDF files is stored as a temporary file, with the option of writing it to disk as a permanent file, which can be accessed in Alteryx using the XDF Input tool.
Dynamic Input In-DB Dynamic Input In-DB Use a Dynamic Input In-DB tool when creating an In-DB macro for predictive analysis.
Dynamic Output In-DB Dynamic Output In-DB Use a Dynamic Output In-DB tool to output information about the In-DB workflow to a standard workflow for Predictive In-DB.
API Output API Output Return the results of a data stream directly to an API callback function. For use with custom application development.
Adobe Analytics Adobe Analytics Access data from Adobe Analytics generate ad hoc reports based on multiple parameters via the Adobe Analytic connection.
Foursquare Foursquare Search Foursquare Venues by a location with an option of filtering by a search term.
Twitter Search Twitter Search Search tweets of the last 7 days by given search terms with location and user relationship as optional properties.
Amazon S3 Download Amazon S3 Download Read CSV, DBF and YXDB files from Amazon S3.
Amazon S3 Upload Amazon S3 Upload Write CSV, DBF and YXDB files to Amazon S3.
Download Download Retrieve data from a specified URL, including an FTP site, for use in a data stream.
Google Analytics Google Analytics Bring in data from Google Analytics
Marketo Input Marketo Input

The Marketo Input Tool reads Marketo records for a specified date range. Two types of Marketo records can be retrieved:

  • LeadRecord: These are lead records and there will be one record for each lead.
  • ChangeRecord: These records track the activities for each lead. There are potentially many ChangeRecord Records for each LeadRecord
The Input Tool retrieves records in batches of 1000 records, where the Marketo Append tool makes an API request for each record
Marketo Append Marketo Append The Marketo Append tool retrieves Marketo records and appends them to the records of an incoming data stream. Two types of Marketo records can be retrieved:
  • LeadRecord: These are lead records and there will be one record for each lead.
  • ActivityRecord: These records track the activities for each lead. There can be many ActivityRecord records for each LeadRecord.
Both of these record types are retrieved by specifying a LeadKey, which must be supplied by an upstream tool. More information on LeadKeys can be found in the Append Tab section under Configuration Properties.
Marketo Output Marketo Output The Marketo Output tool calls to the Marketo API function: syncLead(). Data is written back to Marketo using an 'Upsert' operation. This means if a record doesn't currently exist, it will be created (see 'Inserts' below). If a record currently exists, it will be updated.
MongoDB Input MongoDB Input Read and query data from a MongoDB database. MongoDB is a scalable, high-performance, open source NoSQL database.
MongoDB Input MongoDB Output Write data to a MongoDB database. MongoDB is a scalable, high-performance, open source NoSQL database.
Salesforce Input Salesforce Input Read and query data from Salesforce.com.
Salesforce Output Salesforce Output Write data to Salesforce.com.
SharePoint List Input SharePoint List Input Read a list from SharePoint.
SharePoint List Output SharePoint List Output Write data to a list in SharePoint.
Browse Data In-DB Browse Data In-DB Review your data at any point in an In-DB workflow. Note: Each In-DB Browse triggers a database query and can impact performance.
Connect In-DB Connect In-DB Establish a database connection for an In-DB workflow
Data Stream In Data Stream In Bring data from a standard workflow into an In-DB workflow.
Data Stream Out Data Stream Out Stream data from an In-DB workflow to a standard workflow, with an option to sort the records.
Write In-DB Write In-DB Use an In-DB data stream to create or update a table directly in the database.

^Top

Try Alteryx Designer for Free Download Now