Skip to main content

Managing Mappings

After you scan a DatasourceA connection from Informer to a database or other system of record, such as PostgreSQL, SQL Server, or UniVerse., its Mappings are yours to curate: scan in the tables and fields you need, hide the ones you don't, group and restrict them, link related ones so queries can span them, and add custom-expression Fields the database does not expose on its own.

In this section

ArticleIn one line
Scanning a DatasourceBring Mappings and Fields into Informer, and rescan to stay in sync.
Hiding and unhiding MappingsKeep irrelevant tables out of users' way.
Mapping Sets and restricted FieldsGroup Mappings and restrict Fields for access control.
Custom Field ExpressionsAdd Fields computed by a native database expression.
Linking MappingsRelate Mappings so a Query can pull Fields across them.
Mapping SuitesGroup period-partitioned Mappings behind one logical Mapping.
Datasource Field optionsConfigure how individual Fields behave.