Write Documents to Disk as SQL INSERT Statements
The SqlWriter
task writes document metadata and content to a file in the form of SQL “INSERT” statements. You can use the SQL to insert the data from the documents into a database.
The task always writes the document reference (DREREFERENCE
) and content (DRECONTENT
) fields, and you can choose the other fields that you want to include. The task writes one INSERT statement for each document that is processed.
The SqlWriter
task can be configured as a Pre, Post, Update or Delete task.
To configure the task, specify the name of a section that contains the settings, for example:
[ImportTasks] Post0=SqlWriter:SqlWriting [SqlWriting] SqlWriterFileName=MyTask.sql SqlWriterTableName=table SqlWriterDreReferenceColumnName=REFERENCE SqlWriterDreContentColumnName=CONTENT SqlWriterFieldNames0=MODIFIED_DATE SqlWriterColumnNames0=DATE SqlWriterDataTypes0=DATE_TIME SqlWriterUseNullForMissingFields=true SqlWriterDateFormats0=DD/MM/YYYY SqlWriterDateFormats1=YYYY/MM/DD SqlWriterMaxSizeKBs=1024 SqlWriterArchiveDirectory=./SQLarchive
For information about the parameters that you can use to configure this task, refer to the Connector Framework Server Reference.