University of New Orleans

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

Dr. Ray Wang

CIO, University of New Orleans

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

View the PDF