API Connect

 View Only

  • 1.  Storage Procedure Integration with API Connect

    Posted Thu December 09, 2021 06:44 AM
    Can we used stored procedures with APIC instead of direct database access? If yes please provide any reference.

    ------------------------------
    Anurag Gupta
    ------------------------------


  • 2.  RE: Storage Procedure Integration with API Connect

    Posted Fri December 10, 2021 01:31 AM

    I'm not sure where you mean.
    APIC has its own database which is internal.

    If you mean in your API backend then you might be better looking at something like AppConnect or building a microservice to access your stored procedures - something like LoopBack might help there.

    there is no native support for either stored procedures or direct db access in the api assembly in apic itself.



    ------------------------------
    Chris Dudley
    ------------------------------

    Original Message


  • 3.  RE: Storage Procedure Integration with API Connect

    Posted Fri December 10, 2021 05:20 AM
    The easiest way is to expose your stored procedure as REST API and then call it directly. There are several ways to do this depending on your Developer Framework.

    ------------------------------
    PETER BRABEC
    ------------------------------

    Original Message