I'm currently using Oracle SQL Developer to connect to Oracle SQL Database.

I'm having a hard time connecting power automate to the server, while I was able to do connect POWERBI to the Oracle SQL Database.

I'm using the "Open SQL Connection" action in power automate.

I am not sure which options to choose once I have opened this action "Open SQL Connection", and which parameters exactly should be entered. I have such like hostname, port, and service name of the database.

I have already tried browsing the internet for this, but not much could be found for Oracle SQL -- only other SQL databases.

Any help will be much appreciated.