Table of contents Update the Aternity Dashboard Gateway Server Update the Aternity Dashboard Gateway Server by running the setup over the existing pathname. The Dashboard Gateway acts as the interface between the Dashboard Server and the Aternity Management Server, performing background tasks like preprocessing the data for display in the dashboards, and maintaining logs, audits and cleanup. It must be on the same computer as the Dashboard Server. While it has no user interface of its own, it is crucial to the proper functioning of Aternity. The Dashboard Gateway is on the same computer as the Dashboard Server Before you begin Download the latest Aternity on-premise's main setup package from the Aternity Support Site (learn more). If you are running a version earlier than 11.0.3, update to 11.0.3 before updating to 12.1. Check the correct sizing for your deployment before updating any of your Aternity servers. Learn more. Prepare the Aternity Oracle Database Server for Aternity by verifying its configuration. Learn more. Aternity requires you set up one or more new Vertica Database Servers, depending on the size of your deployment. Learn more. (If you performed the data migration process, then your Vertica Database Server is already up and running.) (For upgrades from 11.0.3) Update the Dashboard Server by removing the previous version of Tableau and then running the setup of the new version. Learn more. To install the Dashboard Gateway, you must have on the Dashboard Server: Attribute Requirement Permissions Ensure you have local administrator privileges on this computer. Microsoft .NET Ensure this server has Microsoft .NET 3.5 (exactly) required for the database drivers, and .NET 4.5 or later, required for driver setup (both in parallel). To add .NET to a Windows Server, learn more. Time zone Synchronize all Aternity components to have the same date, time AND time zone. We recommend that an IT person define a clock synchronization service, like for example NTP, between all Aternity components. This will provide highly accurate timing for all network components and prevent clock drift. ProcedureStep 1 Access the Aternity Dashboard Server. Step 2 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 3 Locate the AternityTableauGateway_windows-x64_12.1.0.<build number> setup file, which you downloaded as part of the Aternity on-premise server setup package. Copy it to a temporary location on this computer. Step 4 Right-click the setup and select Run as administrator to begin. Step 5 Select Yes, update the existing installation. Choose to overwrite the previous deployment Step 6 Define the Management Server's access to the Dashboard Gateway and click Next. Define the credentials and port number for the Dashboard Gateway Field Description Gateway User / Password /Confirm Password Displays the username and password for the Dashboard Gateway. Make a note of this for when you later install the Aternity dashboard layouts on the Management Server. Gateway Port Displays the port number which the Management Server must use when it accesses the Dashboard Server. The default port is 8088. If already defined, you can preserve the existing credentials or change them as desired. Step 7 Define the credentials of a local administrator on that device and click Next. Define the local user (For upgrades from 11.0.3) Provide the credentials of a local administrator on that device and click Next. Tableau file paths are automatically discovered. You need only enter the administrator user name and password. (For upgrades from 12.0) The credentials for a local administrator on the device provided for the original setup are preserved and do not need to be updated. Step 8 Connect the Dashboard Gateway to the Dashboard Server (Tableau). The update automatically inserts the settings from the previous existing setup. Connect to the Dashboard Server (Tableau) Field Description Tableau Administrator User / Password Enter the Tableau administrator username and password which you created when you set up the Dashboard Server. Tip To avoid adding hidden characters, type these fields with the exact correct credentials. Do not paste them. Tableau Hostname Enter the hostname or IP address which users enter as their URL when accessing the dashboards directly from the Dashboard Server. This is NOT the Aternity URL. This is the direct dashboards URL. For example, dashboards.company.com Tip To avoid adding hidden characters, type this field with the exact correct address. Do not paste it. Port Enter the port for users to access the dashboards. The default is 80, but if you select Use SSL Transport, enter 443. Use SSL Transport Select if you configured the Dashboard Server so users who view the dashboards in their browsers must access via SSL (https). This setting encrypts the connection between the Dashboard Server and the Dashboard Gateway. Step 9 If prompted, restart the computer to complete the setup. If you choose not to restart when prompted, it displays the final screen which urges you to restart the computer. Start the Dashboard Gateway automatically Step 10 To verify that the Dashboard Gateway is functioning properly: a Verify there is a Windows Service called AternityTableauGateway which starts automatically. b On the Dashboard Server, go to http://localhost:8088/tableau-gateway/info.jsp If you changed the default port from 8088 to a different value, substitute it here. c Enter the Dashboard Gateway's username and password to display its settings in the browser. Verify the Dashboard Gateway is functioning Step 11 Set up the drivers on the Dashboard Server to enable connection to the Aternity Vertica Database Server, by launching the small driver setup file, data\AternityTableauGateway\vertica\VerticaSetup-<version>.exe. This standalone setup program is part of the Aternity on-premise download package, and requires .NET installed, as detailed in the prerequisites. Select Install to start the setup wizard. Select all the components (selected by default), and then select Next > Proceed. Add all Vertica driver components After the setup completes, exit the program. Step 12 Clean up log files manually on a regular basis (recommended – once a week). Tableau log cleaning does not run automatically resulting in logs building up and filling available disk space. It is important to add a scheduled task to run this command periodically: tsm maintenance cleanup -l --log-files-retention <number of days> Important Unhandled log files cleaning may cause a Tableau server corruption and malfunction. Running the tsm maintenance command requires administrator privileges. The user running this command must be a member of the administrative group on the host machine. For more information, read Tableau Help. Parent topic Upgrade to Aternity on-premise 12.1Related tasksUpdate the Aternity Oracle Database ServerUpdate the Aternity Vertica Database ServerUpdate the Aternity Dashboard ServerQuickly Update the Aternity Management ServerUpdate (Publish) Dashboard Layouts for AternityUpdate the Aternity Docker Components ServerQuickly Update Aternity Data Warehouse Server on a Dedicated ComputerQuickly Update an Aternity Aggregation Server on a Dedicated Computer SavePDF Selected topic Selected topic and subtopics All content Related Links
Update the Aternity Dashboard Gateway Server Update the Aternity Dashboard Gateway Server by running the setup over the existing pathname. The Dashboard Gateway acts as the interface between the Dashboard Server and the Aternity Management Server, performing background tasks like preprocessing the data for display in the dashboards, and maintaining logs, audits and cleanup. It must be on the same computer as the Dashboard Server. While it has no user interface of its own, it is crucial to the proper functioning of Aternity. The Dashboard Gateway is on the same computer as the Dashboard Server Before you begin Download the latest Aternity on-premise's main setup package from the Aternity Support Site (learn more). If you are running a version earlier than 11.0.3, update to 11.0.3 before updating to 12.1. Check the correct sizing for your deployment before updating any of your Aternity servers. Learn more. Prepare the Aternity Oracle Database Server for Aternity by verifying its configuration. Learn more. Aternity requires you set up one or more new Vertica Database Servers, depending on the size of your deployment. Learn more. (If you performed the data migration process, then your Vertica Database Server is already up and running.) (For upgrades from 11.0.3) Update the Dashboard Server by removing the previous version of Tableau and then running the setup of the new version. Learn more. To install the Dashboard Gateway, you must have on the Dashboard Server: Attribute Requirement Permissions Ensure you have local administrator privileges on this computer. Microsoft .NET Ensure this server has Microsoft .NET 3.5 (exactly) required for the database drivers, and .NET 4.5 or later, required for driver setup (both in parallel). To add .NET to a Windows Server, learn more. Time zone Synchronize all Aternity components to have the same date, time AND time zone. We recommend that an IT person define a clock synchronization service, like for example NTP, between all Aternity components. This will provide highly accurate timing for all network components and prevent clock drift. ProcedureStep 1 Access the Aternity Dashboard Server. Step 2 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 3 Locate the AternityTableauGateway_windows-x64_12.1.0.<build number> setup file, which you downloaded as part of the Aternity on-premise server setup package. Copy it to a temporary location on this computer. Step 4 Right-click the setup and select Run as administrator to begin. Step 5 Select Yes, update the existing installation. Choose to overwrite the previous deployment Step 6 Define the Management Server's access to the Dashboard Gateway and click Next. Define the credentials and port number for the Dashboard Gateway Field Description Gateway User / Password /Confirm Password Displays the username and password for the Dashboard Gateway. Make a note of this for when you later install the Aternity dashboard layouts on the Management Server. Gateway Port Displays the port number which the Management Server must use when it accesses the Dashboard Server. The default port is 8088. If already defined, you can preserve the existing credentials or change them as desired. Step 7 Define the credentials of a local administrator on that device and click Next. Define the local user (For upgrades from 11.0.3) Provide the credentials of a local administrator on that device and click Next. Tableau file paths are automatically discovered. You need only enter the administrator user name and password. (For upgrades from 12.0) The credentials for a local administrator on the device provided for the original setup are preserved and do not need to be updated. Step 8 Connect the Dashboard Gateway to the Dashboard Server (Tableau). The update automatically inserts the settings from the previous existing setup. Connect to the Dashboard Server (Tableau) Field Description Tableau Administrator User / Password Enter the Tableau administrator username and password which you created when you set up the Dashboard Server. Tip To avoid adding hidden characters, type these fields with the exact correct credentials. Do not paste them. Tableau Hostname Enter the hostname or IP address which users enter as their URL when accessing the dashboards directly from the Dashboard Server. This is NOT the Aternity URL. This is the direct dashboards URL. For example, dashboards.company.com Tip To avoid adding hidden characters, type this field with the exact correct address. Do not paste it. Port Enter the port for users to access the dashboards. The default is 80, but if you select Use SSL Transport, enter 443. Use SSL Transport Select if you configured the Dashboard Server so users who view the dashboards in their browsers must access via SSL (https). This setting encrypts the connection between the Dashboard Server and the Dashboard Gateway. Step 9 If prompted, restart the computer to complete the setup. If you choose not to restart when prompted, it displays the final screen which urges you to restart the computer. Start the Dashboard Gateway automatically Step 10 To verify that the Dashboard Gateway is functioning properly: a Verify there is a Windows Service called AternityTableauGateway which starts automatically. b On the Dashboard Server, go to http://localhost:8088/tableau-gateway/info.jsp If you changed the default port from 8088 to a different value, substitute it here. c Enter the Dashboard Gateway's username and password to display its settings in the browser. Verify the Dashboard Gateway is functioning Step 11 Set up the drivers on the Dashboard Server to enable connection to the Aternity Vertica Database Server, by launching the small driver setup file, data\AternityTableauGateway\vertica\VerticaSetup-<version>.exe. This standalone setup program is part of the Aternity on-premise download package, and requires .NET installed, as detailed in the prerequisites. Select Install to start the setup wizard. Select all the components (selected by default), and then select Next > Proceed. Add all Vertica driver components After the setup completes, exit the program. Step 12 Clean up log files manually on a regular basis (recommended – once a week). Tableau log cleaning does not run automatically resulting in logs building up and filling available disk space. It is important to add a scheduled task to run this command periodically: tsm maintenance cleanup -l --log-files-retention <number of days> Important Unhandled log files cleaning may cause a Tableau server corruption and malfunction. Running the tsm maintenance command requires administrator privileges. The user running this command must be a member of the administrative group on the host machine. For more information, read Tableau Help. Parent topic Upgrade to Aternity on-premise 12.1Related tasksUpdate the Aternity Oracle Database ServerUpdate the Aternity Vertica Database ServerUpdate the Aternity Dashboard ServerQuickly Update the Aternity Management ServerUpdate (Publish) Dashboard Layouts for AternityUpdate the Aternity Docker Components ServerQuickly Update Aternity Data Warehouse Server on a Dedicated ComputerQuickly Update an Aternity Aggregation Server on a Dedicated Computer
Update the Aternity Dashboard Gateway Server Update the Aternity Dashboard Gateway Server by running the setup over the existing pathname. The Dashboard Gateway acts as the interface between the Dashboard Server and the Aternity Management Server, performing background tasks like preprocessing the data for display in the dashboards, and maintaining logs, audits and cleanup. It must be on the same computer as the Dashboard Server. While it has no user interface of its own, it is crucial to the proper functioning of Aternity. The Dashboard Gateway is on the same computer as the Dashboard Server Before you begin Download the latest Aternity on-premise's main setup package from the Aternity Support Site (learn more). If you are running a version earlier than 11.0.3, update to 11.0.3 before updating to 12.1. Check the correct sizing for your deployment before updating any of your Aternity servers. Learn more. Prepare the Aternity Oracle Database Server for Aternity by verifying its configuration. Learn more. Aternity requires you set up one or more new Vertica Database Servers, depending on the size of your deployment. Learn more. (If you performed the data migration process, then your Vertica Database Server is already up and running.) (For upgrades from 11.0.3) Update the Dashboard Server by removing the previous version of Tableau and then running the setup of the new version. Learn more. To install the Dashboard Gateway, you must have on the Dashboard Server: Attribute Requirement Permissions Ensure you have local administrator privileges on this computer. Microsoft .NET Ensure this server has Microsoft .NET 3.5 (exactly) required for the database drivers, and .NET 4.5 or later, required for driver setup (both in parallel). To add .NET to a Windows Server, learn more. Time zone Synchronize all Aternity components to have the same date, time AND time zone. We recommend that an IT person define a clock synchronization service, like for example NTP, between all Aternity components. This will provide highly accurate timing for all network components and prevent clock drift. ProcedureStep 1 Access the Aternity Dashboard Server. Step 2 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 3 Locate the AternityTableauGateway_windows-x64_12.1.0.<build number> setup file, which you downloaded as part of the Aternity on-premise server setup package. Copy it to a temporary location on this computer. Step 4 Right-click the setup and select Run as administrator to begin. Step 5 Select Yes, update the existing installation. Choose to overwrite the previous deployment Step 6 Define the Management Server's access to the Dashboard Gateway and click Next. Define the credentials and port number for the Dashboard Gateway Field Description Gateway User / Password /Confirm Password Displays the username and password for the Dashboard Gateway. Make a note of this for when you later install the Aternity dashboard layouts on the Management Server. Gateway Port Displays the port number which the Management Server must use when it accesses the Dashboard Server. The default port is 8088. If already defined, you can preserve the existing credentials or change them as desired. Step 7 Define the credentials of a local administrator on that device and click Next. Define the local user (For upgrades from 11.0.3) Provide the credentials of a local administrator on that device and click Next. Tableau file paths are automatically discovered. You need only enter the administrator user name and password. (For upgrades from 12.0) The credentials for a local administrator on the device provided for the original setup are preserved and do not need to be updated. Step 8 Connect the Dashboard Gateway to the Dashboard Server (Tableau). The update automatically inserts the settings from the previous existing setup. Connect to the Dashboard Server (Tableau) Field Description Tableau Administrator User / Password Enter the Tableau administrator username and password which you created when you set up the Dashboard Server. Tip To avoid adding hidden characters, type these fields with the exact correct credentials. Do not paste them. Tableau Hostname Enter the hostname or IP address which users enter as their URL when accessing the dashboards directly from the Dashboard Server. This is NOT the Aternity URL. This is the direct dashboards URL. For example, dashboards.company.com Tip To avoid adding hidden characters, type this field with the exact correct address. Do not paste it. Port Enter the port for users to access the dashboards. The default is 80, but if you select Use SSL Transport, enter 443. Use SSL Transport Select if you configured the Dashboard Server so users who view the dashboards in their browsers must access via SSL (https). This setting encrypts the connection between the Dashboard Server and the Dashboard Gateway. Step 9 If prompted, restart the computer to complete the setup. If you choose not to restart when prompted, it displays the final screen which urges you to restart the computer. Start the Dashboard Gateway automatically Step 10 To verify that the Dashboard Gateway is functioning properly: a Verify there is a Windows Service called AternityTableauGateway which starts automatically. b On the Dashboard Server, go to http://localhost:8088/tableau-gateway/info.jsp If you changed the default port from 8088 to a different value, substitute it here. c Enter the Dashboard Gateway's username and password to display its settings in the browser. Verify the Dashboard Gateway is functioning Step 11 Set up the drivers on the Dashboard Server to enable connection to the Aternity Vertica Database Server, by launching the small driver setup file, data\AternityTableauGateway\vertica\VerticaSetup-<version>.exe. This standalone setup program is part of the Aternity on-premise download package, and requires .NET installed, as detailed in the prerequisites. Select Install to start the setup wizard. Select all the components (selected by default), and then select Next > Proceed. Add all Vertica driver components After the setup completes, exit the program. Step 12 Clean up log files manually on a regular basis (recommended – once a week). Tableau log cleaning does not run automatically resulting in logs building up and filling available disk space. It is important to add a scheduled task to run this command periodically: tsm maintenance cleanup -l --log-files-retention <number of days> Important Unhandled log files cleaning may cause a Tableau server corruption and malfunction. Running the tsm maintenance command requires administrator privileges. The user running this command must be a member of the administrative group on the host machine. For more information, read Tableau Help. Parent topic Upgrade to Aternity on-premise 12.1Related tasksUpdate the Aternity Oracle Database ServerUpdate the Aternity Vertica Database ServerUpdate the Aternity Dashboard ServerQuickly Update the Aternity Management ServerUpdate (Publish) Dashboard Layouts for AternityUpdate the Aternity Docker Components ServerQuickly Update Aternity Data Warehouse Server on a Dedicated ComputerQuickly Update an Aternity Aggregation Server on a Dedicated Computer