If you move the reports data warehouse and ETL repositories (Master and Work databases) to a different database server, you must configure the connection string parameters such as host name, port, and instance name to connect TrueSight Server Automation - Data Warehouse to the new server.

The configuration steps vary depending on the following scenarios:

• Scenario 1: Moving the data warehouse and ETL repositories
• Scenario 2: Moving the data warehouse, ETL repositories, and site databases

Scenario 1: Moving the data warehouse and ETL repositories

If you want to move the data warehouse and ETL repositories to a different database server, do the following:

1. Back up the data warehouse and ETL repositories with schema.
2. Restore the backed up data warehouse and ETL repositories on the new database server.
3. Reconfigure the database details

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

      Perform the following steps to access the console:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
         
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
         Default user name: DWAdmin
         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. On the Database Prerequisites tab, select the New databases/users option and click Next.
   5. Provide information on the ETL Master Repository tab and click Next. 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

      WarningIn 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. The Warehouse Database tab enables you to configure the following parameters for the TrueSight Server Automation - Data Warehouse reports data warehouse:
      

      Field	Description
      Database Character Set	Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. This field is disabled.
      Host Name	Host name or IP address of the database server that hosts the data warehouse schema Ensure that: You do not use the localhost value in this field. If you are deploying with the SQL Server database and databases are created on a named instance, you provide the hostname and valid port number of the named instance instead of <Hostname/NamedInstance> in the Host Name field.
      Port	Port number for the database server that hosts the data warehouse schema
      SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the data warehouse
      User Name	User name for the data warehouse user
      Password and Confirm Password	Password for the data warehouse user Note: Do not use the following special characters: Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;) If you use special characters, the configuration fails and you have to reconfigure the database schema.

      
      

   7. Provide information on the ETL Work Repository tab and click Next. 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

      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.

4. Update the data warehouse details in TrueSight Smart Reporting.

   Do the following:

   1. Log in to the system where the TrueSight Smart Reporting is installed, and restart TrueSight Smart Reporting.

      Perform the following steps:

      • (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
      • (Linux)
        1. Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
        2. Stop TrueSight Smart Reporting: ./shutdown.sh
        3. Start TrueSight Smart Reporting: ./startup.sh

   2. Log in to the TrueSight Server Automation - Data Warehouse console. 

      To log in as the DWAdmin user, do the following:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
         
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
         Default user name: DWAdmin
         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.
      6. Click Reports to launch the TrueSight Smart Reporting - Platform Home page.

      To log in as a reporting user, do the following:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
      2. In the User Name and Password fields, enter the user 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.
      6. In the Roles window, select the role you want to use and click OK. Through role-based access control (RBAC), you can be granted multiple roles, but you can use only one role at a time.
   3. In the left navigation bar, expand   and go to Administration > Admin console.
   4. Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
   5. Click Connection Settings.
   6. Specify new values for the updated fields.
      
      • For SQL Server database:
        • The database host name
        • The database name and port
        • User name and password
      • For Oracle database
        • The database host name
        • The database port
        • The service name
        • User name and password
   7. Click Test Connection. If the details are correct, a connection success message appears.
   8. Save the changes.
5. Run the ETL as per the schedule.

Scenario 2: Moving the data warehouse, ETL repositories, and TrueSight Server Automation site databases

If you want to move the data warehouse, ETL repositories, and TrueSight Server Automation site databases to a different database server, do the following:

1. Back up the TrueSight Server Automation site databases and restore them on the new database server.
2. Update the site database details.

   1. On the TrueSight Server Automation - Data Warehouse console, navigate to Configuration > Database Details.
   2. Under Site Details, click under the Modify column corresponding to the site database to be reconfigured.
   3. Change the required details, such as host name, port, and site ID.
   4. Click Update.
   5. On the Last Task Details page, verify the task status.
   6. If you want to reconfigure other sites, repeat these steps.
3. Back up the data warehouse and ETL repositories and restore them on a new database server.
4. Reconfigure the database details

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

      Perform the following steps to access the console:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
         
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
         Default user name: DWAdmin
         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. On the Database Prerequisites tab, select the New databases/users option and click Next.
   5. Provide information on the ETL Master Repository tab and click Next. 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

      WarningIn 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. The Warehouse Database tab enables you to configure the following parameters for the TrueSight Server Automation - Data Warehouse reports data warehouse:
      

      Field	Description
      Database Character Set	Values can be CHAR or NCHAR based on your TrueSight Server Automation schema. This field is disabled.
      Host Name	Host name or IP address of the database server that hosts the data warehouse schemaEnsure that: You do not use the localhost value in this field. If you are deploying with the SQL Server database and databases are created on a named instance, you provide the hostname and valid port number of the named instance instead of <Hostname/NamedInstance> in the Host Name field.
      Port	Port number for the database server that hosts the data warehouse schema
      SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the data warehouse
      User Name	User name for the data warehouse user
      Password and Confirm Password	Password for the data warehouse userNote: Do not use the following special characters: Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;) If you use special characters, the configuration fails and you have to reconfigure the database schema.

      
      
   7. Provide information on the ETL Work Repository tab and click Next. 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

      WarningIn 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.
5. Update the data warehouse details in TrueSight Smart Reporting.
   Do the following:

   1. Log in to the system where the TrueSight Smart Reporting is installed, and restart TrueSight Smart Reporting.

      Perform the following steps:

      • (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
      • (Linux)
        1. Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
        2. Stop TrueSight Smart Reporting: ./shutdown.sh
        3. Start TrueSight Smart Reporting: ./startup.sh
   2. Log in to the TrueSight Server Automation - Data Warehouse console.

      To log in as the DWAdmin user, do the following:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
         
      2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
         Default user name: DWAdmin
         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.
      6. Click Reports to launch the TrueSight Smart Reporting - Platform Home page.

      To log in as a reporting user, do the following:

      1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
         https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
      2. In the User Name and Password fields, enter the user 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.
      6. In the Roles window, select the role you want to use and click OK. Through role-based access control (RBAC), you can be granted multiple roles, but you can use only one role at a time.
   3. In the left navigation bar, expand   and go to Administration > Admin console.
   4. Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
   5. Click Connection Settings.
   6. Specify new values for the updated fields.
      
      • For SQL Server database:
        • The database host name
        • The database name and port
        • User name and password
      • For Oracle database
        • The database host name
        • The database port
        • The service name
        • User name and password
   7. Click Test Connection. If the details are correct, a connection success message appears.
   8. Save the changes.
6. Run the ETL for all the sites as per the schedule.