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.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2018 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.