Connector Framework Server 12.11

# SqlWriter Task Parameters

The parameters in this section customize the `SqlWriter` task.

This 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.

You can configure the `SqlWriter` task as a Pre, Post, Update or Delete task.

To configure the task, specify the name of a section that contains the task 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

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.11 | Last updated February 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL Connector Framework Server 12.11

Topic Title: SqlWriter Task Parameters