JDBC Discovery Connector Configurations
- Name: A name for the Discovery Connection to identify it in the UI.
- Authentication Connection: JDBC Authentication Connector
- Ignore Types: Comma delimited list of types to ignore. Note that you can have regex as well. So to ignore all types with “workflow” in the name, you would enter(.)workflow(.) into the ignore types textbox.
- Table Types: Types of tables delimited by comma to retrieve. Normal values are TABLE,VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM. The default value and the one used mostly is TABLE
- Driver: JDBC Driver class (i.e.com.mysql.jdbc.Driver)
- Catalogue: Enter text to narrow results or leave blank to not use Catalogue in Discovery.
- Schema Pattern: Must match the schema name as it is stored in the database. Enter a single space to discover those without a schema. Leave blank if you do not want to use the schema name to narrow the search.
- Table Name Pattern: Enter % to search for all tables or enter text to match against.