You can connect to a secondary database from Mendix Cloud using database connector ( https://docs.mendix.com/appstore/connectors/database-connector ) . However you can’t replace the primary database with an onprem database. The primary database is located near the application runtime for minimal latency.
What is your use case?