Previous Topic: SQL Anywhere Database Preparation Using Manual ProceduresNext Topic: Create CMS Repository and Audit Databases


Command Line Syntax Variables

The variable names described in the following table represent the details that you supply in the database preparation commands. Before you execute a particular command, replace each variable with the actual value that applies to your environment.

As an alternate method, you can create environment variables for any of these variable names. Then when you create your command statements, you can insert the environment variables instead of the actual values.

Variable Name

Description

DATABASE_DIR

Folder location where the SQL Anywhere databases for CMS and Audit reside. If the directory name contains spaces, enclose them in quotation marks. Verify that the directory name has no trailing slash (\).

Example:

"C:\Program Files (x86)\CA\SC\
CommonReporting3\SQLAnyWhere12\bin"

SQLANYWHERE_DIR

SQL Anywhere folder where the binaries reside. This folder is typically found in the CABI_Install_Dir\SQLAnyWhere12\bin folder. If the directory name contains spaces, enclose them in quotation marks. Verify that the directory name has no trailing slash (\).

Example:

"C:\Program Files (x86)\CA\SC\
CommonReporting3\SQLAnyWhere12\bin"

SQLANYWHERE_SERVER

SQL Anywhere Server Name. A service with this name is registered in the Windows control panel and allows users to start or stop the SQL Anywhere databases.

Example: BOE120SQLAW

SQLANYWHERE_HOST

SQL Anywhere Host Name. This name is typically the same as the name of the computer on which CA Business Intelligence is installed.

Example: localhost

SQLANYWHERE_PORT

SQL Anywhere Port Number. The default port number is 2638.

Example: 2638

DATABASE_NAME

Database name for the CMS Repository database

Example: BOE120

AUDIT_DATABASE_NAME

Database name for the Audit database

Example: BOE120_AUDIT

ADMIN_UID

SQL Anywhere database administrator User Account

Example: root

ADMIN_PWD

Password for SQL Anywhere database administrator User Account

Example: abc123

BOE_UID

SQL Anywhere BusinessObjects Enterprise User Account

Example: boe

BOE_PWD

Password for SQL Anywhere BusinessObjects Enterprise User Account

Example: def123