|
clean_in_full_import_mode
Clean in full import mode
|
Clean old records when doing a full import. This will remove all records from the index before re-indexing.
type: boolean
default value: 'true'
|
|
collection
Collection
|
Collection documents will be indexed to.
type: string
pattern: ^[a-zA-Z0-9_-]+$
|
|
commit_on_finish
Solr commit on finish
|
Set to true for a request to be sent to Solr after the last batch has been fetched to commit the documents to the index.
type: boolean
default value: 'true'
|
|
convert_type
Convert type
|
If checked, the connector will automatically convert the data from a column to the target Solr data-type. Otherwise, the connector will use the field type based on the data type of the column from the JDBC result set.
type: boolean
default value: 'true'
|
|
delta_import_query
Delta Import SQL Query
|
A SQL statement to retrieve the delta records. If not defined, the original SQL Statement will be used to retrieve delta records, which may be error prone in the case of complex statements. If that occurs, you can define a secondary SQL statement that will only be used for delta imports.
type: string
|
|
delta_sql_query
Delta SQL Query
|
A SQL statement to select the delta (records added or changed) since the last run of the datasource. For example, 'SELECT id FROM customers WHERE last_modified > $'. The $ indicates the date and time of the last import.
type: string
|
|
driver
JDBC Driver
|
The class name of the JDBC driver to use to connect to the database. Only JDBC4 drivers will appear in this list. If a JDBC3 driver has been uploaded but does not appear in the list, it may be possible to manually enter the class name.
type: string
|
|
fetch_size
JDBC fetch size
|
The number of documents to retrieve per batch.
type: integer
|
|
kerberosAuthenticationProps
Kerberos Authentication
|
Kerberos Authentication Properties
type: object
object attributes: {
}
|
|
manually_uploaded_driver
Manually Uploaded JDBC Driver
|
If you for whatever reason cannot use the blob store to upload your JDBC driver and needed to load it manually into the connectors apps/libs directory, you can specify the JDBC Driver class name here.
type: string
|
|
max_docs
Max Documents
|
The maximum number of documents to crawl. Use -1 to index all documents found.
type: integer
default value: '-1'
|
|
nested_queries
Nested queries
|
A nested query to join data from multiple tables. The nested query will be used with the SQL Statement and must include the primary key with the $ character. For example, 'SELECT tag FROM tag WHERE document_tag.doc_id=$'.
type: array of string
|
|
password
Password
|
The password of the account used for authentication and data access.
type: string
|
|
primary_key
Primary Key
|
The column name of the primary key for the table.
type: string
|
|
sql_select_statement
SQL Statement
required
|
A SQL SELECT statement to choose the records to be retrieved.
type: string
|
|
url
URL
required
|
A URL to the database, starting with jdbc and vendor name, e.g., 'jdbc:mysql://localhost/test'
type: string
minLength: 1
|
|
username
Username
|
The username of a database account used for authentication and data access.
type: string
|
|
verify_access
Validate access
|
Set to true to require successful connection to the filesystem before saving this datasource.
type: boolean
default value: 'true'
|
