Skip to Content

Internet of Things (IoT) Check your data

Previous

Internet of Things (IoT) Check your data

By Craig Cmehil

Part 4 of 10, Check your SAP HANA tables for the newly added data

You will learn

Checking the data you have inserted is simple. in this section you will view the data in the catalog and work with a few SQL queries.

Details


  1. Launch the Catalog by clicking the Link button in the editor and choosing Catalog which will open a new window.

    Catalog selection

  2. This window will show all the SCHEMAS for which your user has access. Unroll the Catalog folder, unroll the folder with your name (e.g. JOHNDOE, then Tables.

    Tables

  3. From there right-click and select Open Content which will display the data you have inserted via Postman.

    Open Content

  4. Depending on how many POSTs you sent, your screen will look similar to this:

    Display Content

  5. When you selected Open Content, the system executed the following SQL command to display the data:
    SELECT TOP 1000
    "ID",
    "TIMESTAMP",
    "TEMPERATURE",
    "HUMIDITY",
    "BRIGHTNESS"
    FROM "JOHNDOE"."CODEJAMMER.johndoe.myiot::mydata.Data";
    
    To view the SQL window, click the Edit SQL statement button.
    SQL console
  6. To see how many records there are (handy for later), you can modify the SQL to something like:

    sql SELECT count(*) FROM "JOHNDOE"."CODEJAMMER.johndoe.myiot::mydata.Data";
    Which will show these results:

    results


You’ll only have as many records in there as you added with Postman, but after you insert data directly from the Tessel, you can return to this and section and check again.

Next Steps

Updated 05/12/2016

Time to Complete

10 Min.

Beginner

Tags

Next
Back to top