Oracle DB on a different server

This is a quite common question, and you can find answers in any of below topics. With regard to your other options - using SQL Developer seems like an overly complicated approach. Sure, you can use Desktop Automation to open SQL Developer, and then create and maintain your databases here - but why would you? UiPath allows you to execute any query against your database, and this covers creation of databases, maintaining users, assigning permissions, and much more.