Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › SQL Anywhere Database Preparation Using the Automation Script › Create Databases with the Automation Script

Create Databases with the Automation Script

Use the automation script to create the CMS Repository and Audit databases, create and register the service to start and stop the databases, and create the DSN for the databases. On Windows, run the script as a user with administrative privileges. On UNIX, run the script as the CA Business Intelligence operating system user account that was specified during the installation of CA Business Intelligence.

Note: To display online help for the script command usage, execute one of the following commands:

(Windows): ssawdbcreate.bat -help
(UNIX): ssawdbcreate.sh

Follow these steps:

1. Locate the ssawdbcreate.bat (Windows) or ssawdbcreate.sh (UNIX) script file in the following location:

   CA Business Intelligence_media\Disk1\cabi\scripts\SQLAW
   

   Note: This location is shown in Windows system notation. The UNIX system notation uses forward slashes instead of backward slashes.

2. Copy the ssawdbcreate script file to a location on the computer where CA Business Intelligence is installed (for example, C:\ssaw) and navigate to that location.
3. Execute the following command. Arrange all parameters (shown in curly braces) in the order shown in the following command. All parameters are required.

   ssawdbcreate_command {CABI Install Dir} {SQLAW Server Name} {SQLAW Host Name} {SQLAW Port} {Database Name} {Administrator User} {Administrator Password} {BO User Account} {BO User Account Password}
   

   Note: For ssawdbcreate_command, use the command that applies to your environment (ssawdbcreate.bat or ssawdbcreate.sh).

   CABI Install Dir

   Points to the location where CA Business Intelligence is installed (this directory typically includes up to the CommonReporting3 folder). You create the SQL Anywhere databases (CMS and Audit) in the following folder:

   (Windows): CABI Install Dir\SQLAnyWhere12\bin
   

   (UNIX): CABI Install Dir/bobje/SQLAW/bin
   

   If the directory name contains spaces, enclose them in quotation marks. Verify that the directory name has no trailing slash (/ or \).

   Example (Windows): "C:\Program Files (x86)\CA\SC\CommonReporting3"

   Example (UNIX): /opt/CA/SharedComponents/CommonReporting3

   SQLAW Server Name

   Indicates the SQL Anywhere Service Name. Spaces are not allowed.

   Example: BOE120SQLAW

   SQLAW Host Name

   Points to the host name where the SQL Anywhere database is hosted. Typically, this host is the same host where CA Business Intelligence is installed. Spaces are not allowed.

   Example: localhost

   SQLAW Port

   Points to the port on which the SQL Anywhere database runs. The default port is 2638.

   Database Name

   Identifies the database name for the CMS Repository database. For the audit database, the script suffix is _AUDIT.

   Example: If the value for {Database Name} is BOE120, the name for the Audit database would be BOE120_AUDIT.

   Administrator User

   Specifies the SQL Anywhere database administrator User Account (for both CMS and Audit databases).

   Example: root (or dba)

   Administrator Password

   Specifies the password for the SQL Anywhere database administrator User Account.

   BO User Account

   Specifies the SQL Anywhere BusinessObjects Enterprise User Account (for both CMS and Audit databases).

   Example: Boe

   BO User Account Password

   Specifies the password for the SQL Anywhere BusinessObjects Enterprise User Account.