ODBC Connector 23.3

# Start the Connector

After you have configured the connector and the template files, you can start the connector, and verify that the data is extracted successfully.

To start the connector

1. In the ODBC Connector installation folder, delete the file `connector_EXAMPLEDATABASE_datastore.db`. Deleting this file resets the connector so it retrieves the same data again (the data in the database has not changed).
2. Start the ODBC Connector.

3. To verify that the data has been extracted successfully, open the file `database_records.idx`, in the CFS installation folder. The new information should now be included in the document, for example:

       #DREREFERENCE 012345
       #DREFIELD OrderDate="16/10/2012 15:27:11"
       #DREFIELD Customer="2563"
       #DREFIELD Status="Order complete"
       #DRECONTENT
       Order information
       Date Received: 16/10/2012 15:27:11
       Status: Order complete

       Customer information
       Name: Mr. John Smith
       Address: 1234 North Road, Cambridge, POST1234

       Items
       ITEM 5001, Item 5001 description, QTY 1, £399
       ITEM 5002, Item 5002 description, QTY 1, £29

       #DREENDDOC

   NOTE: The main template and the two sub-table templates (for customer information and item information) have been combined and used to generate a single document.

   In this example, the Item Details query has also returned two rows from the combined `Items` and `Products` tables.

Copyright 2023 Open Text
Version 23.3 | Last updated June 2023

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 ODBC Connector 23.3

Topic Title: Start the Connector