Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC connector with Starburst (Trino)

Delivered
463
Views
17
Comments
Elie Bou Lahdou
Elie Bou Lahdou Rank 2 - Community Beginner

Organization Name

Arkea

Description

Need a direct connector from OAC to Starburst(Trino).

Use case and business need

In our organization, Starburst became a central point to exchange data between data product.

Have a direct connector on OAC would allow simple access on all data under Starburst and access to analytic.

8
8 votes

Delivered · Last Updated

«1

Comments

  • Thomas HYRIEN
    Thomas HYRIEN Rank 3 - Community Apprentice

    SR 3-34620094321

  • User_GPIFO
    User_GPIFO Rank 2 - Community Beginner


    We are also in the process of utilizing Starburst semantic layer with OAC using JDC connection. Direct connector from OAC to Starburst(Trino) is helpfull.

    Can you please provide any use case document on how to connect OAC with Starburst semantic layer setup?

  • Thomas HYRIEN
    Thomas HYRIEN Rank 3 - Community Apprentice

    We successfully completed an end-to-end test between OAC and Starburst via the datagateway.

    On the other hand, the solution does not live up to our expectations. The use of the JDBC connector seems strongly restricted:

    - in terms of the complexity of the query

    - in terms of the number of columns selected

    - in terms of the number of rows returned

    We lose the interest in going through starburst. So, direct connector from OAC to Starburst(Trino) would be really helpfull.

  • User_GPIFO
    User_GPIFO Rank 2 - Community Beginner

    Hi User_98R4X

    Would it be possible to share high level implementation steps for OAC and Starburst via the datagateway?

    I was able to load Java Datasources into RPD and while importing metadata using JDBC(Direct Driver), I am getting JDS Error: 116 JDBC Connection Error


    Thank you

  • Connector for Trino is on the roadmap. No timeline at this time.

  • User_GPIFO
    User_GPIFO Rank 2 - Community Beginner

    Yes, We raised oracle service request(SR) for the same. We got the same response as no tentative time lines for the deliver of this connector

  • User_GPIFO
    User_GPIFO Rank 2 - Community Beginner

    Hi @Alan Lee - Oracle-Oracle

    We just got the SR updated! Thank you Alan for the update.

  • User_GPIFO
    User_GPIFO Rank 2 - Community Beginner

    @Alan Lee - Oracle-Oracle

    Any update on this OAC connector with Starburst (Trino) ?

  • General timeline guidance that is subject to change is early CY25.

  • Currently planned for OAC January 2025 update and OAS 2025.