Databases like Microsoft Access use auto-increment columns to provide for unique record identifiers. This is in contrast to databases like Oracle which maintain a separate facility for sequences (ROWID aside). When working with Talend, don't map a value to the column, otherwise a database error will the thrown.
(This takes the form of a "General error" referencing the ODBC driver if a tAccessOutput component is used.)
The metadata functions in Talend like the "Retrieve schema" button will include auto-increment columns. For example
|Generated from Retrieve Schema|
- Abandon it. In the TOS User Guide, the schema used in the tMysqlOutput component sample is created by hand in a tMap. Connect the the tMap and press the Reset DB Types on the Edit Schema dialog.
- Tweak the Repository. Drag the Repository's definition on the canvas. Change to a Built-in and remove the auto-increment column.
- Build the schema in the tMysqlOutput component. The opposite of the "Abandon it" where the schema is pushed backwards onto a tMap.
|Access Output with Built-in Schema|
|Schema without Auto-Increment Column|