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