Open topic with navigation

# Retrieve Information (Incremental Mode)

To automatically retrieve content from a database in incremental mode, create a new fetch task by following these steps. The connector runs fetch tasks automatically, based on the schedule that is configured in the configuration file.

To create a new Fetch Task

1. Stop the connector.
2. Open the configuration file in a text editor.

3. In the `[FetchTasks]` section of the configuration file, specify the number of fetch tasks using the `Number` parameter. If you are configuring the first fetch task, type `Number=1`. If one or more fetch tasks have already been configured, increase the value of the `Number` parameter by one (1). Below the `Number` parameter, specify the names of the fetch tasks, starting from zero (0). For example:

       [FetchTasks]
       Number=1
       0=MyTask

4. Below the `[FetchTasks]` section, create a new TaskName section. The name of the section must match the name of the new fetch task. For example:

       [FetchTasks]
       Number=1
       0=MyTask

       [MyTask]

1. In the new section, set the following parameters:

   `ConnectionString` | The connection string to connect to the database.
   `UseIncrementalStatements` | To use incremental mode, set this parameter to `true`.
   `InitialStatement` | The SQL query to use to return the data from the database on the first synchronize cycle.
   `AddedAndUpdatedStatement` | The SQL query to use to identify new and updated records on incremental synchronize cycles.
   `DeletedStatement` | The SQL query to use to identify deleted records on incremental synchronize cycles.
   `PrimaryKeys` | The column, or combination of columns, used as the primary key for the table. The value of this parameter is case-sensitive.
   `Template` | (Optional) The template file used to form the documents that are sent to CFS. For information about how to create a template file, see Construct Template Files.

2. Save and close the configuration file. You can now start the connector.

   TIP:

   If you make changes to the configuration and want to reset the connector so that it retrieves all of your data again, use the `PurgeDatastore` action.

© 2018 EntIT Software LLC, a Micro Focus company | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm