In an more and more interconnected enterprise world, with the ability to join enterprise intelligence (BI) instruments to inner purposes or information sources is a should. Happily, a lot of the business has standardized round REST APIs, which offers a place to begin for making these connections, however it’s not an ideal system because it stands right now.
Progress Principal Gross sales Engineer, Dennis Bennett stated “Just about each SaaS software will expose a REST API to present you entry to it. Since [these applications are] hosted within the cloud, they’re by no means going to present you entry to the database that holds your information as a result of that’s simply approach too insecure, however they may give you entry via an API so that you could make a request to get your information and it’ll undergo some logic to make sure what you’re asking for is one thing you’re entitled to.”
Dennis Bennett, Principal Gross sales Engineer at Progress.
He defined that the draw back to REST APIs is that they don’t lock you down into any particular approach of accessing that information. Because of this each supply handles it in a barely completely different approach. They could have completely different authentication strategies or alternative ways of returning information, like JSON or XML or CSV, for instance. The problem then turns into creating customized integrations that account for every of those variations.
That is straightforward work for builders, who Bennett stated might “do it of their sleep,” however for enterprise customers with out that experience, they should put in an IT request to get entry.
That is the place the Progress Autonomous REST Connector is available in, offering a simple approach for non-technical customers to construct and deploy information connectors to REST API sources with no need to attend for somebody in IT to set it up.
To have the ability to create these connections to numerous REST sources, the Autonomous REST Connector Composer transforms information right into a format that’s simpler to work with, corresponding to reworking embedded arrays into standardized tables. “The ability customers are used to utilizing BI instruments, so that they’re actually simply utilizing the Composer to create the mannequin after which from there, they’ll use it like another information supply,” he stated.
For instance, an organization that makes use of Tableau Energy BI can run their inner information sources via Composer to get that information right into a tabular construction that may then be accessed utilizing SQL queries.
Whereas Bennett touted how straightforward it’s to make use of the Autonomous REST Connector, Progress additionally presents quite a lot of pre-built templates to make the method even simpler. He stated that these will get clients eighty % of the way in which there and assist pace up the mixing course of.
In keeping with Bennett, the Connector is especially helpful for inner tasks as a result of inner information is usually business-critical and must be accessible to do analytics and reporting. Moreover, inner purposes are sometimes even much less standardized than business purposes, as a result of they could have added their very own proprietary extensions or customized authentication strategies.
“Typically individuals will do issues like extract and cargo a relational database to do reporting on it, however that’s not ultimate as a result of it provides extra shifting components and the information goes stale rapidly. The Progress Autonomous REST Connector provides you entry to those proprietary sources the place you’re not going to get a business driver [to help],” he stated.
When it comes to authentication, the Connector helps the usual methodology of OAuth 2.0, whereas additionally supporting further types of authentication that is likely to be seen in an inner software. In contrast with business purposes, inner ones generally have further steps concerned, corresponding to doing a Light-weight Listing Entry Protocol (LDAP) lookup earlier than choosing up OAuth 2.0 credentials.
“Generally we see OAuth 2.0 plus plus, and what I imply by that’s it’s OAuth 2.0, however they’ve added additional stuff to it—whether or not it’s additional fields and a put up physique or further headers—customized authentication allows you to help not solely regular OAuth 2.0, but additionally these type of additional OAuth [protocols] that we frequently see in enterprise purposes,” he stated.
RELATED CONTENT: Breaking down information silos: The ability of Microsoft Material and Progress DataDirect
Lastly, one other scenario that’s widespread in enterprise purposes is wanting to have the ability to filter information in a selected approach that is probably not typical. For instance, as an alternative of seeing all clients, you may solely wish to see one particular buyer or all clients in a selected ZIP code.
“Sometimes, you’ll see both filters within the URL as question parameters, or possibly you’ll see them in a put up physique. Generally we see these inner purposes that do each, and generally we see completely different syntax for organising these filters. And so, the thought is that the Connector can deal with even these non-standard issues,” Bennett stated.
