SYS-CON MEDIA Authors: Liz McMillan, Elizabeth White, Pat Romanski, Gary Arora, 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
Alan Hase is Vice President of Engineering and Chief Development Officer at Big Switch. Alan has more than 20 years of experience in the networking industry and leading global engineering teams which have delivered industry leading innovation in high end routing, security, fabric and wireless technologies. Alan joined Big Switch from Extreme Networks where he was responsible for product strategy for its secure campus switching, intelligent mobility and campus orchestration products. Prior to Ext...
Isomorphic Software is the global leader in high-end, web-based business applications. We develop, market, and support the SmartClient & Smart GWT HTML5/Ajax platform, combining the productivity and performance of traditional desktop software with the simplicity and reach of the open web. With staff in 10 timezones, Isomorphic provides a global network of services related to our technology, with offerings ranging from turnkey application development to SLA-backed enterprise support. Leadin...
On-premise or off, you have powerful tools available to maximize the value of your infrastructure and you demand more visibility and operational control. Fortunately, data center management tools keep a vigil on memory contestation, power, thermal consumption, server health, and utilization, allowing better control no matter your cloud's shape. In this session, learn how Intel software tools enable real-time monitoring and precise management to lower operational costs and optimize infrastructure...
Public clouds dominate IT conversations but the next phase of cloud evolutions are "multi" hybrid cloud environments. The winners in the cloud services industry will be those organizations that understand how to leverage these technologies as complete service solutions for specific customer verticals. In turn, both business and IT actors throughout the enterprise will need to increase their engagement with multi-cloud deployments today while planning a technology strategy that will constitute a ...
Cloud-Native thinking and Serverless Computing are now the norm in financial services, manufacturing, telco, healthcare, transportation, energy, media, entertainment, retail and other consumer industries, as well as the public sector. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long development cycles that pro...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Every organization is facing their own Digital Transformation as they attempt to stay ahead of the competition, or worse, just keep up. Each new opportunity, whether embracing machine learning, IoT, or a cloud migration, seems to bring new development, deployment, and management models. The results are more diverse and federated computing models than any time in our history.
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 settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereum.
Data center, on-premise, public-cloud, private-cloud, multi-cloud, hybrid-cloud, IoT, AI, edge, SaaS, PaaS... it's an availability, security, performance and integration nightmare even for the best of the best IT experts. Organizations realize the tremendous benefits of everything the digital transformation has to offer. Cloud adoption rates are increasing significantly, and IT budgets are morphing to follow suit. But distributing applications and infrastructure around increases risk, introdu...
DevOps has long focused on reinventing the SDLC (e.g. with CI/CD, ARA, pipeline automation etc.), while reinvention of IT Ops has lagged. However, new approaches like Site Reliability Engineering, Observability, Containerization, Operations Analytics, and ML/AI are driving a resurgence of IT Ops. In this session our expert panel will focus on how these new ideas are [putting the Ops back in DevOps orbringing modern IT Ops to DevOps].
Financial enterprises in New York City, London, Singapore, and other world financial capitals are embracing a new generation of smart, automated FinTech that eliminates many cumbersome, slow, and expensive intermediate processes from their businesses. Accordingly, attendees at the upcoming 23rd CloudEXPO, June 24-26, 2019 at Santa Clara Convention Center in Santa Clara, CA will find fresh new content in full new FinTech & Enterprise Blockchain track.
While a hybrid cloud can ease that transition, designing and deploy that hybrid cloud still offers challenges for organizations concerned about lack of available cloud skillsets within their organization. Managed service providers offer a unique opportunity to fill those gaps and get organizations of all sizes on a hybrid cloud that meets their comfort level, while delivering enhanced benefits for cost, efficiency, agility, mobility, and elasticity.
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science" is responsible for guiding the technology strategy within Hitachi Vantara for IoT and Analytics. Bill brings a balanced business-technology approach that focuses on business outcomes to drive data, analytics and technology decisions that underpin an organization's digital transformation strategy. Bill has a very impressive background which includes ...
On-premise or off, you have powerful tools available to maximize the value of your infrastructure and you demand more visibility and operational control. Fortunately, data center management tools keep a vigil on memory contestation, power, thermal consumption, server health, and utilization, allowing better control no matter your cloud's shape. In this session, learn how Intel software tools enable real-time monitoring and precise management to lower operational costs and optimize infrastructure...
Most organizations are awash today in data and IT systems, yet they're still struggling mightily to use these invaluable assets to meet the rising demand for new digital solutions and customer experiences that drive innovation and growth. What's lacking are potent and effective ways to rapidly combine together on-premises IT and the numerous commercial clouds that the average organization has in place today into effective new business solutions. New research shows that delivering on multicloud e...