Schema Attributes
The application schema is used to configure the objects returned from a connector. When a connector is called, the schema is supplied to the methods on the connector interface and supports multiple types of objects, account and any number of group application object types. Account objects are used when building identities' Link objects. Additional schema definitions can be can be used when building AccountGroup objects which are used to hold entitlements shared across identities.
The JDBC connector's most important attribute is the SQL Statement. In many cases this is a stored procedure. (call mystoredProcedure
). In other cases it is selected from a table with any number of joins included. If this connector is configured to use the automatic discovery function, it connects to the database and executes the statement provided and then uses the meta-data returned from the result to build the column names.
Important
SQL entries can't end with a semicolon (;). Ending an SQL entry with a semicolon (;) can cause a general error message to display.