âShow Table of Contents
The Input Data tool brings data in to your workflow by connecting to a file or database.
Use the Input Data tool to connect to the following supported data sources:
|Alteryx Spatial Zip||.sz|
|Apache Hadoop Avro||.avro|
|Comma Separated Values||.csv|
|ESRI Personal GeoDatabase||.mdb|
|MapInfo Professional Interchange||.mid, .mif|
|MapInfo Professional Table||.tab|
|Microsoft Access 2000-2003||.mdb|
|Microsoft Excel 1997-2003||.xls|
|Microsoft Excel 2007, 2010, 2013, 2016||.xlsx|
|Microsoft Excel Macro Enabled||.xlsm|
|Microsoft Office Access 2007, 2010, 2013, 2016||.accdb|
|Hadoop Distrubted File System (HDFS)|
|Hadoop Distributed File System (HDFS)|
|DataStax||DataStax Enterprise, DataStax Community|
|Hortonworks||Hadoop Distrubted File System (HDFS)|
|IBM Netezza/Pure Data Systems|
|MapR||Hadoop Distrubted FIle System (HDFS)|
|Microsoft||Microsoft Azure SQL Data Warehouse|
|Microsoft SQL Server 2009, 2012, 2014, 2016|
|Netsuite||Netsuite Suite Analytics|
Use other tools to connect to other supported data sources. For a complete list of data sources supported in Alteryx, see Supported Data Sources.
You can also connect to a file by clicking and dragging a file on your computer to the Alteryx canvas, adding an Input Data tool connected to the file you selected.
In the file browse window, type a wildcard as part of the file path.
For example, if there are multiple data tables that have similar names in the same directory, with identical table structures, type the file name they have in common and add an " * " to substitute all subsequent characters or a " ? " to substitute one character. Remember to include the file extension that is common to all files when specifying the file names.
This path brings in every.csv file contained within the data\datafiles directory with a file name that begins with ABCD.
For example, it would bring in ABCD_4.csv and ABCD_012.csv.
This path brings in every.csv file contained within the data\datafiles directory with a file name that begins with ABCD_ + 1 character.
Find the cells you want to view in Alteryx and type them in the Connect a File or Database field.
In this example, cells A2 through B4 are input to Alteryx. Row A is treated as the data header.
You can also create a named range in Excel and then that range is an available option when you browse to the file in Alteryx.
Select <List of Sheet Names> to create an output with a single column with sheet names as values. None of the related data contained within the Excel file is output when this option is selected.
Click Microsoft SQL Server to create a new Microsoft SQL Server database connection.
Click Hadoop to create a new Hadoop database connection.
Alteryx connects to a Hadoop Distributed File System and reads .csv and .avro files. All Hadoop distributions implementing the HDFS standard are supported.
HDFS can be read using httpfs (port 14000), webhdfs (port 50070), or Knox Gateway (8443). 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.
MapR may not support webhdfs.
In the HDFS Connection window:
Self-signed certificates are not supported in Alteryx. Use a trusted certificate when configuring Knox authentication.
path/to/file.csv), or browse to the file and select it.
To connect to HDFS for in-database processing, use the Connect In-DB tool.
Point to Other Databases to create a new database connection to a database other than Microsoft, Oracle, or Hadoop.
Select the database you want to connect to:
Before you connect to a database, consider the following:
Point to an option and select a saved or shared data connection to connect it, or click Manage to view and edit connections.
See Manage Data Connections Window for more on managing saved and shared data connections and troubleshooting.
For best performance and data integrity, close inputs before you build and run a workflow.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.