I am parsing an XML and writing the header-content into a table. When inserted to database the inserted row (always 1 row) will be assigned a primary key. The same XML contains a number elements that are written to a separate table in the same database. The two tables are connected by former database-assigned key.
How do I add the database-assigned key to the features before writing to the second table?
Can I handle it in FME?
I tried using a SQLexecutor, but performing a call to get the key seems like a bad idea.
Do I have to go to T-SQL and write to both tables in a single SQLexecutor?
Best answer by markatsafe
View original