SYS-CON MEDIA Authors: Liz McMillan, Elizabeth White, Maria C. Horton, Andy Thurai, Zakia Bouachraoui

Blog Feed Post

REST APIs for Databases: Easy Access from HTML5, Web and Mobile Apps

Learn what's new in REST APIs for databases, and how you can use REST and OData to improve the way you securely access data from web and mobile. Catch a demo in our on-demand webinar too.

Our recent webinar, What’s New in REST APIs for Your Database, has been one of our most popular to date, with hundreds of attendees signing up to learn about REST and OData for data access. 

Why has this topic resonated so broadly? Securely accessing data from web and mobile applications is a challenge confronting every organization in every industry. Users expect to have fast, accurate data available at their fingertips.

REST and OData are the solution.
What is OData, and how did we get here? Read on to learn more!

Modern Data Access Patterns

Data access has evolved from mainframe to relational to the current world of data distributed across many sources. While data warehouses are still a workhorse for many organizations, the concept of a “nightly batch” has become archaic—what is “nightly” for a global company? Plus, data warehouses can be inherently time consuming to build and maintain.

Data lakes have come to the forefront as a replacement for the data warehouse because data lakes can ingest more types of data in larger quantities. Unfortunately, data lakes tend to turn into data swamps when the focus is more on collecting data rather than on connecting data. Plus, concerns about data privacy and security can inhibit the usefulness of a lake.

The modern data access method, therefore, leaves data in place while connecting to it via REST APIs.

Easy Access of REST APIs from HTML5, Web and Mobile Apps

REST APIs allow you to continue leveraging existing investment in data storage, while securely opening that data to web and mobile apps without actually moving or copying the data. The HTML5, web or mobile applications can access the data in real-time via the REST APIs. But because every database REST API is different, you need OData.

OData is an open protocol to allow the creation and consumption of query-able and interoperable REST-ful APIs in a simple and standard way. While every database REST API is unique, OData is both an industry standard and an international standard, and is sometimes called “SQL for the web.”

The OData API works by mapping its constructs and query options to database and SQL constructs. Likewise, HTTP methods map to OData REST Operations and SQL Commands.

Progress DataDirect delivers a single point of OData configuration for all data sources. With one interface, you can create OData endpoints to each of your data stores. Then, connect to those endpoints with your application. Our webinar includes an OData demo, so if you’re new to OData check it out to view the demo in action.

How are Organizations Using OData?

Use of REST and OData APIs are increasing. In the 2017 Data Access survey we learned that 71% of companies were using OData or REST. In our recent webinar, we asked our attendees why their companies are adopting the OData standard:

Reasons for REST API Usage


Sensitive data needs to stay within the firewall: This speaks to the exact reason why many companies no longer want to use the data warehouse or data lake model. Data needs to remain in place, behind corporate firewalls, rather than moving into various repositories or into the cloud. Data security concerns are rising every day, and they are only going to increase. Leaving data in place and adding an extra layer of additional control isn’t just nice to have—it’s a necessity.

Modern Apps need REST end points for integration: By combining modern applications built with JSON, Nativescript, Python, Ruby, etc. with OData endpoints, data access and integration becomes seamless and simplified. No longer do databases have to be difficult for application developers to integrate with. But those modern applications need the implementation of REST endpoints to make integration happen.

What Data Sources are Most In-Demand for REST Enablement?

We offered survey participants two sets of choices for the data sources they need to REST-enable. See both sets of answers below:

Popular Data Sources for REST APIs

More Popular Data Sources for REST APIs

Amongst our webinar attendees, the most popular data sources to RESTify were SQL Server, OpenEdge, MySQL and the Hadoop Frameworks.

While relational data stores can often be labeled as “legacy,” this survey verifies our experience that the vast majority of businesses in the world still run on the largest relational databases. The movement toward the web and modern applications doesn’t replace the need to use traditional relational data. Instead, OData opens a new way to access those traditional sources of data with new, cutting-edge applications.

Learn More

Ready to learn more about data access trends, why companies are REST-ifying data and see a demo of OData in action? Watch our webinar today!

Watch Webinar

Read the original blog entry...

More Stories By Progress Blog

Progress offers the leading platform for developing and deploying mission-critical, cognitive-first business applications powered by machine learning and predictive analytics.

Latest Stories
The Software Defined Data Center (SDDC), which enables organizations to seamlessly run in a hybrid cloud model (public + private cloud), is here to stay. IDC estimates that the software-defined networking market will be valued at $3.7 billion by 2016. Security is a key component and benefit of the SDDC, and offers an opportunity to build security 'from the ground up' and weave it into the environment from day one. In his session at 16th Cloud Expo, Reuven Harrison, CTO and Co-Founder of Tufin, ...
Historically, some banking activities such as trading have been relying heavily on analytics and cutting edge algorithmic tools. The coming of age of powerful data analytics solutions combined with the development of intelligent algorithms have created new opportunities for financial institutions. In his session at 20th Cloud Expo, Sebastien Meunier, Head of Digital for North America at Chappuis Halder & Co., discussed how these tools can be leveraged to develop a lasting competitive advantage ...
"We were founded in 2003 and the way we were founded was about good backup and good disaster recovery for our clients, and for the last 20 years we've been pretty consistent with that," noted Marc Malafronte, Territory Manager at StorageCraft, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
While the focus and objectives of IoT initiatives are many and diverse, they all share a few common attributes, and one of those is the network. Commonly, that network includes the Internet, over which there isn't any real control for performance and availability. Or is there? The current state of the art for Big Data analytics, as applied to network telemetry, offers new opportunities for improving and assuring operational integrity. In his session at @ThingsExpo, Jim Frey, Vice President of S...
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm. In their Day 3 Keynote at 20th Cloud Expo, Chris Brown, a Solutions Marketing Manager at Nutanix, and Mark Lav...
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settl...
"At the keynote this morning we spoke about the value proposition of Nutanix, of having a DevOps culture and a mindset, and the business outcomes of achieving agility and scale, which everybody here is trying to accomplish," noted Mark Lavi, DevOps Solution Architect at Nutanix, in this SYS-CON.tv interview at @DevOpsSummit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
According to the IDC InfoBrief, Sponsored by Nutanix, “Surviving and Thriving in a Multi-cloud World,” multicloud deployments are now the norm for enterprise organizations – less than 30% of customers report using single cloud environments. Most customers leverage different cloud platforms across multiple service providers. The interoperability of data and applications between these varied cloud environments is growing in importance and yet access to hybrid cloud capabilities where a single appl...
@CloudEXPO and @ExpoDX, two of the most influential technology events in the world, have hosted hundreds of sponsors and exhibitors since our launch 10 years ago. @CloudEXPO and @ExpoDX New York and Silicon Valley provide a full year of face-to-face marketing opportunities for your company. Each sponsorship and exhibit package comes with pre and post-show marketing programs. By sponsoring and exhibiting in New York and Silicon Valley, you reach a full complement of decision makers and buyers in ...
In today's always-on world, customer expectations have changed. Competitive differentiation is delivered through rapid software innovations, the ability to respond to issues quickly and by releasing high-quality code with minimal interruptions. DevOps isn't some far off goal; it's methodologies and practices are a response to this demand. The demand to go faster. The demand for more uptime. The demand to innovate. In this keynote, we will cover the Nutanix Developer Stack. Built from the foundat...
"Cloud computing is certainly changing how people consume storage, how they use it, and what they use it for. It's also making people rethink how they architect their environment," stated Brad Winett, Senior Technologist for DDN Storage, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Sold by Nutanix, Nutanix Mine with Veeam can be deployed in minutes and simplifies the full lifecycle of data backup operations, including on-going management, scaling and troubleshooting. The offering combines highly-efficient storage working in concert with Veeam Backup and Replication, helping customers achieve comprehensive data protection for all their workloads — virtual, physical and private cloud —to meet increasing business demands for uptime and productivity.
Two weeks ago (November 3-5), I attended the Cloud Expo Silicon Valley as a speaker, where I presented on the security and privacy due diligence requirements for cloud solutions. Cloud security is a topical issue for every CIO, CISO, and technology buyer. Decision-makers are always looking for insights on how to mitigate the security risks of implementing and using cloud solutions. Based on the presentation topics covered at the conference, as well as the general discussions heard between sessio...
"NetApp's vision is how we help organizations manage data - delivering the right data in the right place, in the right time, to the people who need it, and doing it agnostic to what the platform is," explained Josh Atwell, Developer Advocate for NetApp, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
A look across the tech landscape at the disruptive technologies that are increasing in prominence and speculate as to which will be most impactful for communications – namely, AI and Cloud Computing. In his session at 20th Cloud Expo, Curtis Peterson, VP of Operations at RingCentral, highlighted the current challenges of these transformative technologies and shared strategies for preparing your organization for these changes. This “view from the top” outlined the latest trends and developments i...