Use of SQL-Based Datasources

Avoid using SQL based datasources for data that changes often. TIBCO MDM can cache the data contained in the SQL datasource.

Unless an explicit upload is done when the underlying data changes, TIBCO MDM does not know that the data has changed. The data caching happens when the SQL data sources are used in rulebases.

Avoid importing multiple repositories and hierarchies based on the view and SQL datasource.