Create a REST API for any data without writing code.

Schools and districts use data that comes from many different applications and sources. The problem is that the data must be re-entered many times into each application via manual data entry. Without some way to integrate the data, keep it up to date, and check it for accuracy, the data the teachers and staff uses every day becomes stale and inaccurate. This wastes time in the classroom for teachers, extra tech support tickets for IT, and frustrated administrators who are trying to analyze and report on the data.

CPSI helps districts overcome these difficult challenges. Our solution collects data from the many different applications in real time, checks the data for accuracy, and standardizes the data for reporting, BI and analysis. We help schools and districts finally leverage all kinds of data – from rosters to assessments to attendance and more—across the entire district.

With CPSI, all of the school and district staff can be confident that the information on their computer or device always reflects the true “picture” of the data in the district. Our solution provides everyone in the district – from students to teachers to superintendents – with the underlying foundation to provide up-to-date and “trustworthy” information in all of the applications they use.

xDREST - REST API Data Layer for Any Database - CPSI

With all of the talk of REST API’s and so many different solutions out there, you need a way to manage your data over a REST API. xDREST is a fully functional data layer that allows you to use the power of SQL and an easy to use management console to create and manage role based REST API functions without writing a line of code.

xDREST - REST API Data Layer for Any Database - CPSI

You make your own REST data layer and API.

Create your own REST API and data layer without ever writing a line of code. Using SQL Stored procedures and our management interface, you can create as many different API calls as you need to satisfy your goal of providing data securely to outside vendors.

You control the API security and who can access your API.

Each connecting application is given their own unique application key. Create unique functions for each connecting application, setup roles and security for each connecting application. You control what data each application has access to within your system. Define a list of sites and control which applications have access to each specific site in your district.

xDREST - REST API Data Layer for Any Database - CPSI

Easy REST API Creation

Create a fully functional REST API without writing code.

API Data Layer

Acts as your data layer so you don’t have to expose your data directly to the outside world.

Safe and Secure REST API

You control the applications connecting to your data.

Role Based API

Using roles and permissions, you define exactly what functions each app can use in your API.

Use Any Source Data

Connect to as many data sources as you want in your API.

Expose Data Easily

Connect to many different data sources to provide seamless integration to other apps even if you have data in many sources.

Easy to Use Manager

Manage your system with a lightweight management console.

Easy Management

The user management interface is a lightweight and simple application that can be installed on any Windows PC.

Learn More About the xDREST

In many educational data systems, data sits in database locations that do not have their own API to work with the data within the system. xDREST allows you to create a REST based API data layer on top of any existing SQL database to enable other systems, such as third party vendors, to securely access the data without exposing the databases to outside sources.

It is also very important that data layers secure the data being exposed so that outside systems only have access to the data they are allowed to view. xDREST manages applications using secure application keys unique to each connecting application as well as data filtering using custom variables and role based security.

In addition to the other features of xDREST, it ships with an easy to use management console that makes management a breeze. Create a data layer in minutes using SQL and the xDREST Management console. xDREST also comes with fully functional sample code to help vendors create clients in a hurry.

  • Single endpoint REST API
  • Easy client creation and sample code
  • Create functions that can use any SQL functionality using SQL Stored Procedures
  • No programmer needed to create the REST API host service
  • Data is filtered so applications only see the data they have access too
  • Supports an infinite number of instances in IIS for scalability and security
  • Lightweight, easy to use management console that runs on any Windows PC
  • Supports any data types in the functions that SQL supports
  • Returns a comprehensive response object every time
  • Full auditing of every function execution
  • Manage each application individually, including functions and roles