...
The Source.database object describes how documents can be harvested from a traditional RDBMS database using JDBC drivers.
Code Block | ||
---|---|---|
| ||
{ "databaseType" : "string", // String, type of DB to connect to, i.e.: // 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 "deltaQuery" : "string", // String, SQL query used to retrieve updates from source "deleteQuery" : "string", // String, not implemented in beta release "primaryKey" : "string", // String, primary key field in data set, used to help identify // whether a record is new or previously harvested "title" : "string", // String, populates the document's title field "snippet" : "string", // String, populates the document's description field "publishedDate" : "string", // String, populates the document's published date field } |