Creating the Database Schema

You can explicitly generate DDL scripts and use them to create the database schema.

    Procedure
  1. On the machine that runs ActiveMatrix Administrator, configure the drivers for the database using the TIBCO Configuration Tool.
  2. Navigate to the TIBCO_HOME/administrator/<version>/samples/ddl folder.
  3. Edit the generate_ddl.xml file and modify the dbType and dialect for your database type under the create target. For more information, see DDLGeneratorTask.
    <target name="create">
               <DDLGeneratorTask
                action="create"
                targetDirectory="${admin.ddl.samples.directory}"
                dbType="oracle11g"
                dialect="com.tibco.amf.sharedresource.runtime.core.hibernate.
                dialects.Oracle10gDialect" />
            </target>
    Note: If you are creating the second instance of a replicated ActiveMatrix Administrator Server, skip steps 2 and 3 while creating the ActiveMatrix Administrator server.
  4. Runant -f generate_ddl.xml create.
  5. Ensure that the Database prerequisites mentioned under Configuring External Databases are met. Have the DBA run the script files - create_*.ddl in the corresponding databases as explained in the Database Models section.
  6. (Optional) In addition to the generated scripts, if you want to use the Monitoring service, the DBA needs to run an additional script corresponding to the monitoring data. It can be found under <TIBCO_HOME>/administrator/<version>/scripts/governance/ddl/create_*.sql. Use the script corresponding to your database type.
  7. Run the TIBCO Configuration Tool again to create the ActiveMatrix Administrator server.
ResultThe DDL scripts are generated and can be used to run on the database.

Sample DDLGeneratorTask element