Home Services Partners Company
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

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. 

Comments are disabled in preview mode.