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. SQL Loader 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 used when building AccountGroup objects, which are used to hold entitlements shared across identities.

The SQL Loader connector's most important attribute is the SQL statement. In this case, it is the select query of 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. It then uses the metadata returned from the result to build the column names.