Sensate IoT DSMR Database 1.7.0

Added

• Stored procedure DsmrApi_ComputeDeviceCapabilities
• Stored procedure DsmrApi_SelectAverageEnergyDataPerHour

Updated

• DSMR API permissions

Sensate IoT DSMR Product Database 1.6.0

Added

• Permissions for the DSMR API
• Stored procedure to compute energy usage/production

Sensate IoT DSMR Database 1.5.0

Added

• Stored procedure to group power data by hour
• Permissions to let the DSMR API execute the [DsmrApi_SelectPowerDataByHour] procedure

Updated

• DSMR API database role

Sensate IoT DSMR Database 1.4.0

Updated

• Stored procedures related to sensor mapping and processing history

Deleted

• Sensor mapping table
• Sensor mapping table stored procedures (lookup)

Sensate IoT DSMR Database 1.3.1

Added

• Sensor ID checks

Updated

• Various stored procedures, to include sensor checks
• README document
• Security document

Removed

• Code style document

Sensate IoT DSMR Database 1.3.0

Added

• Aggregate stored procedures
• Aggregation views
• DSMR API database role

Updated

• Version support policy

Sensate IoT DSMR Database 1.2.0

Added

• Tarif indicator

Updated

• File formatting
• Insertion stored procedures

Sensate IoT DSMR Database 1.1.0

Added

• Add permissions for [dbo].[DataPoint] to [db_processor]

Updated

• The service name index, removed the unique constraint

Sensate IoT DSMR Database 1.0.0

Added

• Data point table
• Sensor mapping table
• Processing history
• Various stored procedures

Updated

• Data point type mapping
• Data point indices