Setting up Databases

TIBCO MDM supports Oracle and SQL Server databases for data storage.

Configuring the database of TIBCO MDM consists several steps, most of which are done manually such as creating users, schemas, and table spaces; changes to SQL scripts to change location or default table space sizes, handling multibyte characters, and so on.

  • Supported Databases
    Install anyone of the following databases as per your requirement. For a list of versions and platforms supported, refer to the Readme.txt file shipped with installation of TIBCO MDM.
  • Database Sizing Requirements
    The database sizing requirements include the minimal sizing requirements for initdbname.ora (initecm50.ora); for small, medium, and large databases.
  • Configuration of Oracle Database
    To configure the Oracle database, use the Oracle Configuration Assistant. Consult your Database Administrator on standard practices followed by your IT department to change the recommended structure according to your needs.
  • Configuration of SQL Server Database
    Install the SQL Server software as directed in the appropriate SQL installation document. Consult your Database Administrator about standard practices followed by your IT department to change the recommended structure according to your needs. After the SQL Server software is installed, configure the database.
  • Creating Seed Data Manually for PostgreSQL Database
    You can create seed data through manual configuration.
  • Installing Seed Data Using Database Setup Wizard
    The Database Setup Wizard of Configurator makes the database setup process easy and user-friendly.