It's always exciting to read about how critical standards based data connectivity is to each project, and how it becomes even more relevant with each new disruptive technology. The most recent article from the TDWI Business Intelligence Journal Vol. 19, No. 1, highlights how real-time ODBC SQL access enabled the adoption of a cloud aPaaS platform (Force.com from Salesforce) due to operational BI requirements. Both Force.com and Progress Rollbase have real-time SQL connectivity to aPaaS available from Progress DataDirect.
Below are snippets from the Journal article written by Linda L. Briggs from TDWI in collaboration with Stanford University.
“‘Building right-time BI for those applications running in the cloud is not an investment or competitive advantage. Rather, it is absolutely critical for the business school to operate,’ according to Sinha. Making decisions in areas such as student housing assignments and class registration required tight integration with operations to ensure timely responses during the work ow. For example, the graduate housing application required right-time BI in order to make accurate assignments to students as they applied for housing. Given the limited supply of housing and the high volume of student requests, immediate response was needed."
"The ODBC integration enabled GSB business users—in just three months-to build a metadata model and access data in real time directly from the transactional source. Data is accessed without either staging or physically moving it, ensuring the data quality and integrity needed to make the best decisions."
- TDWI Business Intelligence Journal Vol. 19, No. 1: Download
Read the full story from tdwi.org available for TDWI members and here is a technical write-up on the use case.
Watch my sold out session from Dreamforce 2013 on real-time SQL Access to the Salesforce platform. Start a trial for real-time SQL access to Force.com or Rollbase to push the data driven boundaries of aPaaS development. Or call 1-800-876-3101 to speak with a systems engineer to learn more about data driven aPaaS applications.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
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.