Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Athena Data through Oracle apex

Jegor WielerOct 13 2023

Hi everyone,

The data that I need for my Oracle Apex-Application is stored in the AWS-S3 bucket.
Is it possible to query the Athena data via Apex and provide them for my application?
Does anyone have experience to query Athena data with apex? (Is something like a DB-Link possible?, Is it nessecary to set up an orale AWS RDS?)

The AWS REST API service (API gateway) is not an option because my data volumes are too large.
Furthermore, I'm currently using Python (Boto3) to start a query in Athena and write it into my Oracle database afterwards.
But I want to query the Athena Data live through my Apex Application.

Is there a possibility to improve the process?

Kind Regards

Ilyas

This post has been answered by jariola on Oct 13 2023
Jump to Answer
Comments
Post Details
Added on Oct 13 2023
1 comment
627 views