easy access to other databases

michael.weinberger 2 Public · Feb 2 2023

Idea Summary
I often hear developers complaining that Apex can only work with Oracle Databases. These developers have their data in MS-SQL and Prostgress and My-SQL or some other relational source. They could theoretically use Transparent Gateway to create a db-link, and some views on top. But I would really like to have some declarative option like presented with "rest data source". Something a citizen developer could create.
A declarative option to create a “relational data source” in Apex. Just like the “rest data source”. That would be great.

Use Case
Citizen Developer could easily access data from other legacy databases, 3rd party products or cheap data archives.

There would be no need for an transparent gateway administrator or 3rd party programmer who has to program a web service api for the legacy database.

Preferred Solution (Optional)
I assume, this could easily be done with a java or javascript library in the database

This idea has been closed due to the lack of community activity during the period since it was submitted.

Comments

jayson hanes Admin OP 2.6 years ago

This isn't as easy as it sounds like it should be. There's a lot to think about here. However, APEX does have the ability to work with most any other database via REST, today. APEX also can work with MySQL today:

https://www.youtube.com/watch?v=z8Xr4AZ_nIc

https://asktom.oracle.com/pls/apex/asktom.search?oh=18245

as well as https://www.youtube.com/watch?v=J4EWSfpAF2g

https://github.com/oracle/apex/tree/22.2/plugins/rest-source/odata-rest-apis

..with more coming in future APEX releases!

ps. it's Always APEX ;)
jayson hanes Admin OP 2.6 years ago

We have announced a survey for us to learn more about exactly this! While it's up, please contribute! https://surveys.oracle.com/ci/documents/detail/5/657/12/63e7fe6482653df5feacf029b33fe0f7a4fcb756
michael.weinberger 2 OP 2.6 years ago

Maybe ORDS could handle this part? I could imagine doing some ORDS configuration and ORDS would query the datasource giving back the results as a rest service.
This ORDS configuration should be done in the database or in apex, but not on the server since this will be done by citizen developers, not admins. (Admins could already use transparent gateway and create views in the Oracle shema)
michael.weinberger 2 OP 2 years ago

I just stumbled over Oracle JDBC DBLink (sourceforge.net)

This should do the trick.

3 Voters

easy access to other databases

Feature

Comments

Comments