PowerDesigner includes all the resources you need to generate a set of data definition language (DDL) statements in a SQL script directly from the data model. You can run this script to generate a schema for your ASE database. The ASE database schema must match the Sybase IQ schema, as Sybase IQ is the Replication Server target database in Risk Analytics Platform.
To create the SQL script with DDL statements for the ASE database schema, follow the steps in “RAPCache database” in Chapter 4, “Generating DDL Scripts” of the Risk Analytics User’s Guide. Execute the generated script to create the ASE database tables and other database objects.
You can also create the ASE source database using the DDL script $RAP_HOME/Model/RAPCache/RAP_Table.sql which is provided with RAP.
Risk Analytics Platform does not include indexes for
an Adaptive Server Enterprise 15.0 source database.
