Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Is it possible to trigger a procedure from OAC Dataflow?

Received Response
57
Views
2
Comments
Jahnavi-Oracle
Jahnavi-Oracle Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Can we trigger a package or a procedure in database via DV Data-flow. If anyone has tried it, or if anyone know if it is even possible, please let me know.

Tagged:

Answers

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @Jahnavi-Oracle ,

    afaik it's not possible to trigger a package or a procedure directly in a data flow.

    Which kind of transformations are you trying to apply with the package/procedure? Can you replicate them by using ootb steps in the data flow?

    If the ootb steps are not enough to satisfy your requirements, you can always use a custom scripts/OCI functions to implement your own transformations (and in theory call any package/procedure)

  • Jahnavi-Oracle
    Jahnavi-Oracle Rank 6 - Analytics Lead

    Thank you for the response @Federico Venturin .

    I will check on these options.