Success Story

School Information System Integration for a successful data visibility

Client

Arizona State University

Industry

Education

About the company

Arizona State University (ASU) is a public research university based in the Phoenix metropolitan area. Founded in 1885, ASU is one of the US’s largest public universities by enrollment and one of its most innovative school, among other top rankings.

The Challenge

Arizona State University (ASU) was moving to a new school information system (SIS) called Infinite Campus, which did not have the ability to fill out applications. To solve this problem, they built a new web portal to feed students applications and documents into Salesforce but they needed an automatic process to export the approved student applications and its documents from Salesforce to Infinite Campus. Without this integration, enrolled students wouldn’t be able to access their school information system, which includes content such as assignments, teacher-student communications, class registration, and other types of data.

Our Solution

Our proposal was to build a robust and automated solution that could export all student applications and their attached documents hourly to the Infinite Campus FTP server and also read the imported results. Additionally, we had to implement an automatic process that would allow Infinite Campus to be fed with the latest approved student applications as well as keeping advisors in Salesforce updated with the feedback received from Infinite Campus.

How we did it

Since Infinite Campus needed the information to be placed in their FTP in order to be consumed by their Data Import Utility scheduled to run hourly, our team decided to use Jitterbit as a tool that could be scheduled to export information from Salesforce and import their feedback. Extra implementation was necessary in Salesforce to guarantee the export of required applications and their corresponding documents. In this way, we avoid the submission of duplicated applications and ensure the re-submission of failed student applications.

The Result

Thanks to the solution developed, Infinite Campus achieved full visibility into approved student applications. Thus, communication between ASU advisors and Infinite Campus was guaranteed, ensuring all approved student applications were exported to their FTP server. Additionally, automating the process of exporting these applications and their documents enabled real-time updates.

Contact us

Trusted by great companies.

From start-ups to Fortune 500s, we help businesses of all sizes get the most out of their Salesforce experience.

What people are saying

Five stars on customer satisfaction and Salesforce appexchange ratings.

"Excellent Consultants. During the training I received by the SkyPlanner team, I was lucky to better understand the powerful capabilities of Salesforce.com. They were very effective, straight-to-the-point, and with a solid knowledge of the CRM and the Force.com platform. Definitively they showed us how to streamline the business process within our company. Great group of people spreading valuable knowledge to make businesses grow. I highly recommend them."

Ramiro Allen — Chief Software Engineer @ TurboPay Limited

"Excellent partner! We have been working with SkyPlanner for almost one year now. It has been a pleasure working with their team. If it wasn't for them we would have not been able to go-live with our platform when we did. They understood our needs and were not only able to execute but guide us in our decisions. We continue using them for our on-going projects. They have a deep understanding of the overall platform. Their team is always ready, willing and able to help."

Ivan de Moya — VP Innovation Technology @ SunStreet

"SkyPlanner was professional, creative, reliable and extremely accommodating. From the onset of the project, it was clear that we had found the right partner. Our project was complex and every time we hit a roadblock, SkyPlanner was helpful in identifying and implementing a solution. Jorge Fernandez [SkyPlanner's Co-Founder & Managing Director] was our primary contact and we cannot say enough about what an asset he was in bringing our project to resolution."

Ryan Borcherds — Marketing @ Deliver Lean

"On time, on budget, great quality on every project. Whenever I get asked to recommend a Salesforce.com partner, I do not hesitate on my reply: Go with SkyPlanner. I had the privilege to have worked with many teams over the years, none have brought to the table the enthusiasm the SkyPlanner team has. This combined with their professionalism and expertise are the reasons I ONLY recommend one partner: SkyPlanner. In every project (and we have done many) they have consistently delivered on time and on budget with significantly superior quality."

Juan Meza — Strategic Business Development Director @ Sony Electronics Inc.

"Outstanding Service! Happy to have them as our partner! SkyPlanner is by far the most experienced and reliable Salesforce partner. We almost gave up on Salesforce thanks to our previous partner, fortunately we found SkyPlanner and they came to the rescue! They took their time to understand our needs and complexity of our organization. Highly talented, professional and dedicated team. I cannot stress enough how happy we are to have them as our partner and we look forward to continue building our relationship."

Nolan Pereira — Project Manager @ BLU Products

Let's get started