Progress will discontinue Telerik Platform on May 10th, 2018. Learn more

Introduction to Stored Procedures

Introduction to Stored Procedures

Using the Telerik Platform Data Connectors you can access stored procedures (functions, reports) kept in your SQL database or Salesforce application. More specifically, you can map an HTTP endpoint to a stored procedure that you can later use to execute the code.

This allows you to integrate your client app with external systems and multiple data providers, to generate reports, and to perform other data management tasks.

You have two options for working with stored procedures: using the Telerik Platform web portal or using the Backend Services RESTful API.

Prerequisites

Working with stored procedures relies on the Telerik Platform Data Connectors feature. You need to have a Data Link Server installed (SQL Data Connectors only) as well as a Data Connector configured to connect to your data. See Introduction to Data Connectors for more information.

Support for stored procedures is only available in the latest release of the Java-based Data Link Server. Follow the upgrade instructions for Linux or Windows to install it. If you are running the .NET version, consider migrating to the Java version.

Features

Each HTTP endpoint that you create for a stored procedure allows you to use:

  • Unlimited amount of input, output and input/output parameters (not applicable to Salesforce)
  • Any type of input, output and input/output parameters (not applicable to Salesforce)
  • Role-based permissions to control who can execute stored procedures
  • JSON-formatted result structure

Next Steps

See Also

Contact us: +1-888-365-2779
sales@telerik.com
Copyright © 2016-2017, Progress Software Corporation and/or its subsidiaries or affiliates. All rights reserved.