ADS and ADX Application Tables - Metasys - LIT-1201525 - MS-ADS05U - MS-ADX10SQL - MS-ADX10U - MS-ADX25SQL - MS-ADX50SQL2 - MS-ADX50U - MS-ADXS25U - Server - ADS Server - ADX Server - 12.0.50

Application and Data Server (ADS) and Extended Application and Data Server (ADX) Product Bulletin

Product name
ADS Server
ADX Server
Document type
Product Bulletin
Document number
LIT-1201525
Version
12.0.50
Revision date
2023-05-22
Product status
Active
Table 1. Data Access Ability on an ADS and ADX

Characteristic

ADS

ADX

Questions to Ask

Before Archiving Data

Standard Reports

Yes
  • Trend Studies
  • Export Utility
Yes
  • Trend Studies
  • Export Utility
  • Metasys Advanced Reporting system
Which kind of standard reporting do you need?
  • If you need only historical values for selected points, install an ADS.
  • If you need historical point values, offline conditions, audits, events, and more, install an ADX with the Metasys Advanced Reporting system.

Custom Reports

Yes - with Third-Party Tools

Various third-party tools

Yes - with Third-Party Tools

Various third-party tools

Do you need custom reporting?
  • If you do not need custom reporting, install an ADS.
  • If you need custom reporting, install an ADX and plan for any necessary expert help to create and interpret custom reports using third-party tools.

After Archiving Data

Merging of Archives for Data Access and Reporting

Yes - with Third-Party Tools

Various third-party tools

Yes - with Third-Party Tools
  • SQL Server software
  • Microsoft Reports software
Do you need to access or query data from more than one archive at a time?
  • If you would like to access data from each archive separately, install an ADS.
  • If you would like to access data from several archives or all your archives, use third-party tools to merge the archives, install an ADX, and query the complete merged archive file. Plan for any necessary expert help.