Esri

Version:
2023.1
Last modified: May 17, 2023
Type of Support

Read and write

Alteryx Tools Used to Connect

Standard Workflow Processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

Additional Details

Read

Read records into Designer from a FileGeodatabase (.gdb).

Data Types

FileGeodatabase Designer
fieldTypeSmallInteger Int16
fieldTypeInteger Int32
fieldTypeOID Int32
fieldTypeSingle Float
fieldTypeDouble Double
fieldTypeDate DateTime
fieldTypeGeometry SpatialObj
fieldTypeBlob Blob
fieldTypeString WString if less than 256, otherwise V_WString.
fieldTypeGUID WString if less than 256, otherwise V_WString.
fieldTypeGlobalID WString if less than 256, otherwise V_WString.
fieldTypeXML V_String
Write

Write records from Designer into a Feature Class or a table in a FileGeodatabase (.gdb).

Output Options

  • Overwrite DB (Drop): Drops an existing database, creates a new database and table, and inserts records.
  • Append Existing: Inserts records into an existing table.
  • Delete Data and Append: Truncates existing table and inserts records.
  • Overwrite Table (Drop): Drops an existing table, creates a new table, and inserts records.
  • Create New Table: Adds a new table to an existing database.
  • Update: Warn on Update Failure: Updates an existing record based on an Object ID and throws a warning when the UPDATE fails.
  • Update: Error on Update Failure: Updates an existing record based on an Object ID and throws an error when the UPDATE fails.
  • Update: Insert if New: Updates an existing record based on an Object ID, or inserts if it's a new record.

Projection: WGS 84 is the default.

OID Field: Accepts Byte, Int16, and Int32 Alteryx data types, and stores it as a fieldTypeOID.

Data Types: Data from Designer convert to these types in .gdb files:

Designer FileGeodatabase
Bool Unsupported
Int16 fieldTypeSmallInteger
Int32 fieldTypeInteger
Int64 Unsupported
FixedDecimal fieldTypeDouble
Float fieldTypeSingle
Double fieldTypeDouble
String fieldTypeString
WString fieldTypeString
V_String fieldTypeString
V_WString fieldTypeString
Date Unsupported: Use DateTime instead.
Time Unsupported: Use DateTime instead.
Time Unsupported: Use DateTime instead.
DateTime fieldTypeDate
Blob fieldTypeBlob
SpatialObj fieldTypeGeometry (limited to one field per table, and one type per field).

Limitations

Compression and custom projections are NOT supported.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.