Managing the ETL repositories

Use the following instructions with the TrueSight Server Automation - Data Warehouse console to retrieve details about the ETL repository databases and modify the ETL repository parameters.

To retrieve details about the ETL master and work repositories

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. From the Configuration menu, select Database Details.
3. The ETL Master Repository and ETL Work Repository rows display details.

To modify details about the ETL master repository

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. From the Configuration menu, select Database Details.
3. Click the Modify button in the ETL Master Repository row. 

4. On the Modify ETL Master Repository Details page, modify the parameters as required.
   Field definitions

   Field	Description
   (Oracle) Please confirm whether you have created Master repository tablespace and user (SQL Server) Please confirm whether you have created Master repository database and user	(Oracle) Validation of whether you have created the required ETL master repository tablespace and user If you have created the tablespace and user already, select this check box. If not, click the Download the scripts to create users/database/schema link, download the tablespace and user creation script, and create the required tablespace and user as described in Creating-tablespaces-and-users-on-Oracle. (SQL Server)   Validation of whether you have created the required ETL master repository database and user If you have created the database and user already, select this check box. If not, click the Download the scripts to create users/database/schema link, download the database and user creation script, and create the required database and user as described in Creating-databases-and-users-on-SQL-Server.
   Host Name	Host name or IP address of the 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 name for the ETL master repository
   User Name	ETL master repository user name
   Password	Password for the ETL master repository user
   Confirm Password	Confirmation of the password for the ETL master repository user

5. Click Update.

   Warning

   Note

   Click Revert to revert to the previous settings.

To modify details about the ETL work repository

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. From the Configuration menu, select Database Details.
3. Click the Modify button in the ETL Work Repository row.

4. On the Modify ETL Work Repository Details page, modify the parameters as required.
   Field definitions

   Field	Description
   (Oracle) Please confirm whether you have created Work repository tablespace and user (SQL Server) Please confirm whether you have created Work repository database and user	(Oracle) Validation of whether you have created the required ETL work repository tablespace and user If you have created the tablespace and user already, select this check box. If not, click the Download the scripts to create users/database/schema link, download the tablespace and user creation script, and create the required tablespace and user as described in Creating-tablespaces-and-users-on-Oracle. (SQL Server)   Validation of whether you have created the required ETL work repository database and user If you have created the database and user already, select this check box. If not, click the Download the scripts to create users/database/schema link, download the database and user creation script, and create the required database and user as described in Creating-databases-and-users-on-SQL-Server.
   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 name for the ETL work repository
   User Name	ETL work repository user name
   Password	Password for the ETL work repository user
   Confirm Password	Confirmation of the password for the ETL work repository user

   
   

5. Click Update.

   Warning

   Note

   Click Revert to revert to the previous settings.