While REST APIs have become increasingly popular, it's never been easy for analytical tools to query against them. Until now. Codelessly connect any application to any API with our latest connector.
The advent of data access layer, SaaS and microservices has resulted in the abstraction of databases behind REST APIs. There has been no easy way, however, for analytical tools to query against these APIs. But not anymore! Our latest offering allows the easy integration of these APIs with analytical tools by codelessly translating REST APIs into a SQL layer.
In the beginning, the enterprise world consisted of a couple of major databases that applications needed to support. Since these were mission-critical apps, both business and IT were happy to run proprietary SQL queries to interact with these databases. Fast-forward a few years, there were a bunch of new databases in the market—namely Oracle, MySQL, PostGres, SQL Server, Informix, Greenplum, IBM DB2 and several more. It was no longer scalable to learn and implement all the different flavors of SQL.
This gave rise to the popular connectivity standards—ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity). Over the last decade or so, enterprises have started abstracting the databases behind REST APIs for managing data access, additional security, data lineage and several other reasons. In the same time period, we also have seen an explosion in the number of enterprise SaaS, cloud and microservices apps that are accessible only through the REST APIs. So, today, IT is at another critical juncture of data integration where data is far more siloed and there is no easy way to query against these REST APIs.
REST (Representational State Transfer) is a web communication protocol used by systems to exchange information using HTTP, XML and JSON. Most developers like REST for three major reasons:
But, REST APIs, just like other APIs, disrupt the analytics side of the organization. Data developers such as BI analysts, data engineers and data scientists are used to looking at the data world in tabular, structural and SQL format. Analytical tools such as Tableau, R, Power BI, Cognos, OBIEE, Qlik, Informatica, TIBCO, Talend and others cannot integrate with all the REST APIs being generated across an enterprise and across the industry. These data tools and developers are most comfortable with SQL and the day to day analytical operations of the enterprise continue to get disrupted due to this gap between REST and SQL.
Progress DataDirect is the pioneer in standards-based SQL connectivity. We are the co-founders of ODBC and a key member of the JDBC technical committee. Over the years, we have developed and maintained ODBC, JDBC drivers for SaaS/REST data sources such as Salesforce, Google Analytics, Dynamics CRM, VeevaCRM, Oracle Service Cloud and more.
However, new public and internal REST APIs keep popping up every week that no single enterprise app vendor can support. To solve this new connectivity challenge for our partners and customers, we have developed a smart, codeless SQL for REST solution called Autonomous REST Connector. Progress DataDirect Autonomous REST Connector delivers seamless, real-time connectivity between REST data and your ODBC/JDBC tools and applications. It rapidly decreases the amount of time required for applications to understand and consume REST APIs through its codeless configuration and intelligent sampling.
Autonomous REST Connector is an intelligent, customizable data connectivity solution enabling businesses to build and deploy enterprise-grade data connectors in minutes without coding.
Empowering you to access data for your application, cloud or platform is our passion at Progress DataDirect. Over the last 30 years, we have developed several world-class ODBC, JDBC drivers for relational, big data and cloud databases. 350+ ISVs, including 8 of the 9 BI vendors, and 10000+ enterprises rely on us for their connectivity needs.
And now, we are excited to launch yet another groundbreaking connectivity technology. If you or your customers have a unique REST API that needs to be accessed from a business application, then Autonomous REST Connector is for you. Why don't you go ahead and test drive the product? Let us know what you think.
Download Autonomous REST Connector
Nishanth Kadiyala is a Technical Marketing Manager at Progress. He got his B.Tech degree from IIT Guwahati and his MBA from UNC Chapel Hill. He has worked on several technologies including database designing, SQL querying and Cloud Computing in the past. Currently, he is committed to educating enterprises about standards based connectivity via ODBC, JDBC, ADO.NET and OData. He is also proficient with DataDirect Hybrid Connectivity Services – DataDirect Cloud and Hybrid Data Pipeline. You can stay in touch with him through Twitter.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.