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 (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.

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

TDWI ODBC to force.com

Standards based data connectivity enables adoption of cloud aPaaS

Read the full story from tdwi.org 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 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 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
Comments are disabled in preview mode.
Topics
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
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More
 
232-132_How to Simplify Application Usage & Deployment with Microapps
How to Simplify Application Usage & Deployment with Microapps
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More