Skip to main content
October 27, 2022
Question

How to create " Functions" & "Procedures" section in custom Database

  • October 27, 2022
  • 3 replies
  • 0 views

Hi,

I want to know how to create " Functions" & "Procedures" section in custom Database not the in-built APPIAN one.

We have created our own custom DB for our APP 

Using Appian 22.3

Regards

Bihitak

    3 replies

    csteward
    October 27, 2022

    If you want to build database functions and stored procedures, that is completely external to Appian.  Find some tutorials online and places like stackexchange are a great resource for specific questions.  But I don't see how you need to jump directly heavy database programming so soon after just creating your custom DB.

    Or are you referring to the "business data source", configuring it to hold your data and working within Appian?

    You mention "created a DB for our app", do you mean DB tables?  As you certainly do not need an entire database for each application..

    We will need some more details here on what you are doing to assist further.

    October 28, 2022

    Hi Chris,

    We have created something like this 

    https://docs.appian.com/suite/help/22.3/appian-cloud-database-administration.html#appianprocessviewroutinedefinition

    So my ques was how to create " Functions" & "Procedures" section in custom Database or I mean to say under custom schema like "Inventory App"

    October 28, 2022

    Click on your Custom Database, on right side you would be seeing SQL tab, click on it and run your Functions