[en] Esri

[en] Type of Support

[en] Read and write

[en] Alteryx Tools Used to Connect

[en] Link

[en] Link

[en] Read records into Designer from a FileGeodatabase (.gdb).

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

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

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

[en] Projection: WGS 84 is the default.

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

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

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

[en] Compression and custom projections are NOT supported.