question about custom properties in ETL

DCIM_Support · ‎2020-07-03

Dear Expert,

In one of our project, through ETL, temperature, humidity & power measurements are stored in 'device' in property, and any measurements which is not temperature, humidity & power are stored as custom property. We have observed that, while we associate 2 devices onto one object, in ‘device’, we can see all measurements, but in custom property, we can only see property from 1 device.

This question is proposed is because for certain objects, like PDU(with multiple power meters) & battery group(with multiple batteries), we will need to associate multiple devices onto them, and in custom properties, we can see values only from one of its device. For PDU, in customer properties, we can only see values from one power meter; for battery group, we can only see values from one battery.

Based on that, we have several questions and need your help:

Is this normal for ETL? Could we display custom properties from all devices?
As a workaround, is it able for us to delete all custom properties for certain objects (like battery group) in DCO? Could we configure the custom property content in DCO?

Best Regards,

Ziqiang

DCIM_Support · ‎2020-07-03

Hi Ziqiang,

I have seen that by associating two etl objects (containing custom property settings) on a single model in DCO, it may add both custom property sets to the model. But not sure if that is expected or if it should depend on the ETL transformation (as you know, it is usually customized).

In general it is possible to modify custom properties settings in DCO, for details please see the following page: Custom properties

However, if your "etl object" properties should need to be modified/corrected, then perhaps it might make sense to make the corrections before the etl transformation (and you might want to discuss this with the team that have build the ETL for you), thanks.

Kind regards

See Answer In Context

DCIM_Support · ‎2020-07-03

Hi Ziqiang,

I have seen that by associating two etl objects (containing custom property settings) on a single model in DCO, it may add both custom property sets to the model. But not sure if that is expected or if it should depend on the ETL transformation (as you know, it is usually customized).

In general it is possible to modify custom properties settings in DCO, for details please see the following page: Custom properties

However, if your "etl object" properties should need to be modified/corrected, then perhaps it might make sense to make the corrections before the etl transformation (and you might want to discuss this with the team that have build the ETL for you), thanks.

Kind regards

DCIM_Support · ‎2020-07-03

Hi Ziqiang

How did you go resolving this issue?

Thanks

Ed

DCIM_Support · ‎2020-07-03

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.