...
The following table describes the parameters of the database extractor configuration.
| Field | Description |
|---|---|
url | url for the database. |
username | Username for the database credentials. |
password | From v0.3, password can be either plaintext or encrypted. In earlier versions, password must be encrypted. download the jasypt command line utility to encrypt (link) - use "infinit.e" as the "password" (actually the salt). |
databaseType | The type of RDBMS to connect to. Valid values currently include: mysql, db2, oracle, mssqlserver, sybase. |
hostanme | The hostname of the database server to connect to, i.e. "my.databaseserver.com" in the example above. |
port | The port that the database accepts incoming connections on. |
databaseName | The name of the database to connect to. |
query | The query field is used to specify the SQL used to perform a full extraction of data for the source. This is generally used the first time the harvester extracts data from a source with incremental extractions being specified using the deltaQuery below. |
deltaQuery | The deltaQuery field is used to specify the SQL that extracts data from the source RDBS based on one or more delta values, i.e. created or modified date for a record. |
deleteQuery | Note: The deleteQuery functionality of the Database Harvester is not implemented in the Beta version of Infinit.e. |
primaryKey | Primary key field in data set, used to help identify whether a record is new or previously harvested. |
primaryKeyValue | Primary key value, only used when placing in the feed record. |
title | Record field used to populate the document's title field. |
snippet | Record field used to populate the document's description field. |
publishedDate | Record field used to populate the document's published date field. |
...