Hi Soul,

Did you check out the docs on Mendix explaining how you can connect to Amazon RDS and execute a query? https://docs.mendix.com/appstore/connectors/aws/amazon-rds-database-connector/

This together with the docs for the Mendix Database Connector https://docs.mendix.com/howto/integration/execute-an-sql-statement-on-an-external-database/ will explain how you can map this to a non-persistent entity.

So using the Execute Query action with the SELECT statement should allow you to choose a non-persistent entity as return value that contains the attributes you get from your Amazon RDS database.