Overview

Thingsboard, a leading open-source Internet of Things (IoT) platform, is used for managing devices, collecting data, and processing and visualizing your IoT projects. It aids device connectivity through industry standard IoT protocols such as MQTT, CoAP, and HTTP. It supports both cloud and on-premises deployment.

Thingsboard provides live demo instance for quick testing. Thingsboard can also be installed locally for long term projects. In this blog, let us discuss about step by step procedure for Installing Thingsboard on Windows.

Prerequisites

Download and install the following:

• Java 8 – https://www.java.com/en/download/help/download_options.xml
• Apache Cassandra – http://cassandra.apache.org/download/
• Thingsboard Service – https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-windows-1.2.3.zip

Hardware

• Windows Machine with OS version 7 and above
• Windows 32-bit and 64-bit (both are compatible) machines
• RAM 4 GB

Installing Java 8

Install Java 8 on Windows machine. If already installed, check the version of Java by using the below command:

java -version

Installing Apache Cassandra

As Apache Cassandra is needed for Thingsboard service, you need to install Apache Cassandra. In this section, let us discuss about installing Cassandra. If Cassandra is already installed, skip this step.

Installing DataStax

To install DataStax, perform the following steps:

• Download DataStax from the required link based on the Windows bit:
  • Windows (32 bit): http://downloads.datastax.com/community/datastax-community-32bit_3.0.9.msi
  • Windows (64 bit): http://downloads.datastax.com/community/datastax-community-64bit_3.0.9.msi
• Double click on the downloaded DataStax Community MSI package to RUN it.
  You will be redirected to the setup page as shown in the following diagram (1).
• Click Next to move to the End-User License Agreement page as shown in the below diagram (2) and start the installation process of DataStax Community Edition:

• Provide the path of the destination folder in the Destination Folder page as shown in the below diagram (3) and click Next.
• Check the option in Service Configuration page as shown in the below diagram (4):

You will be redirected to the installation setup completed page.

• Click Finish to close the installation window.

• On successfully installing DataStax Community Edition, open your installation package from your local machine and check Apache Cassandra related CQL Shell files and so on.

Installing Thingsboard Service

In this section, let us discuss about installing and configuring Thingsboard service.

To install Thingsboard service, perform the following steps:

• Download the Thingsboard service package using the below Thingsboard Service URL:
  https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-windows-1.2.3.zip
• On successfully downloading the service archived file, unarchive the file.
  You can get the files as shown in the below diagram:

• Open thingsboard folder.
  You can get the files as shown in the below diagram:

• Open Windows PC administrator command prompt by searching cmd and clicking “Ctrl + Shift + Enter” keys.
• Enter the below command to install the Windows batch file:

install.bat

Now, Thingsboard has been successfully installed on your Windows machine.

Provisioning Database Schema

To provision database schema, perform the following steps:

• Open Apache Cassandra installation file from your location machine.
• Execute 3 cqslh scripts as shown in the below diagram using “Cassandra CQL Shell“:

• Execute the below list of queries one by one:
  • cqlsh> source ‘c:\thingsboard\data\schema.cql’;
  • cqlsh> source ‘c:\thingsboard\data\system-data.cql’;
  • cqlsh> source ‘c:\thingsboard\data\demo-data.cql’;

Starting Thingsboard Service

To start Thingsboard service, perform the following steps:

• Click Windows Start button.
• Search cmd and click “Ctrl + Shift + Enter” keys to execute administrator command prompt.
• Use the below command to start the Thingsboard service:

net start thingsboard

Note: To stop and restart the Thingsboard services, use the below commands:

Stop – net stop thingsboard
 Start – net start thingsboard

• Browse your default localhost (http://localhost:8080/) with port number on your browser.
  You will be redirected to the below Thingsboard local Windows machine sign in page as shown in the below diagram:

• Sign in to start accessing Thingsboard.

Conclusion

In this blog, we discussed about installation of the leading IoT open source cloud platform – Thingsboard on local Windows machine. In the upcoming blogs, let us discuss about configuring external access to Thingsboard webUI with some device connectivity to use communication protocols with some complex use cases. To know about installing Thingsboard IoT gateway on Windows, refer our blog on Thingsboard Gateway IoT.

References

Getting Started: https://thingsboard.io/docs/getting-started-guides/helloworld/