Hello, my company subscribes to MindStudio Pro. We are working on a MindStudio project where we would like to give the workflow access to a PostgreSQL database server that runs on our infrastructure. We are an I.T. company. The PostgreSQL server in question is actually a read only replica of another production PostgreSQL server. We have a DMZ proxy server that accepts requests at a domain and proxies the requests to the PostgreSQL replica. I have verified that the replica is reachable from the wider internet.
In our test MindStudio agent I have a Query SQL Database block. That block has the option to set the parameters needed for connecting to a database. It asks for host, port, database, user, password, etc. When I put all of the details in and press continue MindStudio pops up a red dialog that says Access to these database systems is not permitted.
Is it possible to connect our MindStudio agent to a PostgreSQL database that we host?