Esri
Type of Support | Read and write |
Alteryx Tools Used to Connect
Standard Workflow Processing
Input Data Tool
Output Data Tool
Additional Details
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 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.