Start the Connector

After you have configured the connector and your 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 connector.
  3. To verify that the data has been extracted successfully, open the file database_records.idx (in the CFS installation folder). The customer 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
    
    #DREENDDOC

    NOTE: The main template and the sub-table template have been combined and used to generate a single document, with data from both tables.