Fusion Connectors

Version 4.1
How To
Documentation
    Learn More

      JDBC Connector Configuration Reference

      Table of Contents

      The JDBC connector fetches documents from a relational database via SQL queries. Under the hood, this connector implements the Solr DataImportHandler (DIH) plugin.

      Date field types

      Observe the date field type in the source database. Delta queries compare a date in the source database to the time of the most recent data import. The user selects a date field from their database to use for comparison (for example, a field like last_updated). The field type changes the behavior of the comparison:

      • DATE: It compares the day (for example, 2020-02-20)

      • TIMESTAMP: It compares both the day and time (for example, 2020-02-20 17:45:45)

      Note: When using a primary key other than id, remove UUIDUpdateProcessorFactory from solrconfig.xml. Also change the uniqueKey value in schema.xml to your primary key.

      Configuration

      When entering configuration values in the UI, use unescaped characters, such as \t for the tab character. When entering configuration values in the API, use escaped characters, such as \\t for the tab character.

      Loading liquid template...

      Loading configuration schema...