Start Connecting with Database Stored Procedures

Last updated Tue Jun 14 2022

Begin your journey with calling database stored procedures, which include:

    • Quick steps for configuring the Database Connector to connect to Azure: MS SQL Server
    • Methods for importing functions to declare parameters and profile fields
    • Methods for displaying results with Message Shape

Overview:

Use this solution to call a database stored procedure from an AtomSphere process. This is made accessible to obtain depending on your business need. In order to successfully retrieve desired results, two paths are presented in this solution to determine which route values should take.

This solution offers great value by offering zero limitations when connecting to a particular database. In this example, the database connects to Azure: Microsoft SQL Server. As a result, users can obtain and execute stored procedures from any database at their leisure.

The example process demonstrates how to call a database stored procedure from an AtomSphere process. In the first branch, functions are imported to define an input parameter. In the second branch, the imported functions are used to define profile fields. These values are passed to the Database Connector, which is configured to connect to Azure’s Microsoft SQL Server. Lastly, the Message Shape displays the results.

The recipe qualifies for Boomi’s Recipe Program.

Qualifying customers get access to Boomi’s Recipe Program* with the purchase of a Boomi subscription. As part of the Recipe Program you have direct access to a Boomi specialist to get you up and running with Boomi at no additional cost. Learn more

*Offer applies only to new customers and requires purchase of a qualifying Boomi subscription.

Related Solutions

Recipe

Get Started with Structuring Complex Objects and Lists in Flow

Learn the importance of Types, Object Values, and List Values in flow and how to structure data in your flow build.
Learn more

Accelerator

Simply Vision: Boomi Monitoring Solution

Monitor your deployed assets and accurately forecast support requirements with Boomi!

Accelerator

Oracle Cloud ERP Integration Accelerator – HCM/HR: Employee by Apps Associates

Automatically load employee data into Oracle Cloud ERP and connect to HCM/HR systems with Boomi.