Exporting Oracle BLOB to Files

More
9 years 5 months ago #10225 by flr-jj
Recently download Advanced ETL Processor Pro version 5.7.22 to see if it could help with new task.

Created a transformation that read from an Oracle database, filename and blob, transformed to File System as filename and file data to a mapped network drive (M:\Temp).

Received the error message: No Update Key Field specified

Unable to find where this is specified. Searched Forum, found one item that mentioned checking a key field box but did not find a key field box on the Reader, Transformer or Writer.

Attached are some screenshots.
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 5 months ago #10226 by admin
Can we ask you to post screenshots of data writer properties please

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 5 months ago #10227 by flr-jj
screenshots attached
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 5 months ago #10228 by admin
Download and install latest version

Than select update key as on picture attached





Mike

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.