the reality of real-time - moving the needle...
TRANSCRIPT
![Page 1: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/1.jpg)
The Reality of Real-Time
The "what, why, and how“ of
accessing and using real-time data
from your enterprise systems.
Moving the Needle 2014
Thursday, Nov. 6th - 9:40 am
Brian Parish – CEO and Founder, IData
![Page 2: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/2.jpg)
The primary takeaway from this presentation?
Your Goal is “A Clear Path from Question to Answer.”
How does real-time data fit in this path?
![Page 3: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/3.jpg)
Agenda – The Reality of Real-time
![Page 4: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/4.jpg)
Agenda – The Reality of Real-time
When?
When is real-time? What do we mean by real-time data?
Why?
Understanding your business needs/questions
What?
Understanding what data you need
How?
Architecture and Connectivity options for real time.
So?
Getting people to use and trust the data
Who?
How IData can help you on the path.
![Page 5: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/5.jpg)
Introductions
![Page 6: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/6.jpg)
About the IData Presenters
Brian S. Parish:
• President, IData Inc.
• 19 years in Higher Ed Tech
• Worked with well over 150 schools on technology and reporting projects
![Page 7: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/7.jpg)
About IData Incorporated
• Higher Education Data Management
• Started in 2004
• Based in Alexandria, VA
• Technology Services
• Reporting and Data Governance
• System Integration
• Custom Application Development
• Implementation and Migration Services
• Innovative Software
![Page 8: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/8.jpg)
Web services integration platform for building connectors to higher education ERP systems
Collaborative data dictionary and data management tool for higher education
IData Products
![Page 9: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/9.jpg)
Who is here?
• From an IT office?
• From an IR office?
• From a functional office?
• From a vendor?
• Other?
![Page 10: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/10.jpg)
WHAT DO WE MEAN BY REAL-TIME?
When?
![Page 11: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/11.jpg)
When is real-time?
Some Definitions first:
• What is Real-time data?
• What is near real-time data?
• What is snap-shot data?
• What is Longitudinal data?
• Do people sometimes mean “Automated?”
“real-time”
![Page 12: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/12.jpg)
UNDERSTANDING YOUR BUSINESS NEEDS/QUESTIONS
Why?
![Page 13: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/13.jpg)
Why?
• There are compelling business reasons for real-
time.
• Are these needs well understood.
• Thought – All data request should be a
conversation that start with the business need or
the question being asked.
![Page 14: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/14.jpg)
Why?
Examples of real-time data
requirements?
![Page 15: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/15.jpg)
Why?
Think critically about the need.
• Some solutions will require real-time data
• Some will not (even though it was asked for)
• Some can be solved by looking at different
architecture options
![Page 16: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/16.jpg)
UNDERSTANDING WHAT DATA YOU NEED
What?
![Page 17: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/17.jpg)
Data Management Practices?
• Data Governance Group
• Data Dictionary
• Data request process
• Report Specification templates or tools
• IR and IT collaboration
• BI Group
• Report/Data documentation or transparency
• Trust?
![Page 18: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/18.jpg)
What?
The key is good data definitions
• Your functional definitions (business rules)
• Your technical definitions (data systems)
• Multiple technical definitions for different data
sources (real-time vs warehouse)
Understand and document both as part of any
reporting project.
![Page 19: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/19.jpg)
Observation:
• Reporting is Hard.
• Institutions continue to struggle with reporting.
• Some schools are successful with a wide range
of reporting tools.
• Many schools have been unsuccessful with the
same tools.
![Page 20: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/20.jpg)
Conclusion:
![Page 21: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/21.jpg)
ARCHITECTURE AND CONNECTIVITY OPTIONS FOR REAL TIME.
How?
![Page 22: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/22.jpg)
Reporting Architecture
![Page 23: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/23.jpg)
Reporting Environment?
• Data Warehouse?
• Homegrown
• Commercial (COTS)
• Operational Data Store?
• Transactional Reporting tools?
• Census Data Extracts
• Aggregate reporting (combining systems)
• Standard ETL Tools?
![Page 24: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/24.jpg)
Direct Reporting vs Warehousing
• Real-time reporting is simple if you are primarily
reporting directly from the production
transactional system.
• Things get more complicated for real-time if you
are primarily reporting out of a data warehouse
• Hybrid approaches can work.
• Real-time ETL can also work
![Page 25: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/25.jpg)
5 architecture approaches
• Direct to Transaction reporting
• Direct to warehouse with scheduled ETL
• Direct to warehouse with real-time (triggered) ETL
• Reporting that connects to both warehouse and
transactional system
• Separate tools for real-time and warehouse
reporting
![Page 26: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/26.jpg)
Transactional Systems
Architecture Options
• Direct to Transaction reporting
![Page 27: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/27.jpg)
Transactional Systems
Architecture Options
Data Warehouse
• Direct to warehouse with scheduled ETL
![Page 28: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/28.jpg)
Transactional Systems
Architecture Options
Data Warehouse
• Direct to warehouse with real-time (triggered) ETL
![Page 29: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/29.jpg)
Transactional Systems
Architecture Options
Data Warehouse
• Reporting that connects to both
warehouse and transactional system
![Page 30: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/30.jpg)
Transactional Systems
Architecture Options
Data Warehouse
• Separate tools for real-time and
warehouse reporting
![Page 31: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/31.jpg)
Actually connecting to the systems
• ETL Tools
• Native Tools
• Third Party Tools
• Direct Database connections
• ODBC/Queries
• Web Services
• InBound or Outbound
• Master Data Management tools
![Page 32: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/32.jpg)
Data SystemsREAL-TIME CONNECTIVITY OPTIONS
![Page 33: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/33.jpg)
Systems?
• ERP/SIS
• Ellucian Banner
• Oracle/PeopleSoft Campus Solutions
• Ellucian Colleague
• Jenzabar (EX, CX)
• Campus Vue
• Ellucian Power Campus
• Homegrown
• Others…
• Any Plans for Workday?
![Page 34: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/34.jpg)
Ellucian Banner
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance• HR
• Anything that compiles in Oracle• No specific toolkit• New UI being developed in Groovy
• Oracle• Unix
Hosting available
• Banner Mobile Connect
• Banner delivered a customizable package
• Luminus based on UPortal
Banner ODS, Banner EDW (Enterprise Data Warehouse), Partner with IBM Cognos and eVisions Argos for reporting tools
• Most integration is done through Oracle
• New Ellucian XE Framework for WS
• Alumni Development
![Page 35: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/35.jpg)
Ellucian Colleague
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance• HR
• Proprietary Envision toolkit—Colleague Studio
• Unidata, SQL Server, Oracle
• Unix , Linux,Windows
Hosting Available
• Partnership with DubLabs to implement MOX mobile app
• Provides portal support based on
SharePoint
• BusinessObjects• Bb Analytics for
warehouse• ODS
• Import/export batch files using ELF
• A few APIs through Sharepoint
• Advancement
![Page 36: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/36.jpg)
PeopleSoft Campus Solutions
• No standard• May partner with
DubLabs AT&T offering
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• HR• Finance
No
• PeopleSoft Campus solutions warehouse
• BbAnalytics• Oracle Discoverer
• Integration Broker• SQR imports/exports• SAIP
• Alumni (Contributor Relations)
PeopleTools
• Oracle, SQL Server
• Unix, Linux, Windows
• Oracle Enterprise Portal
![Page 37: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/37.jpg)
CampusVue Student
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance• HR-use Talisma for fundraising
• Built on .net platform• CampusVue forms
• SQL Server• Windows
Yes
• Talisma CRM for sending notices and alerts to mobile devices
• SharePoint-CampusVueportal
• CampusVuePerformance Analytics for warehouse
• CampusVue Reporting Services with Crystal Reports
• SSRS
• CampusLink
![Page 38: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/38.jpg)
Jenzabar EX
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance• HR
• PowerBuilder• C++, C#
• SQL Server• WIndows
Yes
• JICS Go-browser based
• .net Portal-JICS
• Reporting through SSRS
• Provides data access using SSIS
• Alumni Development• PowerFAIDS
![Page 39: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/39.jpg)
Ellucian Power Campus
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance-Microsoft
Dynamics• HR-Microsoft Dynamics
• Visual Basic• Visual Studio
• SQL Server• Windows
No
• No standard mobile option
• SharePoint
• Microsoft reporting tools
• Provides data access using SSIS
• Financial Aid-PowerFAIDS
• Advancement
![Page 40: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/40.jpg)
Unit 4-Agresso
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance• HR
• Web-based architecture using .net framework, supports XML-based data sharing
• SQL Server, Oracle
• Windows, Linux, Unix
Yes
• Agresso Reporting and Analytic tools
• Can be integrated with third-party systems at basic level, CSV, or XML
• Financial Aid-PowerFAIDS
• No standard portal offering
• Provide reporting apps
![Page 41: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/41.jpg)
WorkDay
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• HR• Finance
• Java-based• WorkDay business process
framework for workflow
• MySQL• Linux
Fully SaaS
• Built-in BI• WorkDay
Actionable Analytics
• WorkDayintegration
• Cloud to integrate other systems to WorkDay
• No standard portal offering
• Mobile apps for IPad, IPhone and Blackberry
![Page 42: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/42.jpg)
Three Rivers CAMS
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Finance-Microsoft Dynamics• HR-Microsoft Dynamics
• Built using Microsoft technology and tools
• SQL Server• Windows
Yes
• Provides the BYOR (Build Your Own Reports)
• CAMS Student Mobile Portal
• Microsoft technology
• No clear integration strategy
![Page 43: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/43.jpg)
TopSchool
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Student• Financials
• Microsoft tools for development• .Net framework• SharePoint
• SQL Server• All browser-
based, possibly Internet Explorer
Yes
•Microsoft Reporting Services
• TopX set of web services that include APIs for customers to build their own integrations
• No standard mobile options
• SharePoint
![Page 44: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/44.jpg)
Kuali
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• Finance• Student• HR
• Java-based• Eclipse
Workbench
• Database-independent, primarily MySQL
• Linux, Unix, Windows
Yes
• Cognos
• Kuali Rice-middleware component
• Google Web toolkit
• UPortal for UI
• KualiMobiliityEnterprise
• No standard offering currently
• Will be based on Uportal or Google widget
![Page 45: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/45.jpg)
Jenzabar JX
Mobile
Portal
Reporting
Integration
Modules:
Languages/Tech:
Database/OS:
Hosting or SaaS?
• FrontRunner Advancement
• Google Widget Toolkit• Java
• Database independent
• OS dependent on database option
Not yet
• GWT optimized for different browsers
• Cognos
![Page 46: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/46.jpg)
Client Counts (SIS)
System Total FTE Total Campuses
Banner 7M 1444
Colleague 3.2M 792
PeopleSoft 4.5M 875
CampusVue 276K 473
Jenzabar EX 352K 258
Jenzabar CX 281K 125
PowerCAMPUS 165K 116
Agresso 7K 4
WorkDay - -
Three Rivers 132K 89
Top School 2K 3
Kuali 41K 5
Jenzabar JX - -
SunGard Matrix 113K 120
![Page 47: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/47.jpg)
GETTING PEOPLE TO USE AND TRUST THE DATA
So?
![Page 48: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/48.jpg)
Simple illustration of Reporting Process
Data Request and
Requirements Gathering
Report Development
Report Consumption
![Page 49: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/49.jpg)
Simple illustration of Reporting Process
Data Request and
Requirements Gathering
Report Development
Report Consumption
What happens here?
![Page 50: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/50.jpg)
The Reaction…
Where the hell did these numbers come
from?
![Page 51: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/51.jpg)
Root causes of lack of trust…
• Inconsistent numbers – “Dueling Data”
• Lack of understanding of data definitions
• Lack of involvement in decision making
• Previous failed projects
• Perceived (or real) data quality issues
• No transparency in to the data rules
• Personal conflict
![Page 52: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/52.jpg)
9 Steps for Building Trust and Adoption
1. Ask more questions
• Data requests should be a conversation
2. Place importance on the purpose of each
report. Ask “Why” not “What”
3. Train in the Data more than the Tool
![Page 53: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/53.jpg)
9 Steps for Building Trust and Adoption
4. Start documenting your own reports
• Be very specific in defining reporting terms
• Document for the functional and technical user
5. Create an institutional knowledge base
• Knowledge is developed one question at a time.
• It is happening now at your institution.
• Are you capturing it?
6. Establish and empower Data Stewards
![Page 54: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/54.jpg)
9 Steps for Building Trust and Adoption
7. Create a report request/change process
with a standard for report specifications
• Include the data stewards in this process
8. Make your knowledge base easily shared
and accessible: “Liberate the knowledge”
9. Link your delivered reports to the
knowledge base.
![Page 55: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/55.jpg)
HOW IDATA CAN HELP YOU ON THE PATH.
Who?
![Page 56: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/56.jpg)
Web services integration platform for building connectors to higher education ERP systems
Collaborative data dictionary and data management tool for higher education
IData Products
![Page 57: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/57.jpg)
The Data Cookbook
![Page 58: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/58.jpg)
What is the Data Cookbook?
![Page 59: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/59.jpg)
DataCookbook.com is an online and
collaborative data management tool
for higher education
What is the Data Cookbook?
![Page 60: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/60.jpg)
It combines a good reporting process with
a governed knowledge base
What is the Data Cookbook?
![Page 61: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/61.jpg)
Features include:
• Data Dictionary
• Report Specifications/Documentation
• Report Request/Change Workflow
• Data Governance Workflow
• Community for collaboration with other
institutions, vendors, and agencies
Data Cookbook Features
![Page 62: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/62.jpg)
The IDataHub
![Page 63: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/63.jpg)
ERP Integration – an illustration
Current Institution Architecture With the IDataHub
![Page 64: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/64.jpg)
School Servers
High-Level Architecture
Web Servicesor Batch
IDataHubERP
Connectors
![Page 65: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/65.jpg)
Data Providers and Consumers• Third Party Software• External Agencies• Mobile devices• Other external systems
Transaction Web servicesand/or Batch Files
Institution Network
Administrative Systems • ERP (Datatel, Banner, etc.)• LMS (Bb, Moodle, etc.)• Other internal Systems
Custom API
Standard API
InstitutionFirewall
• Procedures/Tasks• Scheduling• Logging• System Connections
Admin System Connectors
Application Database
IDataHub Institution Admin Site
• Administer transactions• View logs• View/Edit configuration • Create/Edit Procedures & tasks
“The Cloud”Admin web services
Service Oriented Front-End Architecture (SOFEA)
![Page 66: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/66.jpg)
Admin UI
![Page 67: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/67.jpg)
IData Services
![Page 68: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/68.jpg)
IData Services
• Reporting and Data Governance
• Data management assessments and workshops
• Building data governance organizational structures
• Implementing data management and reporting processes
• Reporting and data warehouse development (agile iterations and
project-based)
• Report migrations (moving to new reporting systems)
• Requirements and design for reporting and data analysis projects
• Implementation and training for the Data Cookbook (IData’s data
management tool)
![Page 69: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/69.jpg)
IData Services
• System Integration Services
• Develop custom web services
• Streamline batch processing
• Automate and monitor data integrations
• Standardize system integration API’s
• Agile Technical Staffing
• Developer/Analysts
• Project Managers
• Strategic Consulting
![Page 70: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/70.jpg)
Find Out More…
www.idatainc.com
www.datacookbook.com
Brian Parish
![Page 71: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/71.jpg)
Wrap Up
![Page 72: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/72.jpg)
![Page 73: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/73.jpg)
Revisiting the Presentation Goals
![Page 74: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/74.jpg)
Final Thought
Understand how to access real-time data
when you need it.
However…
Real-time data is only one potential method
to a useful answer.
![Page 75: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/75.jpg)
Discussion
![Page 76: The Reality of Real-Time - Moving the Needle conferencemovingtheneedleconference.com/.../uploads/iData-MTN_2014_The_Reality_of_Real_Time.pdfThe Reality of Real-Time The "what, why,](https://reader033.vdocuments.us/reader033/viewer/2022042021/5e78d8552f332c73af0c7f37/html5/thumbnails/76.jpg)
Thank YouVISIT WWW.IDATAINC.COM OR WWW.DATACOOKBOOK.COM
FOR MORE INFORMATION