I have tried accesing data from a schema in remote database(pgsql) using the Select the Access data from an existing table or an SQL view option.
The schema/view got successfully generated in adobe campaign console. But while trying to view data by clicking on the data tab of the schema, an error message pops up. PFB the screenshot.
The user i have logged in is an admin user of the adobe campaign. Please provide pointers to solve this issue.
Possibly related to the access level of the DB account being used (ie the one that is set up in the external DB that ACC uses to access it).
Moved to Adobe Campaign Classic