What is Live API?

Espresso enables you to create an enterprise-class REST/JSON API (Live API) to multiple data sources in minutes. Developers create new REST endpoints that ‘join’ data across your data sources using a point-and-click approach. The API supports both update and read capabilities. It includes enterprise-class features and reactive programming rules for business logic.


REST API for SQL Databases created Automatically

Espresso introspects the database schema to automatically create RESTful end-point for tables, views and stored procedures. You can then create new nested APIs with data from multiple tables, from one or multiple databases using point-and-click. You easily create new REST endpoints with multiple children, each in turn with their own children.


NoSQL Databases & Enterprise Applications

Espresso enables you to create joins across SQL and NoSQL databases such as MongoDB. Espresso also provides connectivity to enterprise applications such as Salesforce, SAP, Microsoft Dynamics and Sharepoint using REST interfaces. So enterprises can quickly build integration applications combining data from their proprietary SQL and NoSQL databases to enterprise applications. 


Video showing REST integration with different apps

Integration with other systems

Espresso fits seamlessly into your enterprise architecture. It is a complete middle-tier service built on a standard REST architecture; designed to integrate with other common services. You can incorporate ESBs, workflow engines, APIs to packaged applications as well as access to proprietary data sources – there really is no limit to what you can build.


Multiple Data Sources? No problem!

Need to create a REST API that spans multiple data sources? It is quick and easy with Espresso!

Espresso provides a single view of your enterprise data.  You just define the join fields and click to select data you need across multiple sources. Espresso will create a new REST endpoint – nested and document-oriented – that is all it takes.

Espresso optimizes the processing to reduce latency, network utilization and database load. The new API is ready for app development and testing.



Enterprise Class API

Out of the box, Live API includes the following:

  • Optimistic locking
  • Pagination
  • Filtering
  • Sorting
  • Authorization (API key)
  • Custom client parameters

Fine Grain API Control

Espresso supports both projection and aliasing so that you end up with new REST endpoints shaped just the way you want; ready for client development.

  • Projection: By merely clicking on the fields you limit the fields presented in new resource endpoints.
  • Aliasing:  Enables you to rename field names to more descriptive user-friendly names.

Built-in Testing

Test your API with the included REST Lab. Evaluate the JSON request and response in real time. Submit a transaction and trace through parameter driven logs. You can work with the JSON directly, use the table view grid or the Live Bowser for immediate testing


Security and Access Control

Espresso provides role and row/column level security that can be configured with a point and click interface – even across multiple databases. You can use your own authentication mechanism or use the one provided by Espresso to identify users’ roles. Roles are then associated with permissions to define which REST endpoints are exposed to which users along with read and writes privileges.


REST API for Stored Procedures

Stored procedures are automatically REST-enabled endpoints.  Espresso supports stored procedure updates as well as those that return multiple result sets. With Espresso, leverage your existing investment in logic and create REST endpoints with no programming.


Reactive Programming for Business Logic

Espresso’s reactive programming approach uses business rules to replace hand-written code for update logic. These no-compile rules map to requirements for quick development and maintenance.  Server-side JavaScript is used to extend the rules and create business logic as needed. 

For applications that need use information from multiple sources,  Espresso rules operate across fields in different data sources. For example, you can define a rule that constrains the value of a field in a database to values existing in an application.  Alternatively you can derive the value of a database column to be the sum of values in a collection in a different database. These rules take only seconds to define.



Object and Event Model

Espresso creates a complete object model from your schema.  A JavaScript object is created for each table, view, stored procedure and custom resource providing access to objects and attributes.  Accessing related data  is automated. Espresso provides transaction bracketing for data integrity. A rich event model enables you to centralize business logic with simple handlers for PUT, POST and DELETE.

Connect with your Database or Use Database supplied by us

Connect with your database using reverse SSH tunnel or co-locate your Espresso appliance with the database behind your firewall.

If you want to create a new database, Espresso optionally supplies a MySQL instance in the AWS cloud.


Databases Supported

Espresso supports the following databases:

  • MySQL Database version 5.0 and higher
  • Oracle Database version 10.2 and higher
  • Microsoft SQL Server version 2005 and higher
  • Microsoft Azure SQL
  • MongoDB
  • Pervasive database from Actian
  • PostgreSQL

Let us know if you need access to other SQL Databases.


Deployment Options – On-premise or in the Cloud

Espresso product is available either as a cloud service or on-premise appliance. The following options are available:

  • Amazon AWS appliance
  • Microsoft Azure appliance
  • VMware appliance
  • Docker appliance

Whenever you are ready to trial in any of the options, just complete this form and someone will contact you within 24 hours

Integration with API Management

Espresso creates REST/JSON APIs and generates standard Swagger documentation. These APIs can be easily managed by third party API management tools such as Azure API Management, Apigee, CA (Layer7) and Intel (Mashery).

Free PDF    Send article as PDF