Collections

Introduction

The ClearBlade IoT platform allows for storing different types of data in your IoT solution through Collections. Each collection is available for users and devices to access via Console, Portals, APIs and SDKs.

Within the context of the ClearBlade IoT Platform, a Collection is synonymous with a Database, and will be used extensively across the documentation.

To get a holistic view of collections, we categorize them into following sections:

For the collection management tutorial, click here

Purpose

ClearBlade Collections provide a single interface for interacting with several different types of databases.

Queries

See ClearBlade Platform SDK for Collection API

Collection Types

Cloud

ClearBlade provides a default cloud collection, which is backed by a Postgresql instance. These collections are able to be completely manipulated by the platform in terms of their schema, and the data put into them.

Connection

The Connection type allows the platform developer to integrate existing databases with their IoT Platform application.

  • MySQL
  • PostgreSQL
  • MongoDB
  • Oracle
  • DB2_Linux
  • DB2_zOS
  • DB2_System_i
  • Microsoft_SQL_Server
  • Cassandra
  • CouchDB

To request integrations, please create a ticket at Support

The following is required to configure a Connection:

Field Description Example
Database Type DB Application Type MySQL
IP Address URL of database mydb.databases.com
Port port number on which the application is running 5432
Database Name Name of Database dbname
Connection Name string example
Table Name string sensor_data
Username string admin
Password string zrHcnzpBenHSOIq0uK/og8R