Esri

Version:
2019.3
Last modified: September 26, 2019
Type of Support

Read and write

Alteryx tools used to connect

Standard workflow processing

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 the following 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 Helpful?

Need something else? Visit the Alteryx Community or contact support.