Changing the database server
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:
- Back up the data warehouse and ETL repositories with schema.
- Restore the backed up data warehouse and ETL repositories on the new database server.
- Reconfigure the database details
Launch the TrueSight Server Automation - Data Warehouse console.
Perform the following steps to access the console:- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
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 .In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
- Click Configuration > Database Details.
- In the Database Details section, click Reconfigure.
- On the Database Prerequisites tab, select the New databases/users option and click Next.
- 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 Description Host Name Host name or IP address of the database server that hosts the ETL master repository schema
Ensure that:
You do not use the localhost value in this field.
If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.
Port Port number for the database server that hosts the ETL master repository schema SID (Oracle) or Database Name (SQL Server) Service ID or Service name for the ETL master repository User Name User name for the ETL work repository Password and Confirm Password Password for the ETL master repository 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.
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.
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 Description Host Name Host name or IP address of the database server that hosts the ETL work repository schema
Ensure that:
You do not use the localhost value in this field.
If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.
Port Port number for the database server that hosts the ETL work repository schema SID (Oracle) or Database Name (SQL Server) Service ID or Service name for the ETL work repository User Name User name for the ETL work repository Password and Confirm Password Password for the ETL work repository 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.
- Click Finish.
The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.
Update the data warehouse details in TrueSight Smart Reporting - Platform.
Do the following:Log in to the system where the TrueSight Smart Reporting - Platform is installed, and restart TrueSight Smart Reporting - Platform.
Perform the following steps:- (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
- (Linux)
- Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
- Stop TrueSight Smart Reporting - Platform:
./shutdown.sh
- Start TrueSight Smart Reporting - Platform:
./startup.sh
Log in to the TrueSight Server Automation - Data Warehouse console.
To log in as the DWAdmin user, do the following:- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
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 .In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- Click Reports to launch the TrueSight Smart Reporting - Platform Home page.
To log in as a reporting user, do the following:Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
In the User Name and Password fields, enter the user credentials. By default, the password is hidden. To view the password, click .
- In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- 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.
- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
In the left navigation bar, expand and go to Administration > Admin console.
Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
- Click Connection Settings.
- 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
- For SQL Server database:
- Click Test Connection. If the details are correct, a connection success message appears.
- Save the changes.
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:
- Back up the TrueSight Server Automation site databases and restore them on the new database server.
- Update the site database details.
- On the TrueSight Server Automation - Data Warehouse console, navigate to Configuration > Database Details.
- Under Site Details, click under the Modify column corresponding to the site database to be reconfigured.
- Change the required details, such as host name, port, and site ID.
- Click Update.
- On the Last Task Details page, verify the task status.
- If you want to reconfigure other sites, repeat these steps.
- Back up the data warehouse and ETL repositories and restore them on a new database server.
- Reconfigure the database details
Launch the TrueSight Server Automation - Data Warehouse console.
Perform the following steps to access the console:- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
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 .In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
- Click Configuration > Database Details.
- In the Database Details section, click Reconfigure.
- On the Database Prerequisites tab, select the New databases/users option and click Next.
- 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 Description Host Name Host name or IP address of the database server that hosts the ETL master repository schema
Ensure that:
You do not use the localhost value in this field.
If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.
Port Port number for the database server that hosts the ETL master repository schema SID (Oracle) or Database Name (SQL Server) Service ID or Service name for the ETL master repository User Name User name for the ETL work repository Password and Confirm Password Password for the ETL master repository 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.
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.
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 Description Host Name Host name or IP address of the database server that hosts the ETL work repository schema
Ensure that:
You do not use the localhost value in this field.
If you are using an SQL Server and databases are created on a named instance, provide the host name in the Host Name field and a valid port number of the named instance in the Port field.
Port Port number for the database server that hosts the ETL work repository schema SID (Oracle) or Database Name (SQL Server) Service ID or Service name for the ETL work repository User Name User name for the ETL work repository Password and Confirm Password Password for the ETL work repository 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.
- Click Finish.
The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.
Update the data warehouse details in TrueSight Smart Reporting - Platform.
Do the following:Log in to the system where the TrueSight Smart Reporting - Platform is installed, and restart TrueSight Smart Reporting - Platform.
Perform the following steps:- (Windows) Open the Windows services and restart the following service: TrueSight Smart Reporting - Platform
- (Linux)
- Change to the following path: /data1/TrueSightSmartReporting/appserver/bin
- Stop TrueSight Smart Reporting - Platform:
./shutdown.sh
- Start TrueSight Smart Reporting - Platform:
./startup.sh
Log in to the TrueSight Server Automation - Data Warehouse console.
To log in as the DWAdmin user, do the following:- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
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 .In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- Click Reports to launch the TrueSight Smart Reporting - Platform Home page.
To log in as a reporting user, do the following:Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
In the User Name and Password fields, enter the user credentials. By default, the password is hidden. To view the password, click .
- In Site, select a site. The Primary Site is the default site.
- In Authentication Method, select a authentication method. SRP is the default authentication method.
- Click LOG IN.
- 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.
- Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
In the left navigation bar, expand and go to Administration > Admin console.
Click Data Sources and then click the TrueSight Server Automation - Data Warehouse datasource.
- Click Connection Settings.
- 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
- For SQL Server database:
- Click Test Connection. If the details are correct, a connection success message appears.
- Save the changes.
Run the ETL for all the sites as per the schedule.
Comments
Log in or register to comment.