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 Manual Procedures › Create User-Level ODBC Entries for CMS Repository and Audit Databases

Create User-Level ODBC Entries for CMS Repository and Audit Databases

Use the commands that apply to your environment to create the user-level ODBC entries for the CMS Repository and Audit databases.

Note: The command line syntax in this procedure contains the variables that are defined in Command Line Syntax Variables. Replace these variables (in italics) with the values that are appropriate for your environment.

Follow these steps:

1. Open a command prompt window.
2. (Windows) Execute the following command to create the DSN for the CMS Repository database.

   SQLANYWHERE_DIR\dbdsn.exe -y -ws DATABASE_NAME -c "uid=BOE_UID;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=DATABASE_NAME"
   

3. (UNIX) Execute the following command to create the DSN for the CMS Repository database.

   $SQLANYWHERE_DIR/dbdsn -y -w $DATABASE_NAME -c "uid=$BOE_UID;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$DATABASE_NAME"
   

4. (Windows) Execute the following command to create the DSN for the Audit database.

   SQLANYWHERE_DIR\dbdsn.exe -y -ws AUDIT_DATABASE_NAME -c "uid=BOE_UID;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=AUDIT_DATABASE_NAME"
   

5. (UNIX) Execute the following command to create the DSN for the Audit database.

   $SQLANYWHERE_DIR/dbdsn -y -w $AUDIT_DATABASE_NAME -c "uid=$BOE_UID;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$AUDIT_DATABASE_NAME"