Using DB connector to index URL metadata

In DB Connector version 4.1.1 a new feature was added to retrieve metadata from database and index it by the GSA. In this mode DB data set (result of the SQL query) should contain URL and set of fields that contain metadata.

Here is a sample connector configuration:

db.everyDocIdSql=select urlpath,meta1,meta2 from urlmode_table

In this example: 

db.everyDocIdSQL returns URL and two metadata fields.
db.singleDocContentSql= empty parameter should be present.
db.metadataColumns value contains contains mapping of DB metadata fields and metadata names to be indexed. db.modeOfOperation.urlAndMetadataLister.columnName value contains the name of a field which contains URL for which metadata should be published.

Was this article helpful?
How can we improve it?