ESRI
| Type of Support: | Read and write |
| Supported Versions: | 10.0+ (Read), 18.3+ (Write) |
| FileGDBAPI Version: | 1.5.1 |
Alteryx tools used to connect
Input Data Tool and Output Data Tool (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.