In an more and more interconnected enterprise world, with the ability to join enterprise intelligence (BI) instruments to inside purposes or information sources is a should. Happily, a lot of the business has standardized round REST APIs, which gives a place to begin for making these connections, but it surely’s not an ideal system because it stands at present.
Progress Principal Gross sales Engineer, Dennis Bennett stated “Just about each SaaS utility will expose a REST API to offer you entry to it. Since [these applications are] hosted within the cloud, they’re by no means going to offer 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 by way of an API so as to 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. Which means that each supply handles it in a barely totally different approach. They could have totally 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 simple 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 straightforward 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 varied REST sources, the Autonomous REST Connector Composer transforms information right into a format that’s simpler to work with, comparable to remodeling embedded arrays into standardized tables. “The facility customers are used to utilizing BI instruments, in order that they’re actually simply utilizing the Composer to create the mannequin after which from there, they will use it like some other information supply,” he stated.
For instance, an organization that makes use of Tableau Energy BI can run their inside information sources by way of Composer to get that information right into a tabular construction that may then be accessed utilizing SQL queries.
Whereas Bennett touted how simple it’s to make use of the Autonomous REST Connector, Progress additionally affords quite a lot of pre-built templates to make the method even simpler. He stated that these will get clients eighty p.c of the way in which there and assist velocity up the combination course of.
In line with Bennett, the Connector is especially helpful for inside tasks as a result of inside information is commonly business-critical and must be accessible to do analytics and reporting. Moreover, inside purposes are sometimes even much less standardized than industrial purposes, as a result of they could have added their very own proprietary extensions or customized authentication strategies.
“Usually folks will do issues like extract and cargo a relational database to do reporting on it, however that’s not excellent as a result of it provides extra transferring elements and the information goes stale shortly. The Progress Autonomous REST Connector provides you entry to those proprietary assets the place you’re not going to get a industrial driver [to help],” he stated.
By way of authentication, the Connector helps the usual methodology of OAuth 2.0, whereas additionally supporting further types of authentication that may be seen in an inside utility. In contrast with industrial purposes, inside ones generally have further steps concerned, comparable 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 further stuff to it—whether or not it’s further fields and a put up physique or further headers—customized authentication allows you to assist not solely regular OAuth 2.0, but additionally these form of further OAuth [protocols] that we frequently see in enterprise purposes,” he stated.
RELATED CONTENT: Breaking down information silos: The facility 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 might not be typical. For instance, as an alternative of seeing all clients, you may solely need 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 inside purposes that do each, and generally we see totally different syntax for organising these filters. And so, the thought is that the Connector can deal with even these non-standard issues,” Bennett stated.
