We are in the process of streamlining the SAS GRID components validation using some test cases as post validation step to ensure that the components like SAS/Access to ODBC , Redshift , PC File server are working as expected.
Advice how can this be achieved.
we think on the use of deployment tester, but we aren't clear on the limitations and how to add custom statements in the tables.
The components you list are related to data access. Seems like you could accomplish this validation by submitting a corresponding SAS job you construct which includes statements to access these data sources. Such a job can be submitted to your SAS Grid using SASGSUB, and scheduled to run periodically if you want to continuously validate your environment.
Deployment Tester is a general-purpose utility to validate a SAS deployment, and extensible through writing OQ tests. But you may not want to go to that much trouble, including ensuring that the Deployment Tester infrastructure is installed on all machines you're trying to validate.