Use a Copy Data activity to copy the data from Event Hub to SQL Database without any aggregation.

Use a Data Flow activity to read the data from Event Hub, aggregate it by device type and time window, and then write the aggregated data to SQL Database.

Use a Lookup activity to retrieve the device types, followed by a ForEach activity to iterate over the types and a Copy Data activity to copy the aggregated data to SQL Database.

Use a Web activity to trigger an external script that aggregates the data before copying it to SQL Database.