You need the listed parameters to configure the Database
Connector.
- Database Type
- This section prompts you for hostname, port and database parameters.
Based on the database type dropdown selection the jdbcDriver and jdbcSource parameters
are generated.
- Username
- Signon to the database using this username; only the tables accessible
to this user will be shown. This reflects the jdbcuser parameter
of the JDBC connector.
- Password
- The password used in the signon for the user.
- Schema
- The schema from the table of the database that you want to use.
If left blank, the value of the jdbcLogin (that is, the Username parameter)
is used.
Note: Throughout the IBM® Security Directory Integrator documentation,
you will find the term Schema used to mean the data definition of
the object you are accessing. However, in the RDBMS world, the term
Schema has a different meaning, namely the overall collection of data
definitions, tables and objects grouped under one identifier (username).
For this particular parameter in this particular Connector, we use
it in the RDBMS sense.
- Table Name
- The name of the table you wish to access with this connector.
You can use the Select button to query the
database for accessible tables, provided you are able to signon to
the database.
- Auto-create table
- When the connector is configured in one of the output modes (AddOnly,
Update) you have this additional option in the advanced section.
The Auto-create
table option will make the connector create a simple table
based on the attribute map and schema for the connector. This is only
done when the table does not exist in the database.
When auto-creating
a table the connector will first derive the column names from the
attribute map. If the attribute map is empty, the schema is used to
get the list of column names. Once the column names are determined
a SQL
CREATE TABLE statement is generated with each of the
column names. If the schema has a definition for the column name it
will be consulted to determine the syntax for the column. There are
two parts in the schema that will determine the syntax for the column.
First, if the "Native Syntax" is specified it is used as-is. Next,
if there is no native schema provided the connector uses the "Java™ Class" to derive the syntax.
The Java-class field in the schema should specify any of the following
values:
Table 1. Java class
to SQL type mapping| Value |
Generated SQL type |
|---|
| Integer or java.lang.Integer |
INT |
| String or java.lang.String |
VARCHAR(255) |
| Double or java.lang.Double |
DOUBLE |
| Date or java.util.Date |
TIMESTAMP |
If there is no schema information about the column, or if
the value is not recognized the connector will use "VARCHAR(255)"
in the generated create table statement.