FactoryTalk assetcentre will have asset audit details, Log details, Disaster recovery details etc., I gone through some online downloads, but I could not find how these data can be extended to historian or other 3rd party systems.

I understood from these tutorials that FactoryTalk configuration/back-up & Audit details will be stored in SQL Database. But I am not sure whether any real time data like PLC Healthy/Instrument Healthy/Communication Healthy etc., will be stored in this database. Also I am not sure whether this SQL Database table is open to any third party integration.

Anybody have worked on this interface?.. Really appreciate if you can through some light on this integration. Need some guidance pls....

From what I can tell, the FactoryTalk AssetCentre does not store/manage/handle process data in any way nor does it have health tracking abilities, other than version control. I was able to find one of the brochure's available online here:

The installation guide also appears to be available online. Again, from what I can tell with the externally available information, the only storage location the AssetCentre has is the MS SQL database it uses. My guess, then, would be that everything it needs to store is stored here. Thus, if you can determine what the architecture within this SQL database is, then you could certainly get this data into the PI System. The PI RDBMS Interface would be ideal for this scenario. It is possible, however, that the internal structure of these SQL databases is very convoluted and was it was not the intention of Rockwell for users to query and retrieve information from within this location.

It is also entirely possible that the system supports other protocols for extracting the contained information, but I haven't been able to locate any information on that subject. Your best bet, for either using SQL queries or something else, would be to simply ask Rockwell what protocols can be used to pull data out of the FactoryTalk AssetCentre system. Once we have that information, we can determine what the best methods for getting that data into the PI System might be, the PI RDBMS interface or otherwise.

From what I can tell, the FactoryTalk AssetCentre does not store/manage/handle process data in any way nor does it have health tracking abilities, other than version control. I was able to find one of the brochure's available online here:

The installation guide also appears to be available online. Again, from what I can tell with the externally available information, the only storage location the AssetCentre has is the MS SQL database it uses. My guess, then, would be that everything it needs to store is stored here. Thus, if you can determine what the architecture within this SQL database is, then you could certainly get this data into the PI System. The PI RDBMS Interface would be ideal for this scenario. It is possible, however, that the internal structure of these SQL databases is very convoluted and was it was not the intention of Rockwell for users to query and retrieve information from within this location.

It is also entirely possible that the system supports other protocols for extracting the contained information, but I haven't been able to locate any information on that subject. Your best bet, for either using SQL queries or something else, would be to simply ask Rockwell what protocols can be used to pull data out of the FactoryTalk AssetCentre system. Once we have that information, we can determine what the best methods for getting that data into the PI System might be, the PI RDBMS interface or otherwise.