Key findings of the survey:
The 2017 Data Connectivity Outlook surveyed 1,200 participants around the globe, in various technical and business roles, representing a range of industries and organization sizes. It uncovers the top databases and data access interfaces, as well as popular applications and technologies used to connect database silos. You can download the entire report here.
Given the variety of data sources reported by participants, it’s no surprise that the use of SQL and REST data access standards is increasing. Respondents are leveraging open standards to easily connect the expanding hybrid environment.
By 2019, use of ODBC is expected to increase 11%, JDBC 11%, OData 3%, while REST is expected to increase significantly by 19%.
Learn more about other popular interfaces in our complete report.
Regardless of how the data landscape is evolving, the survey shows that enterprises still have significant investments in on-premises RDBMS and big data. With SaaS adoption increasing, seamlessly integrating the two environments is a requirement.
To connect cloud and ground, the majority of respondents use VPN or SSH tunneling to traverse the firewall. However, participants still voiced plenty of concerns about accessing data behind a firewall from the cloud:
Commercial gateways such as our hybrid connectivity solutions are gaining in popularity. Learn more about how commercial gateways can help you securely access on-premises data.
For a competitive edge, organizations are adopting multiple analytics and reporting solutions and using open standards to connect to the data. The total share of respondents using reporting and analytics tools is 63%. Overall, participants use standard SQL and REST interfaces for:
The survey shows that companies are adopting both embedded analytics and external analytics tools. This trend is giving rise to open analytics, which enables applications to expose standard SQL (ODBC, JDBC) or REST (OData) interfaces, even if a BI solution is embedded.
We’re very excited to share this comprehensive report on industry growth, cloud platforms, data protection laws, latest data sources, analytics, data integration challenges, standards and other relevant topics.
Get all the data and recommendations here:
Download the complete report
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
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.