Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
{
	"display": string,
	"database": {
		"url":string, // 
		"username":string, // Username for the database,
 		"password":string, // Password for the database,

 		"databaseType":string, // String, type of DB to connect to
					// eg: mysql, db2, oracle, mssqlserver, sybase
		"hostname":string, // String, hostname of database server to connect to
		"port":string, // String, port database server is listening for connections on
		"databaseName":string, // String, name of database containing the data to be extracted
		"query":string, // String, SQL query used to retrieve full dataset from source (the first time the source is added)
		"deltaQuery":string, // String, SQL query used to retrieve updates from source after the first time through
		"deleteQuery":string, // String, not currently implemented
		"primaryKey":string, // String, primary key field in data set, used to help identify whether a record is new or previously harvested
		"primaryKeyValue":string, //String, primary key value, only used when placing in the feed record
		"title":string, // String, one of the columns from query/deltaQuery; populates the document's title field
		"snippet":string, // String, one of the columns from query/deltaQuery; populates the document's description field
		"publishedDate":string, // String, one of the columns from query/deltaQuery; populates the document's published date field
	}
}

 

Description

The following table describes the parameters of the database extractor configuration.

...