In 1958, the University of New Orleans opened its doors as the first fully integrated public university in the southern United States. Since then, it has educated students from all 50 U.S. states and more than 130 countries. The university is named as one of the nation’s best colleges by The Princeton Review, Forbes, and U.S. News & World Report.
“With Informatica and Snowflake, we’re democratizing data across the university while improving operational efficiency. We’re making data much more accessible. This enables reporting in less time while helping to improve information security and reduce operating costs.”
Business Need
- Centralize data and make it available for analytics
- Adopt cloud solutions to modernize and reduce risk
- Produce reports in hours instead of days
- Move to a scalable and flexible data lake
Challenges
- Analyze student and employee data from multiple on-premises and cloud sources in a centralized data warehouse
- Improve efficiency, reduce costs, and enhance information security by automating manual ETL processes
- Quickly and efficiently move 20 years of ERP data to the cloud so it can be protected and accessed by Workday and reporting tools
Solutions & Results
- Use Informatica Intelligent Cloud Services to extract, transform, and load data from Salesforce, SQL Server, and Workday into Snowflake
- Use Informatica Cloud Connectors for Snowflake and Workday to connect on-premises and cloud systems without hand coding
- Accelerates cloud migration to Workday by two months while keeping historical data safe and available
- Use Informatica Cloud Mass Ingestion to migrate thousands of tables with complex data structures from Oracle into Snowflake
- Makes data available across the university for program analytics to help enhance student enrollment and retention
- Enables reporting in less time while helping to improve information security
