metadataFetching

Metadata Fetching

In virtual mode we can fetch metadata in 3 ways:

1. Constructor

   The metadata is provided by the user.

2. Full metadata

   It adds data definition to the metadata and gets tables directly from the connection to the database.

   For each table it gets columns information.

3. Parsed mappings

   It gets part of the metadata parsing the mappings to obtain tables.

   Connecting to the database, it gets columns information from the retrieved tables.

Multi-schema is supported when the constructor mode or the parsed mapping mode is used.

See more information in multi-schema.

In DBMetadata we are able to insert a list of data definitions. The table definitions should be inserted with the structure schema.table to allow multi-schema. If the table has quotes this will be maintained also in the data definition, but to retrieve the information is important to provide the full name without quotes. These allows to retrieve the information through the mappings.