User-defined Table and Column Names
TIBCO MDM enables user-defined names for database entities such as tables and columns. TIBCO MDM automatically generates names with internal conventions if no table or column names are provided.
These automatically-generated names can be cryptic or generic. Automatically-generated names are likely to change if the table is ported from one repository to another. Metadata associated with automatically-generated names can also change. In most cases, TIBCO recommends specifying the database tables and columns. Automatically-generated names are useful in development environments, where users do not want to name tables and columns and do not want to expose database details.
User-defined tables and columns make it easier for external tools like TIBCO Spotfire to access the database. User-defined names are also more easily understood by SQL programmers.
User-defined table names must be unique within the same database instance. You cannot assign the same table name to more than one repository even if they are defined in different enterprises as long as these enterprises are deployed in the same TIBCO MDM instance. You cannot import metadata into another enterprise within the same instance because attempts to create a duplicate table.