ODBC Connector 24.2

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

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

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: IDOL ODBC Connector 24.2

Topic Title: Retrieve Information (Incremental Mode)