To configure a JDBC data source, specify values for the configuration properties listed below. If you are configuring the data source in CAS Console, the CAS Property Display Name appears in the user interface. If you are configuring the data source using a crawl configuration file or the CAS Server API, specify a value for the CAS Property Name in the configuration file or pass a value to the API.
Note
In addition to configuring the data source-specific properties listed below, you must enter values for the data source Username and Password.
|
CAS Property Display Name |
CAS Property Name |
Property Description |
|---|---|---|
|
Driver class |
|
(Required). Specify the fully qualified Java class name for the JDBC driver. |
|
JDBC URL |
|
(Required). Specify the connection string that includes, at a minimum, the database vendor, the host and port, and the database instance name. If desired, you can also specify the Username and Password as part of the connection string. |
|
Connection Properties |
|
(Optional). Specify any additional connection
properties that your database may require. Specify properties in the format:
|
|
SQL/Record Generation |
|
(Required). Specify a SQL query to execute against the database. |
|
Key Column |
|
(Required). Specify the name of the column in the database that you want to map to the record ID property in the generated records. |
Note
Properties are case sensitive.
