Connector Framework Server 25.2
Connector Framework Server Help

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

Copyright 2025 Open Text
Version 25.2 | Last updated April 2025

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 MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Connector Framework Server 25.2

Topic Title: Write Documents to Disk as SQL INSERT Statements