This section covers the JDBC specific configuration of the Content Service Connector.
Configuration Fields
This section covers the JDBC specific configuration of the Content Service Connector.
- JDBC Table Name: Database table name.
- Schema: Database schema name.
- Catalogue: Database catalog name.
- ID Field: The primary key column to use as the unique ID (expecting an auto generated (i.e. auto increment)) field.
- Name Property: The column to use as the “document name”. This field should not be left blank.
- Created Date Property: The column to use as the “document created date”. This field should not be left blank.
- Modified Date Property: he column to use as the “document modified date”. This field should not be left blank.
- Binary Property: The column to use as the file content. This field can be left blank.
- Root Version Id Property: If the entities in the table track versions, this should provide the column that contains the root version id. This field can be left blank.
- Is Latest Version Property: This field is only used if the Root Version Id Field is populated. This field can be left blank only if the Root Version Id Field is also blank. If the entities in the table track versions, this should provide the column that contains whether the version is the latest (as a boolean).
- Major Version Label Property: This field is only used if the Root Version Id Field is populated. This field can be left blank. If the entities in the table track versions, this should provide the column that contains the major version portion of a version label.
- Minor Version Label Property: This field is only used if the Root Version Id Field is populated. This field can be left blank. If the entities in the table track versions, this should provide the column that contains the major version portion of a version label.
- Quote Identifier Property: If there are spaces in your table names, catalog names, schema names or column names, enter a quote identifier. For example, SQL Server and Oracle use a double quote “. MySQL uses a backtick `
Supported Methods
- Create File
- Delete Object By Id
- Get File Content
- Get Object Properties
- Update File
- Update Properties