Click here to Skip to main content
14,975,416 members
Articles / Artificial Intelligence / Machine Learning
Article
Posted 25 Mar 2015

Stats

29.3K views
7 bookmarked

Microsoft Azure + TI CC3200 LaunchPad End to End IoT Proof of Concept

Rate me:
Please Sign up or sign in to vote.
4.83/5 (4 votes)
25 Mar 2015CPOL7 min read
An end to end IoT system utilising Microsoft Azure Cloud Technology and an embedded device, the Texas Instruments CC3200 LaunchPad (Single Chip Wi-Fi MCU).

This article is an entry in our Microsoft Azure IoT Contest. Articles in this section are not required to be full articles so care should be taken when voting.

Introduction

This example provide everything you need to develop an end to end IoT system utilising Microsoft Azure Cloud Technology and an embedded device, the Texas Instruments CC3200 LaunchPad (Single Chip Wi-Fi MCU).

Included are all the components you would expect in a typical telemetry based sensor scenario. For example a wireless sensor network utilised in machine health monitoring.

The architecture allows for a hyperscaled ingestion system (millions of messages a second) that also provides near real-time streaming analytics, and machine learning capabilities.

Web Site: http://ssmlwf.azurewebsites.net/

Code: https://github.com/remixed123/IoT

Original Setup Instructions: https://github.com/remixed123/IoT/wiki (Or Below)

Architecture

IoT Architecture

Figure 1: Solution Architecture:
Color Code: Blue - Code and Steps Included. Orange - Example or Architecture Only. Grey - External Components

The above image outline the solution architecture of the end to end IoT proof of concept. Some parts are yet to be detailed in this step by step example, however all the main components from the CC3200 LaunchPad through to Event Hubs and then to Stream Analytics, with data stored in SQL Database and viewed from a Website are complete. Details on mobile services and machine learning are yet to be included.

Application Description

The CC3200 LaunchPad sends telemetry that has been created from its onboard temperature sensor, alternatively telemetry can be produced via an Azure Web Site webpage using a fake telemetry generator. The telemetry is then ingested by Azure Event Hub and processed by Azure Stream Analytics in near real time, the processed telemetry is then stored in an Azure SQL Server Table. One table stores telemetry that has just been cleaned, where as another table stores averaged temperature and humidity data, along with the data count for a 5 minute tumbling window.

Newly stored processed telemetry can be viewed as it arrives via an Azure Websites webpage. While an Azure Mobile Service sends a push notification to a Smart Phone App should certain triggers indicate that a system has failed.

A predictive model is created using Azure Machine Learning and made available as a web service. The model can be queried from an Azure Website webpage to determine whether a system requires maintenance. In future, as Azure Stream Analytics is improved, it is expected that you will be able to query predictive models via the Azure Machine Learning Web Service and hence provide near real-time predictions for many different scenarios.

Setup Steps

You will find below detailed instructions for reproducing the end to end IoT proof of concept, built on Microsoft Azure Cloud Platform and the Texas Instruments CC3200 LaunchPad development board.

View Working Example

You can view a working example at the following links.

Assumption

These instructions provide the details required to setup a reproduction of the end to end IoT example. However it is assumed that you are familiar with Microsoft Azure and the Texas Instruments CC3200 LaunchPad Developer Environments.

Setting Up The Examples

There are 2 main technologies to setup to get this example working

  • Azure Setup Step - see details below

  • CC3200 LaunchPad Setup Steps - see details below

If you are only interested in the CC3200 LaunchPad side of the example, you can use the default settings provided in the source code. This will then communicate with the Azure Cloud I have setup and you can then view the telemetry you send here to determine if your have everything working. There is also a binary provided, which you can flash the CC3200 LaunchPad with.

Further Resources

The following resources will help you learn more about Microsoft Azure and the Texas Instruments CC3200 LaunchPad.

Microsoft Azure

Texas Instruments CC3200 LaunchPad

Azure Event Hubs

Azure Stream Analytics

Azure Machine Learning

Azure Mobile Services

Azure Websites

Azure SQL Database

Azure Setup Steps

Prerequisites

Recommendations

It is preferable to setup all services at the same data center, so as to avoid incurring performance hit and data transfer charges.

Create Website

This can be performed from the Azure Management Portal or from within Visual Studio:-

Create SQL Server Tables 

Create an Azure SQL Database and then create 2 tables using the below sql statements.

SQL to Create Processed Telemetry Table

SQL
CREATE TABLE [dbo].[ProcessedTelemetry]( [MessageType] [nvarchar](50) NULL, [Temp] [float] NULL, [Humidity] [int] NULL, [Location] [nvarchar](50) NULL, [Room] [nvarchar](50) NULL, [Info] [nvarchar](100) NULL, [EventEnqueuedUtcTime] [datetime2](7) NULL )

CREATE CLUSTERED INDEX [ProcessedTelemetry] ON [dbo].[ProcessedTelemetry]([Location] ASC)

SQL to Create Averaged Telemetry Table

SQL
CREATE TABLE [dbo].[AverageTelemetry]( [ID] [int] IDENTITY(1,1) NOT NULL,[StartTime] [datetime2](7) NULL, [EndTime] [datetime2](7) NULL, [AverageTemp] [float] NULL, [AverageHumidity] [float] NULL, [LogCount] [int] NULL, CONSTRAINT [PrimaryKey_a97a20a9-3d36-4d59-82af-e5cb075a0b73] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) )

Create Event Hub

Create an event hub, making sure you create a Shared access policy with Managed, Send, Listen selected and call it EventHubPublisher.

Create Stream Analytics Jobs

Create 2 Stream Analytics' Jobs with the following Input, Query and Output.

Input

Both the inputs will be the same, they need to obtain data from the Event Hub created in the previous step.

Query

A different query is required for each job.

Processed Telemetry Job Query

SQL
SELECT EventEnqueuedUtcTime, MessageType, Location, Room, Temp, Humidity, Info FROM input1

Averaged Telemetry Job Query

SQL
SELECT DateAdd(minute,-5,System.TimeStamp) as StartTime, system.TimeStamp as EndTime, Avg(Temp) as AverageTemp, Avg(Humidity) as AverageHumidity, Count(*) as LogCount FROM input2 GROUP BY TumblingWindow(minute, 5)

Output

Both outputs will be to the appropriate SQL Table, either ProcessedTelemetry or AveragedTelemetry tables.

CC3200 Setup Steps

Prerequisites

Generate Shared Access Token 

You will need to generate a SAS Token, this can be done using one of the following methods

  • Build the Visual Studio Project that contains a Windows Form Application with C# code available from here

OR

  • Install and use the already built and published application from here

Edit main.c to reflect your Azure setup and Shared Access Token details

  1. Open the SendToEventHub project in Code Composure Studio so that you can edit source code.
  2. Change #define EH_SERVER_NAME to #define Your_EH_Server_Name
  3. Change #define POSTHEADER "POST /swiftsoftware-eh/messages HTTP/1.1\r\n" to#define POSTHEADER "POST /Your_EH_Server_Name/messages HTTP/1.1\r\n"
  4. Change #define HOSTHEADER "Host: swiftsoftware-ns.servicebus.windows.net\r\n"to #define HOSTHEADER "Host: Your_Service_Bus_Name_Space.servicebus.windows.net\r\n"
  5. Change #define AUTHHEADER "Authorization: SharedAccessSignature sr=swiftsoftware-ns.servicebus.windows.net&sig=6sIkgCiaNbK9R0XEpsKJcQ2Clv8MUMVdQfEVQP09WkM%3d&se=1733661915&skn=EventHubPublisher\r\n" to #define AUTHHEADER "Authorization: SharedAccessSignature sr=Your_Service_Bus_Name_Space.servicebus.windows.net&sig=Your_Shared_Access_Token&se=1733661915&skn=Your_Eventhub_Shared_Access_Policy\r\n"

Note: You can choose not to make any changes, and the telemetry generated by the CC3200 will be sent to my Event Hub, you can then view the Telemetry here.

Edit main.c to select a NTP Server in your geography

To create a secure TLS socket the current time is required, this is obtained from an NTP Server. It is best to use one close to your geographically. The code includes some suggestions, you can also perform an Internet search to find one in your location.

Search on "g_acSNTPserver[30]" in main.c to find where in the code the NTP Server details can be modified

Edit common.h to reflect your WiFi Router Settings

Change the defines in the common.h of the CC3200 SDK to reflect your WiFi Router settings. common.h can be found in the common example in the example folder of the CC3200 SDK.

#define SSID_NAME "YourWifiRouterSSID" /* AP SSID */

#define SECURITY_TYPE SL_SEC_TYPE_WPA /* Security type (OPEN or WEP or WPA*/

#define SECURITY_KEY "YourSecurePassword" /* Password of the secured AP */

Save the Certificate Authority on the CC3200 Flash

  1. Use the certificate authority file "azurecacert.cer" which is located here.
  2. Start UniFlash for the CC3200/CC3100
  3. In Uniflash, click the "add file" option.
  4. Name the file to /cert/azurecacert.der
  5. In the Url field browser to the location of were you have stored azurecacert.cer
  6. Select the Erase and Update check boxes
  7. Select the top of the tree (CC31x Flash Setup Control) and then press program.

Additional Assistance: UniFlash Quick Start Guide.

Note: You can download your own Certificate from a browser or from the Certificate Manager in Windows. Azure uses the Baltimore CyberTrust Root. Details on how to perform these steps can be found here, at the bottom of the page.

Trouble Shooting

You can connect via serial port and receive debug output. This is recommended should you have any issues as the debug output is quite comprehensive.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Glenn Vassallo
Engineer Self Employed
Australia Australia
Glenn Vassallo is a highly experienced technical leader, entrepreneur and consultant, with over 20 years of IT experience.

He is currently focused in the emerging field of IoT (Internet of Things) and is in the unique position of having expertise in its 4 pillars of Embedded, Mobile, Data and Cloud.

If you are working on an IoT project and would like to chat with someone with knowledge with designing and developing end to end solutions. Please feel free to connect with me via my Linkedin profile, I'd be happy to offer you some advise and answer your questions.

Comments and Discussions

 
GeneralMy vote of 5 Pin
Florian Rappl30-Mar-15 20:24
professionalFlorian Rappl30-Mar-15 20:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.