Data access with REST APIs
Blog|by James Roberts|20 August 2019

Data access methods have changed over the years as applications and the data environment they interact with have increased in complexity. Applications which used to connect to a single relational database are being replaced by apps which quite likely depend on a number of heterogeneous data sources, both on premises and in the cloud. The use of BI, IoT, AI, ML and contextual information adds to the likelihood of a complex data landscape where security and integration can be difficult to solve.
With the adoption of modular and service orientated approaches to building applications, the use of APIs has become common place. For a long time, the combination of SQL and ODBC/JDBC has been the primary method used by developers working with data. APIs are now playing a significant role in data access too – but the disparate nature of APIs can be problematic.
The OData standard (Open Data Protocol) defines best practice for building and consuming RESTful APIs for handling data. Tableau, Salesforce, Tibco, Telerik, Informatica and Excel are examples of applications that work with OData. The protocol makes it easier to work with the variables that APIs introduce such as request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, queries etc. From a developer’s perspective, things are simplified if the data source’s REST interface is based on OData standards.
REST APIs provide important security features to support access policies, authentication and data masking. These have become a priority for data architects but can be challenging to implement. This is especially true if you’re an ISV and lack resources to develop and maintain your own connectors and keep abreast with the latest developments. Furthermore, the familiar tools used with SQL don’t always sit well with REST APIs.
Progress is a specialist provider of drivers for data access. Their DataDirect Autonomous REST Connector addresses the need for seamless, real-time connectivity between REST data, ODBC/JDBC tools and applications. The connector decreases the amount of time required for applications to understand and consume APIs through its codeless configuration and intelligent sampling. It acts as a middleman, allowing SQL dialogue to take place with the client application while handling RESTful communications with the data access tier and coding environment. This allows you to query API data using standard SQL. The connector normalises the semi-structured JSON response data into structured data which can then be used with SQL. This eliminates the need to understand the complexities of the JSON response.
Read the Whitepaper created by Progress to find out more about their DataDirect Autonomous REST Connector.
Grey Matter is a Progress partner. Fill in the form below if you have any licensing queries.
Contact Grey Matter
If you have any questions or want some extra information, complete the form below and one of the team will be in touch ASAP. If you have a specific use case, please let us know and we'll help you find the right solution faster.
By submitting this form you are agreeing to our Privacy Policy and Website Terms of Use.
James Roberts
Related News
Google Cloud IoT Core to retire in 2023
Google is ending its Cloud IoT Core managed service on August 16 2023, leaving users with one year to find an alternative solution. What does this mean for your business? Once Google Cloud Iot Core service reaches end of life,...
Veeam is certified for Microsoft Teams backup
Veeam has announced certified support for Microsoft Teams backup with NEW Veeam Backup for Microsoft 365 v6a!
New Acrobat Pro
Acrobat Pro is now the complete all-in-one PDF and e-signature solution that helps everyone do business faster across locations and devices with 100% digital document workflows.
Intel and Google provide optimised solution for HPC workloads
Intel and Google are working together to drive high-performance computing forward on Google Cloud with the release of the Cloud HPC Toolkit.