2. Restart the server.

Requirements:

• The table to be aggregated must have at least one CT_TIMESTAMP auto-timestamp field.
• The auto-timestamp field must be the first segment of any index on that table.

Supported field types:

• Signed integer types:
  • CT_TINYINT
  • CT_SMALLINT
  • CT_INTEGER
  • CT_BIGINT
• Unsigned integer types:
  • CT_UTINYINT
  • CT_USMALLINT
  • CT_UINTEGER
  • CT_UBIGINT
• Float types:
  • CT_SFLOAT
  • CT_EFLOAT
  • CT_DFLOAT

Configure data aggregation

1. Navigate to and open the cttimestamp.json file in the config folder (server\aggregation\ctTimeStamp.dll).
2. Observe the format of the cttimestamp.json file:

{
    "debug": false,
    "sourceTableList": [
        {
            "database": "ctreeSQL",
            "sourceTableName": "sensor",
            "aggregatedTableList": [
                {
                    "aggregatedTableName": "aggregation1",
                    "timestampFieldName": "ts",
                    "unitOfTime": "second",
                    "unitOfTimeValue": 20,
                    "aggregatedTableInSQL": true,
                    "aggregatedTableOwner": "admin",
                    "aggregatedFieldList": [
                        {
                            "aggregatedFieldName": "TempAverage",
                            "sourceFieldName": "temperature",
                            "aggregateFunction": "average"
                        }
                    ]
                }
            ]
        }
    ]
} 

3. Edit the config/services.json file. Adjust the following section to change false to true:

{
	"serviceName": "aggregation",
	"serviceLibrary": "./aggregation/cttimestamp.dll",
	"enabled": true
}

{
    "sourceTableList": [
        {
            "database": "ctreeSQL",
            "sourceTableName": "sensor",
            "aggregatedTableList": [
                {
                    "aggregatedTableName": "aggregation1",
                    "timestampField": "ts",
                    "unitOfTime": "second",
                    "unitOfTimeValue": 20,
                    "aggregatedFieldList": [
                        {
                            "aggregatedFieldName": "TempAverage",
                            "sourceFieldName": "temperature",
                            "aggregateFunction": "average"
                        },
                        {
                            "aggregatedFieldName": "PressMax",
                            "sourceFieldName": "pressure",
                            "aggregateFunction": "maximum"
                        }
                    ]
                } 
            ]
        }
    ]
}