Changing multiple databases

To change connection string parameters (such as host name, port, or instance name) in multiple databases (reports data warehouse and ETL repositories) at one time, use the post-installation reconfiguration wizard available in the TrueSight Server Automation - Data Warehouse console. 

To change the reports data warehouse and ETL databases

1. Launch the TrueSight Server Automation - Data Warehouse console.
   

   Perform the following steps to access the console:

   1. To view the home page for the console on Microsoft Windows or UNIX systems, click Start > Programs > TrueSight Server Automation - Data Warehouse > Console.
      Alternatively, you can enter the following address into a web browser: 
      https://reportsServer:portNumber/tssa-dw
      
      • reportsServer is the server that hosts TrueSight Server Automation - Data Warehouse. 
      • portNumber is the web server secure port that you specified during installation. 
   2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse Administrator (DWAdmin) credentials. By default, the password is hidden. To view the password, click .
   3. In Site, select a site. The Primary Site is the default site.
   4. In Authentication Method, select a authentication method. SRP is the default authentication method.
   5. Click LOG IN.
2. Click Configuration > Database Details.
3. In the Database Details section, click Reconfigure.
4. Provide information on the Database Prerequisites Validation tab.
   The Database Prerequisites tab validates whether you have created the required tablespaces and users.
   • Using new databases
     • If you have already created databases and users, select the Fresh database and users are already created? If yes, select the radio button and proceed. If not, download database scripts. option and click Next.
     • If not, click the Download the scripts to create users/database/schema link to download the database and user creation scripts. Set up the database:
       • (Oracle) Create users and tablespaces using the downloaded script and start the configuration process again. For instructions for creating users and tablespaces, see Setting up the Oracle database. 
       • (SQL Server) Create users and databases using the downloaded script and start the configuration process again. For instructions for creating users and databases, see Setting up the SQL Server database. 
   • Using the existing BMC Decision Support for Server Automation databases - Select the Use the existing BladeLogic Decision Support for Server Automation (BDSSA) databases. option and click Next. 
5. Provide information on the ETL Master Repository tab and click Next. If you are using the existing database, all the fields (except Password) in this page are auto-populated. The ETL Master Repository tab enables you to configure the following parameters for the extract, transform, and load (ETL) master repository:Field definitions

   Field	Description
   Host Name	Host name or IP address of ETL master repository server
   Port	Port number on which the ETL master repository server listens
   SID (Oracle) or Database Name (SQL Server)	Service ID or Service name for the ETL master repository
   User Name	ETL master repository user name
   Password	Password for the ETL master repository userNote: Using any of the following special characters in the password will cause the configuration to fail, requiring you to reconfigure the database schema. Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;)
   Confirm Password	Same password for confirming the ETL master repository user

   Error

   Warning

   In case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.

6. Provide information on the Warehouse Database tab and click Next. Enter details of the restored reports data warehouse. If you are using the existing database, all the fields (except Password) in this page are auto-populated. The Warehouse Database tab enables you to configure the following parameters for the TrueSight Server Automation - Data Warehouse reports data warehouse:
   

   Field definitions

   Field	Description
   Database Character Set	(Applicable only for new TrueSight Server Automation - Data Warehouse configuration) Database character set for the reports data warehouseValues can be CHAR or NCHAR.This field does not appear if you are using the existing BMC Decision Support for Server Automation database.
   Host Name	Host name or IP address of the reports data warehouse database serverNote: LOCALHOST is not allowed.
   Port	Port number on which the reports data warehouse database server listens
   SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the reports data warehouse
   User Name	Reports data warehouse user name
   Password	Password for the reports data warehouse userNote: Using any of the following special characters in the password will cause the configuration to fail, requiring you to reconfigure the database schema. Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;)
   Confirm Password	Confirmed password for the reports data warehouse user

   Error

   Warning

   In case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.

   
   

7. Provide information on the ETL Work Repository tab and click Next. If you are using the existing database, all the fields (except Password) in this page are auto-populated. The ETL Work Repository tab enables you to configure the following parameters for the extract, transform, and load (ETL) work repository:

   Field definitions

   Field	Description
   Host Name	Host name or IP address of the ETL work repository server
   Port	Port number on which the ETL work repository server listens
   SID (Oracle) or Database Name (SQL Server)	Service ID or Service name for the ETL work repository
   User Name	ETL work repository user name
   Password	Password for the ETL work repository user
   Confirm Password	Same password for confirming the ETL work repository user

   Error

   Warning

   In case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.

8. Click Finish.
   The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.