How Stanford paved the way for operational BI with Salesforce aPaaS

How Stanford paved the way for operational BI with Salesforce aPaaS

April 29, 2014 0 Comments

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 ( from Salesforce) due to operational BI requirements.  Both and Progress Rollbase have real-time SQL connectivity to aPaaS available from Progress DataDirect.

ODBC/JDBC push the limits on what applications can run in the cloud

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


Standards based data connectivity enables adoption of cloud aPaaS

Read the full story from available for TDWI members and here is a technical write-up on the use case.

Learn more about operational intelligence against aPaaS

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 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 Sakar

Sumit Sarkar

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.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More