Database Format

Note: To use database format, you must have a database connection. Profile should be created on the database where MDM is running. For more information on creating a new database connection refer toCreating a New Database Connection profile.

Procedure

  1. If you have selected Database format then Database Table Selection section is displayed.
  2. Select the Database profile from the Profile drop-down list.
  3. The Scheme or the Catalog for the selected Database profile is populated. Select the appropriate scheme from the Schema/Catalog drop-down list.
  4. Select the appropriate source. The available sources are Table/View and SQL.
    • Table/View

      On selecting Table/View, the database table and views are displayed.

      Select the appropriate table from Table/View drop-down list.

      Click Finish. After clicking finish data source will be opened in the Data Source Editor. The datasource attributes are created based on table/view metadata.

    • SQL

      On selecting the SQL, a text editor is displayed to enter sql select statement.

      When datasource upload is done on MDM, this query is executed to upload data into DF_* table.

      Enter sql select statement in the text box. For example, select * from address.

      Click Finish. If there are any errors in executing select statement, error message is displayed on clicking finish. If no errors, then after clicking finish data source will open in the DataSource Editor. The datasource attributes are based on selected column's metadata in the SQL statement.

      Note: The table name must be available in the TIBCO MDM database. You cannot connect to a different database. The SQL statement is stored in DataFragment table in MDM and has limitation of 4000 characters. For complex queries you can define view on database and use it. Data source with SQL type must be uploaded manually in MDM.

      For more information of creating a new database connection refer to, Data Source Explorer.