Data Warehouse Modernization – Three Way, with Amazon Redshift
If you are considering Amazon Redshift for your new data warehousing project, you are definitely not alone!
Many of our customers are going through a data-driven digital transformation and have already implemented modern data warehouse projects with Amazon Redshift. Yet many more are requesting our help to do so now. Major drivers for this trend include the need to cost effectively scale your BI stack for massive data volumes, agile and self-service cloud analytics and inherent elasticity, the ability to scale up and down and pay just for what you need when you need it. To deliver faster and trustworthy analytics insight, that feed transformational business initiatives, these solutions need to provide accessible, timely and relevant data from any source, including on-premises, cloud, or big data.
We are seeing in the marketplace three major adoption patterns for cloud data warehousing with Amazon Redshift:
1. Extend on-premise enterprise data warehouse (EDW) with Amazon Redshift
Many organization have made heavy investments over the years in their on-premises EDW environment. As new modern analytics projects emerge, these companies elect to keep intact their existing EDW and extend it to the cloud with Amazon Redshift and Informatica, evolving towards a hybrid data warehousing environment. One such example is Shaw, an enhanced connectivity provider in Canada, delivering broadband communications. Shaw BI experts recently shared at Informatica World ’17, how they have extended their existing on-premises enterprise data warehouse environment, with Amazon Redshift, to deliver frictionless customer experience and increased customer satisfaction. They are collecting and analyzing massive amounts of real time IOT data from their customers’ set-tops and combining this data with SaaS data, such as ServiceNow and Salesforce and on -premises data. They are leveraging multiple AWS services such as Amazon Kinesis, S3 and Redshift.
2. Migrate on-premise EDW to Amazon Redshift
Other organizations who have made heavy investments in their on-premises EDW, elect to migrate their entire EDW environment to Amazon Redshift. These migrations are often triggered by the desire to avoid hefty contract renewal fees for traditional data warehousing software. Instead they opt for Amazon Redshift as their new EDW, eliminating the need for hefty upfront fees for their data warehouse software and the ability to cost effectively scale their data warehouse project. One of Informatica’s long-time customers, a large entertainment conglomerate, recently decided on such a path. They found that with Informatica they were able to protect their investment and very easily migrate thousands of ETL mappings from their traditional on-premises data warehouse to Amazon Redshift, while enjoying the cloud benefits of cost efficiency and inherent elasticity.
3. ‘Born in the Cloud’ data warehouse with Amazon Redshift
Finally, many younger companies, who are often ‘born on AWS’, find themselves in need to become ‘data-centric’ as their data volumes and complexity grow and the need arises to establish agile and robust analytics projects. These organizations often turn to Amazon Redshift for their new cloud data warehouse. An example of this adoption pattern is Adaptive Biotechnologies, a biotech company in Seattle helping fight cancer, who recently shared their story at Informatica World ‘17. As a younger ‘born on AWS’ company, Adaptive Biotechnologies had some basic data analytics tools. They needed agile self-service analytics as well as robust reporting. They are using Informatica Cloud and Amazon Redshift for both a data lake and a data warehouse, enabling agile ad hoc data discovery and analytics and iterative operational reporting and dashboarding across their data ecosystem and for all business stakeholders to deliver data-driven insights and actions. They were able to save hours of work every day for their analysts as well as increase revenues as result of their new BI stack.
Many of our customers are leveraging Informatica Intelligent Cloud Services, our industry-leading iPaaS solution, to rapidly deploy projects with Amazon Redshift, with agility, high performance and scalability. Watch our on-demand ‘deep dive & demo’ webinar to learn more about how you can leverage our solution to successfully implement a modern data warehouse with Amazon Redshift.
In this technical session, we learn about the different use cases around Amazon Redshift and discussions on how Informatica Intelligent Cloud Services is used to implement these use cases. Through real world examples learn about best practice- when to use ETL versus ELT, performance tuning and recently introducd new features.
Key webinar learnings:
• Amazon Redshift: Key benefits, capabilities, and use case patterns
• Informatica Intelligent Cloud Services for Amazon Redshift and other Amazon services
• Best Practices
• Deep Dive Demo of key use cases
Watch the on-demand webinar ‘Informatica Intelligent Cloud Services for Amazon Redshift, Deep Dive & Demo’