Working with Schema Browser

TIBCO adapters use schemas to manage data that is retrieved from and exported to a source or target application. You can use the Schema Browser view provided by TIBCO ActiveMatrix Adapter Framework to add and manage schemas.

During the configuration phase, you can use the Schema Browser view to fetch a schema from the source or target application and apply the schema to an adapter service. The adapter adds that schema definition as a schema class. You can configure a schema to describe the structure of messages processed by the adapter.

To work with the Schema Browser view, complete the following tasks:
  1. Adding a destination
  2. Fetching tables or stored procedures
  3. Replicating schema information

Difference Between Database Schema and TIBCO ActiveEnterprise Schema

When you create an adapter service with a table or stored procedure selected, the adapter user interface creates a folder in the AESchemas/ae/ADB folder for the adapter configuration and transforms the created folder into an AE schema.

Different from database schema objects, an AE schema is recognized by TIBCO Adapter SDK, which is the fundamental class library used in the adapter implementation.

An AE schema consists of five parts: associations, classes, scalars, sequences, and unions. The transformation is done automatically. For most cases, do not modify the AE schema manually.

  • Adding a Destination
    You can add destinations for multiple backend data sources, for example, SAP and databases. Each destination represents the root of a repository, and when expanded, the destination displays a hierarchical structure representing the organization of the backend system.
  • Fetching Tables and Stored Procedures
    You can use the Schema Browser view to fetch tables, stored procedures, functions, and packages from a database destination.
  • Replicating Schema Information
    You can replicate schema information from a workspace to another workspace.