Extension Tables

Caution: Allow only qualified personnel who have training in the Boomi™ application to configure or create integrations.

(Optional) Extension Tables provide read and write access to custom database tables for custom data integrations, reports, and other product extensions. These tables can be critical tools for processes like payroll and work tracking.

Examples:

  • Maintain daily payroll records in the extensions database so that payroll export integrations compare records to those in the database and process only changed records.
  • Maintain billing-rate tables in the extensions database for generation of Billing reports with the correct amounts billed to each clientclient.

Each tenant can have multiple extension tables:

  1. Start with an empty database schema for extensions.
  2. Define tables in the empty schema from Setup.
  3. Design integration templates that add, update and delete data in the extension tables by way of a Java Database Connectivity (JDBC) Connector