ESRI

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

Data Types:

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: