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.

View the PDF

“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

Produce reports in hours instead of days

Adopt cloud solutions to modernize and reduce risk

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

Quickly and efficiently move 20 years of ERP data to the cloud so it can be protected and accessed by Workday and reporting tools

Improve efficiency, reduce costs, and enhance information security by automating manual ETL processes

Solutions & Results

Use Informatica Intelligent Cloud Services to extract, transform, and load data from Salesforce, SQL Server, and Workday into Snowflake

Use Informatica Cloud Mass Ingestion to migrate thousands of tables with complex data structures from Oracle into Snowflake

Use Informatica Cloud Connectors for Snowflake and Workday to connect on-premises and cloud systems without hand coding

Makes data available across the university for program analytics to help enhance student enrollment and retention

Accelerates cloud migration to Workday by two months while keeping historical data safe and available

Enables reporting in less time while helping to improve information security

Products & Services

Informatica Intelligent Cloud Services

Informatica Intelligent Cloud Services is a next generation iPaaS, which is made up of a growing number of data management products. The productivity of the environment is accelerated by a common user experience across all products, the AI/ML-driven intelligence of the CLAIRE engine, and a microservices architecture.