Azure provides multiple types of storage for storing messages from IoT devices. These storage accounts include storing relational data, schema less NoSQL data, and blobs:
- SQL database: SQL database provides storing relational data, JSON, and XML documents. It provides rich SQL query language and it uses a full blown SQL server as a service. Data from devices can be stored in SQL databases if data is well defined and expectation is that the schema will not undergo changes frequently.
- Azure storage: Azure storage provides table and blob storage. Table storage helps in storing data as entities where schema is not important. It is an implementation of NoSQL databases. Blobs help in storing files in containers as blobs.
- CosmosDB/DocumentDB ...