âShow Table of Contents
The Output Data tool is used to write the results of an analysis to a database or file format.
See Supported Databases and Supported File Formats for the list of databases and file formats supported by Alteryx.
Drag an Output Data tool from the Tool Palette onto the workflow canvas.
Select the tool and use the Configuration window on the left to configure it in one of the following ways:
Point to a data file
Alteryx will write a data file to a local or network directory. You can type the file's path or browse to its location. The configuration properties will vary depending on the file format type chosen.
To write a file:
Either type a file path in the Connect a File or Database field or click the drop-down to see a list of available connection methods:
- File Browse: Opens a dialog box for browsing to the file location.
- Database Connection: Shows options for connecting to a database using various driver connections.
- Recent Files: Includes the last ten input and output files that have been accessed.Connect to a database
Alteryx will connect to supported database formats and write requested data.
To connect to a database:
Click the Write to File or Database drop-down.
Select one of the following options:
- Database Connection or 32-Bit Data Base Connection Connections are organized by connection method type. You will be able to specify a new connection or access a connection you have already set up. The following new connections can be made:
Alias: Users can give their connections an alias for easier access to their data and can manage the Alias Repository which allows users to manage multiple database connections and passwords from a single location.
Established Connection: Alteryx will maintain a history of your database connections. If you have already set up a connection to a database, it will appear in this list.
Note: When connecting to any OLEDB or ODBC database, be sure to use the native driver provided by the database vendor.
The Choose Table or Specify Query window opens if the database has multiple tables to allow the user to easily select tables and construct queries. For more information see the Choose Table or Specify Query page.
Note: To connect to a database for in-database processing, refer to the In-Database tools.Connect to HDFS
Alteryx will connect to a Hadoop Distributed File System and read *.csv and *.avro files. All Hadoop distributions implementing the HDFS standard are supported.
HDFS can be read two ways, using httpfs (port 14000) or webhdfs (port 50070). Please consult with your Hadoop administrator for which to use. If you have a Hadoop High Availability (HA) cluster, your Hadoop admin must explicitly enable httpfs.
Note: MapR may not support webhdfs.
To connect to HDFS:
- Click the Connect a File or Database drop-down.
- Click HDFS Connection and then New HDFS Connection.
- Enter the HDFS Connection information:
- Hostname: Specify the installed instance of the Hadoop server. The entry must be a URL or IP address.
- Port Number: The port number for httpfs (14000) or webhdfs (50070).
- httpfs: The user name is not needed.
- webhdfs: A user name is needed, but it can be anything.
- Click OK.
- Select a method for accessing the file. Options include:
- File: Specify the path of the file. The entry must be a path:
- Browse: Browse to the file and select it.
- Select the File Format of Avro or CSV and click OK.
Note: For more information see Avro data types.
Note: To connect to HDFS for in-database processing, refer to the In-Database tools.
Depending on the file format type or database connection, the configuration and output options will vary. Additional options include the following:
Take File Name From Field: When this box is checked, a separate file will be written out for each value of a particular field. Additionally you can chose to:
Append Suffix to File/Table Name: Appends the value of the selected field name to the end of the specified table name.
Prepend Prefix to File/Table Name: Prepends the value of the selected field name to the beginning of the specified table name.
Change File Name: Changes the file name to the value of the selected field name.
Change Entire File Path: Changes to the file name to what is in the field name. The field name MUST contain a full path, otherwise you will receive an error similar to: â Output (8): Open() failed for : invalid filename extension
Note: This option could potentially overwrite an existing file, if one exists in the full path directory.
Note: For best performance and data integrity, it is recommended that all inputs and outputs in an active Alteryx workflow not be open elsewhere.
Click Apply to have the configurations accepted.