Querying Ignition Historian from SSRS

[Aron_Grzywaczewski]

Hi,

My understanding of the Ignition Historian is that it creates multiple data partitions in the Historian database for better performance.
Is there an easy way of querying the historian data from SSRS like there is in the Ignition SCADA reporting system?
e.g. querying against one table and without worrying about all the other tables and their relation.

Is there a historian adapter for external interfaces?

[pturmel]

@Aron_Grzywaczewski

multiple data partitions in the Historian database for better performance

No, the partitions are time-based for easy pruning of old data (when enabled).

@Aron_Grzywaczewski

Is there a historian adapter for external interfaces?

No, but the schema is in the docs. Since there's no guarantee that the schema won't change at some point, it is strongly recommended you use Ignition's scripting API for historian queries. If you need external access, consider deploying a web API with the WebDev module.