Search
Clear search
Close search
Google apps
Main menu

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:

docId.isUrl=true
db.uniqueKey=urlpath:string
db.everyDocIdSql=select urlpath,meta1,meta2 from urlmode_table
db.singleDocContentSql=
db.metadataColumns=meta1:META1,meta2:META2
db.modeOfOperation=urlAndMetadataLister
db.modeOfOperation.urlAndMetadataLister.columnName=urlpath

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?