Creating the Database Schema
You can explicitly generate DDL scripts and use them to create the database schema.
- Procedure
- On the machine that runs ActiveMatrix Administrator, configure the drivers for the database using the TIBCO Configuration Tool.
- Navigate to the
TIBCO_HOME
/administrator/<version>
/samples/ddl folder. - Edit the
generate_ddl.xml
file and modify thedbType
anddialect
for your database type under thecreate
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. - Run
ant -f generate_ddl.xml create
. - 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. - (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. - 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