Installation Guide

Overview

This guide describes how to install RAMP DCIM. The primary audience is IT professionals who are experienced in setting up and configuring Windows Server environments. From a high level, the following tasks are involved in the RAMP DCIM installation process:

  1. Make sure that you meet the prerequisites.
  2. Install Microsoft Windows Server (2012 R2 or later) and IIS (7.0 or later).
  3. Install Microsoft SQL Server or SQL Server Express (2014 or later).
  4. Install RAMP DCIM Application Manager.
  5. Install RAMP DCIM Images.
  6. Install RAMP DCIM Data Collectors.
  7. Perform post-installation steps.

What is RAMP DCIM?

RAMP DCIM is a next generation Data Center Infrastructure Management solution designed to provide a superior monitoring, capacity planning, and administration experience. It has the following components:

  • RAMP DCIM Application Manager (‘DCIM Manager’): Communicates with RAMP DCIM Data Collectors to collect data center information, and lets users interact with the information using a GUI and relevant APIs.
  • RAMP DCIM Data Collector (‘Data Collector’): Collects configuration and sensor data from servers, network devices, rack PDUs/RPPs and other devices.
  • RAMP DCIM Data Analyzer (‘Data Analyzer’): performs various analysis services and serves as a task scheduler for configured and ad-hoc analysis tasks. Services performed include; time-series sensor data management, power aggregations, logical group aggregations and many other tasks.

Each RAMP DCIM instance consists of one DCIM Manager, one Data Analyzer, and one or more Data Collectors. All three components can be installed on the same physical or virtual server, provided the server has sufficient resources. Real-world configurations will typically involve many different servers spread across on-premises, cloud, or hybrid deployments.

Prerequisites

License and access requirements

Before you proceed, go to the Tuangru contact page to send us a message expressing your interest in RAMP DCIM. We will review your request, and email you:

  • Login credentials for Tuangru Downloads, from where you can download installers; and
  • A license key for RAMP DCIM, which you need to run the application.

Hardware and software requirements

The following table describes hardware and software requirements for RAMP DCIM components.

Tip

If you have less than 1000 assets and are not particularly concerned about data retention, you can install Microsoft SQL Server Express Edition 2014 or later. Unlike the Standard and Enterprise editions, SQL Server Express is free (refer to the product’s license information for details).

Ramp Hardware Requirements (Excludes operating systems and any other software):

  RAM (GB) CPU cores STORAGE (GB) NOTES

RAMP

Manager

16 8 60

Large (greater-than 5,000 assets) networks.

One or more Data Collectors on separate servers.

Database 16 4 120
Data Collector 4 2 20
         

RAMP Manager

Database

16 8 60

Medium-sized (less-than 5,000 assets) networks.

One or more Data Collectors on separate servers.

Data Collector 4 2 20
         

RAMP Manager

Database

Data Collector

12 6 80

Small-sized (under 1,000 assets) networks.

All RAMP software components installed on same server.

Trials, Proof-of-Concept or Evaluations.

Notes: - Our recommendation is to configure no more than 1,000 devices per Data Collector. - Minimum supported screen resolution is 1280x800 pixels. - SSD based storage is recommended for the Database and RAMP Manager.

Network requirements

To auto-discover devices, Data Collectors require access to the following network ports:

Protocol Ports Credential requirements
SNMP 161 and 162 Community string or user/password
Modbus/TCP 502 Not required
BACnet/IP 87808 or UDP Not required
IPMI 623 and 1900 User/password
iLO 623 User/password
SSH 22 User/password or user/key
WMI 135 User/password
VMware 883 User/password

Windows Server and IIS installation

The following subsections are intended to help Tuangru customers quickly set up Microsoft Windows Server 2012 R2 and IIS 8.5. Steps to install later versions of these products are quite similar and therefore not covered separately. For detailed documentation on Windows Server and IIS, see Microsoft Docs.

To install Windows Server 2012 R2

  1. Insert the Windows Server 2012 R2 setup disk in your DVD-ROM, or launch the .iso file in your preferred virtualization software.
  2. In the Windows Setup screen, accept or update the default values for the following fields, then click Next:
    • Language to install
    • Time and currency format
    • Keyboard or input method
os_1
  1. Click Install now. The screen will say “Setup is starting”.
  2. Enter the Windows Server product key and click Next. You will not be prompted for the product key if you are installing an evaluation copy.
  3. Select Windows Server 2012 R2 Standard (Server with a GUI) as the operating system you want to install, then click Next. Note that if you are installing an evaluation copy, the product name will include “Evaluation”.
os_3
  1. Select I accept the license terms and click Next.
  2. Click Custom: Install Windows only (advanced).
os_4
  1. Select the hard drive where you want to install Windows Server and click Next. If you cannot find the drive on your network, click Load driver, and follow the instructions.
os_5
  1. The installer will start copying files. Your computer may reboot several times during the installation.
  2. Enter and re-enter a password for the default Administrator account, and click Finish.
os_7
  1. Enter the Administrator password to log into Windows Server.
  2. The Server Manager will load automatically. If a Network prompt appears in the right pane, click Yes to be able to find other computers and devices on your network.
os_8

Important

The rest of this document assumes that you are logged into Windows Server as an Administator or have Administrator privileges.

To set up Internet Information Services (IIS) 8.5

RAMP DCIM requires IIS 7.0 or later to run. Windows Server 2012 R2 includes IIS 8.5, but it is not installed by default. The following steps describe how to install IIS using Windows PowerShell. If you cannot run PowerShell for some reason, or prefer a GUI-driven approach, see Appendix I: Manually configuring IIS.

  1. Open Windows PowerShell or Windows PowerShell ISE.
  2. Run each of the following commands; a warning will appear if you do not have Windows Update enabled:
Install-WindowsFeature Web-Server
Install-WindowsFeature Web-Asp-Net45
Install-WindowsFeature Web-Windows-Auth

Following the installation, review the Server Manager dashboard to make sure there are no warnings or errors. Certain services may need to be started manually. Open http://localhost in a web browser to verify that IIS has been set up correctly (a welcome screen will appear).

ps_1

iis_10

SQL Server installation

The section is intended to help you quickly download and install Microsoft SQL Server 2017 Express Edition and SQL Server Management Studio (SSMS) 2017. Steps to install other Server Server editions and versions are quite similar, and therefore not covered separately. For detailed SQL Server and SSMS documentation go to Microsoft Docs.

To install SQL Server 2017 Express Edition

  1. Download SQL Server 2017 Express Edition from the Microsoft product page.
  2. Double-click the installer.
  3. Click the Custom tile.
ssee_1
  1. Click Install to start downloading SQL Server media to the default location, or browse to a different location before installing.
ssee_2
  1. SQL Server Installation Center will open. Click New SQL Server stand-alone installation or….
ssee_4
  1. Select I accept the license terms and click Next.
  2. Select Use Microsoft Update to check for updates (recommended) and click Next.
  3. Review Install Rules (you can click on Status links for more information), then click Next.
ssee_7
  1. At Feature Selection, under Shared Features select LocalDB, then click Next. Note that you can change the SQL Server instance and shared features directory paths if desired.
ssee_8
  1. At Instance Configuration, select Default instance and click Next.
ssee_9
  1. At Server Configuration, click the Collation tab and confirm that the database engine value is SQL_Latin1_General_CP1_CI_AS, then click Next.
ssee_10
  1. At Database Engine Configuration, select Mixed Mode (SQL Server authentication and Windows authentication), then enter and re-enter a password for the SQL Server system administrator account, and then click Next. Note that you can add additional administrator accounts if desired.
ssee_11
  1. Click Accept to consent to installing Microsoft R Open, then click Next.
  2. Click Accept to consent to installing Python, then click Next. The installation starts.
  3. Click OK in the “Computer restart required” pop-up.
ssee_15
  1. Click Close when the installation is complete.
ssee_16
  1. Restart Windows Server.

Following the installation, make sure that you have addressed any Install Rules issues (such as Windows Firewall warnings) that were surfaced at step 8. Additionally, restart Windows Server if you received an alert in step 16, or while addressing Install Rules issues. Proceed to install SQL Server Management Studio.

To install SQL Server Management Studio (SSMS) 17.x

  1. Open SQL Server 2017 Installation Center.
ssee_4
  1. Click SQL Server Management Tools. A relevant page will open in your default web browser.
  2. Click the Download SQL Server Management Studio 17.x link to download the latest SSMS installer, where “17.x” is the latest version of SQL Server Management Studio.
  3. Double-click the installer, then click Install.

Note the next two screenshots are from the installation of SSMS 17.4; your screenshots may differ depending on the version of SSMS being installed.

ssms_1
  1. Click Restart.
ssms_3

Following the installation, review the Server Manager dashboard to make sure there are no warnings or errors. Certain services may need to be started manually.

DCIM Manager installation

Once you have installed Windows Server, IIS, and SQL Server (or SQL Server Express), proceed to download and install the DCIM Manager. The installation process will also cover product configuration.

  1. Go to Tuangru Downloads.
  2. Go to public/RAMP/Current/installers.
  3. Click manager-xxxxx.zip to download the installer, where “xxxxx” represents the current DCIM Manager version number.
  4. Unzip the file and double-click Setup.exe to launch the Manager Setup utility.
  5. Click Accept to accept the terms of the EULA.
  6. If .NET Framework 4.5 or 4.5.x cannot be found on your system, you will be prompted to install it. Proceed to install .NET using default settings.
  7. Click Next to start RAMP DCIM Manager Setup.
manager_1
  1. Read and accept the terms of the EULA by selecting I accept… then click Next.
manager_2
  1. Choose a different installation folder, or click Next to accept the default location.
manager_3
  1. Click Install.
manager_4
  1. Click Finish to complete the installation. The RAMP Configuration Tool will automatically run.
manager_6
  1. Click Next to start the RAMP DCIM Configuration Tool.
manager_7
  1. At Application Identity, provide login credentials for the account that will be used by RAMP DCIM Windows Services. Available identity types are:
    • Local System (recommended)
    • Domain Account, which will use a Windows Domain Account with server admin privileges.
manager_8
  1. At Database Setup, select either of the following setup methods:
    • Automatically create database (recommended for new installations)
    • Setup database separately (required if you are retaining an existing database, for example if you are upgrading RAMP DCIM)
manager_9

Tip

If you selected Setup database separately, click Get Files to browse to ReadMe-en.txt, which contains relevant information.

  1. At Generate Database Setup Information, provide values for:
    • Server: Specify the SQL Server server instance by doing one of the following:
      • Provide . if SQL Server is running on the same Windows Server as DCIM Manager.
      • Provide the name of the Windows Server that is running SQL Server if SQL Server and DCIM Manager are not running from the same server.
      • If a named SQL Server instance has not been defined, provide it in WindowsServerName\SQLServerInstance or WindowsServerName\SQLServerInstance,PortNumber format, such as db01\SQLServer or db01\SQLServerExpress,15422.
      • If you are upgrading RAMP DCIM, provide the exact Data Source value noted in your Web.config file.
    • Database Name: Enter a name for the database. If you are upgrading RAMP DCIM, the database name must match the Initial Catalog value noted in your Web.config file. For example: ramp.
    • Runtime connection credentials: Select one of the following options:
      • Windows Authentication will use a Windows Domain Account.
      • SQL Authentication using automatically created user will auto-generate a local SQL Server user. This is the recommended option for new installations.
      • If you use this option on an instance where RAMP was previously installed, you may need to first remove the “RAMP” user from SQL under Security -> Logins.
      • SQL Authentication will create a SQL Server user using a username and password you have provided.
    • Credentials for creating database: Select either of the following options:
      • Windows Authentication will use a Windows Domain Account. If this is selected, the user must be an Administrator with SQL Server read/write permissions.
      • SQL Authentication will use a local SQL Server user. You will have to provide the username and password. The user must have the dbcreator and securityadmin roles in SQL Server. If you are upgrading RAMP DCIM, the username and password values must match the User and Password values noted in your Web.config file.
manager_10

Tip

By default the Web.config file is located at C:\Program Files\Tuangru\Web\api.

Important

For runtime connection credentials, the Windows Authentication option will only work if you selected Mixed Mode authentication during SQL Server installation. Do not select the SQL Authentication option unless guided by Tuangru Support.

For the installer to work, the ‘ramp’ user in the database server must be removed first. This is not necessary for a first time installation.

  1. Under Confirm, click Next to apply settings.
  2. Click Finish to complete the installation.
manager_13

DCIM Images installation

The Images installer includes all the virtual images used by RAMP DCIM, such as for default device configurations. Images must be installed on the same server running the DCIM Manager.

  1. Go to Tuangru Downloads.
  2. Go to public/RAMP/Current/installers.
  3. Click Images.msi to download the installer.
  4. Run the Images installer. The installer will automatically exit once it has finished running.
images_1

DCIM Data Collector installation

This installation must be performed on every Data Collector server. For example, if your company has data centers in Vancouver, Seattle, and Tokyo, and you decide to deploy a Data Collector in each site, then you will install Data Collector on a server in each of those three locations.

  1. Go to Tuangru Downloads.

  2. Go to public/RAMP/Current/installers.

  3. Click dataCollector-xxxxx.zip (the “xxxxx” represents the current Data Collector version number) to download the installer.

  4. Unzip the file and double-click setup.exe to launch the Manager Setup utility.

  5. Depending on your setup environment, you may get a prompt to install Visual C++ 2015 Runtime Libraries and WinPCap. If you do:

    1. Click Install.
    2. Click Next to set up WinPCap 4.1.3.

data_collector_2

  1. Click I Agree to accept the license terms.
  2. Select Automatically start… and click Next.
  3. Click Finish to complete the installation.
  1. Click Next to start RAMP DCIM Data Collector Setup.
data_collector_6
  1. Read and accept the terms of the EULA by selecting I accept…, then click Next.
data_collector_7
  1. Choose a different installation folder, or click Next to accept the default location.
data_collector_8
  1. Click Install to start the installation.
data_collector_9
  1. Enter the API URL and click Register. The API URL is the endpoint where Data Collectors will send data. If the Data Collector is being installed on the same server as the DCIM Manager, provide http://localhost/api. If the DCIM Manager is on a different server:
  • http://DcimManagerServerName/api, such as http://MANAG01275/api
  • http://DcimManagerIpAddress/api, such as http://172.217.25.78/api

data_collector_10

  1. Click Finish to complete the installation.
data_collector_11
  1. Confirm Services are Enabled/Disabled

Once the install is complete, go into Windows Services (services.msc) and confirm the Ramp SNMP service is running and set to start automatically. You’ll see below that windows also has SNMP and SNMP trap services. Make sure those are set to manual or disabled.

Windows and RAMP SNMP services cannot run simultaneously as they use the same ports.

Providing a Custom BACnet Device ID for RAMP

Through the Data Collector Configuration Tool you may set a custom device ID which will be used to identify the RAMP Data Collector using the BACnet protocol. If you do not use a custom value the RAMP Data Collector will still be identifiable using the BACnet protocol, however a default device ID will be used.

To set a custom device ID:

  1. Open the Data Collector Configuration tool and click on “Advanced” to show the Advanced Menu

data_collector_config_1

  1. Click the “Use Custom BACnet Server Device ID” checkbox

data_collector_config_2

  1. Enter the desired BACnet Server Device ID and click “Register”

Post-installation steps

After you have completed installing the RAMP DCIM components, you will need to apply the license key and verify that the product has been set up correctly.

To apply the license key

  1. Open the DCIM Manager by going to http://localhost (if you are on the DCIM Manager server) or its IP address (if you are accessing the server remotely).
  2. Enter admin and ramp as the username and password values, respectively, then click Login.
login_1
  1. Enter the license key you received via email from support@tuangru.com and click OK.
  2. Re-login into the application using the same credentials. The default screen for the application opens.
default_screen_1

To verify the installation

  • In the DCIM Manager, click Settings (the gear icon), then RAMP Services Status. Verify that the Data Collector and Data Analyzer entries have green checkmarks.

    agent_status_1

  • In SQL Server Management Studio, and expand Databases in the Object Manager. Verify that the database name you provided while installing the DCIM Manager (refer to step 15 of DCIM Manager installation) is listed.

    verify_db_1

Make sure Net Core was installed

-In the Windows Control Panel under “Programs/Programs and Features”, check to make sure RAMP installed the correct .NET Framework.

-If you do not see Microsoft .NET Framework 4.5 (or later) packages, there is an executable in the manager download file under “DotNetFX45”. Running this will install the correct framework version for Ramp.

Appendix I: Manually configuring IIS

  1. Open Server Manager.
  2. Click Add roles and features from the welcome banner. (Alternatively, click Manage in the top-right corner, then click Add Roles and Features.)
  3. At the Before You Begin screen, me, select Skip this page by default if desired. Click Next.
  4. At Installation Type, select Role-based or feature-based installation and click Next.
iis_1
  1. At Server Selection, choose Select a server from the server pool, click on the intended Windows Server from the list, and click Next.
iis_2
  1. At Server Roles, select Web Server (IIS), click Add Features in the pop-up box, then click Next.
iis_3
  1. At Features, click Next (the default selections are sufficient).
iis_5
  1. At Web Server Role (IIS), click Next.
iis_6
  1. At Role Services under Web Server Role (IIS), select the following role services table, then click Next. Note that selecting additional role services could result in installation errors or RAMP DCIM runtime errors. Selecting some services may open a pop-up where you have to click Add Features.
    • Under Web Server > Common HTTP Features, select:
      • Default Document
      • Directory Browsing
      • HTTP Errors
      • Static Content
    • Under Health and Diagnostics (Optional), select:
      • HTTP Logging
      • Logging Tools
      • Request Monitor
      • Tracing.
    • Under Performance, select:
      • Static Content Compression
    • Under Security, select:
      • Basic Authentication
      • Windows Authentication
      • Request Filtering
    • Under Application Development, select:
      • .NET Extensibility 3.5
      • .NET Extensibility 4.5
      • Application Initialization
      • ASP.NET 3.5
      • ASP.NET 4.5
      • ISAPI Extensions
      • ISAPI Filters
      • WebSocket Protocol
    • Under Management Tools, select:
      • IIS Management Console
      • IIS Management Scripts and Tools
      • Management Service
      • IIS 6 Management Compatibility and:
        • IIS 6 Metabase Compatibility
        • IIS 6 WMI Compatibility
        • IIS 6 Scripting Tools
        • IIS 6 Management Console
iis_7
  1. At Confirmation, select Restart the destination server automatically if required (optional), and click Install to start the installation.

Tip

You might get a warning about some missing source files. In that case, download the installers for the source files in question, and click Specify an alternate source path to point to the download folder. Alternatively, use Windows Update to download and install the source files.

  1. Click Close to complete the installation.

Following the installation, review the Server Manager dashboard to make sure there are no warnings or errors. Certain services may need to be started manually. Go to http://localhost in a web browser to verify that IIS has been set up correctly (a welcome screen will appear).

iis_10