Read only access to the Automic SaaS Database

Products

• Automic SaaS

Issue/Introduction

Is there a way to access the Automic SaaS database?  Something like an automic-ro user?

Environment

AE System Type: SaaS

Resolution

There is no read only user access given to the Automic SaaS database.  With 24.2.0 and above, SQLI variables can be used to query the database.  Information from the database can be gathered (read) using SQLI variables and then write these out to another database, flat file, or to something like an external REST API/application, etc... using custom tasks.