Category: Amazon Redshift

Customer data is critical for modern digital organizations, but is often scattered across tools which can render it useless. Historically, customer data platforms (CDPs) aimed to consolidate data for insights and activation, but organizations now prefer a composable CDP architecture on AWS to sync data from Amazon Redshift and Amazon S3 into downstream tools. Hightouch facilitates this composable CDP approach, making it easy to activate AWS data across channels without engineering work.

Brands struggle to deliver personalized customer experiences, giving competitors with real-time end-to-end personalization a competitive edge. Mastering personalization requires unifying customer data across systems into a Customer 360 view. RudderStack and AWS make building a Customer 360 in Amazon Redshift easy, as RudderStack handles complex data unification and automatically generates insights while Redshift provides a scalable, performant data warehouse.

Winning and retaining customers requires thoughtful engagement fueled by customer data. While legacy customer data platforms (CDPs) aggregate data, they also create silos. RudderStack’s warehouse-native CDP built on Amazon Redshift provides flexible data pipelines to collect, unify, and activate customer data. This eliminates silos and establishes a single source of truth to enable teams to collaborate and create tailored customer experiences that drive growth.

Learn how the Heimdall Database Proxy can be configured to provide customer query routing for Amazon RDS for Postgres, although any SQL database type including Amazon Redshift can be supported. This provides a single Heimdall Proxy endpoint to access data for multiple customers from multiple databases, transparently. Heimdall Data provides functionality needed to support many complex database environments, and solves many of the challenges in scaling database access.

As organizations acquire more and more data, the need to effectively store and query the data has become very important. Canvas Glide from LTI is a tool for administering Amazon Redshift’s day-to-day routine tasks. It also helps organizations manage all financial aspects related to cost allocation, chargeback, monitoring, and planning of Amazon Redshift clusters. Learn how Canvas Glide assists administrators to successfully manage their clusters and guides them on common maintenance tasks.

Esri and AWS are extending their collaboration through an extensive integration of product suites and services. This includes Amazon QuickSight leveraging Esri basemap tiles through Amazon Location Service. Esri also supports ArcGIS Enterprise on Kubernetes running with Amazon EKS, and interoperability with Amazon Redshift. Esri‘s GIS solutions create, manage, analyze, and map various types of geospatial data. Their flagship GIS mapping software, ArcGIS, is a powerful mapping and spatial analytics technology.

Enterprise data warehouses are complex and consist of database objects that need to be modified to reflect the changing needs of business, data analytics, and machine learning teams. In this post, learn about an approach to managing the evolution of enterprise-scale data warehouses based on the experience of Deloitte’s Data and AI global practice teams. The declarative tool developed by Deloitte that can automatically generate DDL statements to align Amazon Redshift’s state to an approved baseline configuration.

The massive scale and efficiencies offered by cloud data lakes are best served by a continuous replication mechanism from on-premises and cloud-based enterprise resource planning (ERP) applications. Learn how SAP ERP, Amazon Redshift, and HVR Change Data Capture (CDC) add up to more than the sum of the individual parts, and dive deep into HVR’s architecture and the unique value proposition for SAP customers building their data lakes with AWS.

Follow along as Agilisium provides an early look at Amazon Redshift’s ra3.4xlarge instance type (RA3). This post details the result of various tests comparing the performance and cost for the RA3 and DS2 instance types. It will help AWS customers make an informed decision on choosing the instance type best suited to their data storage and compute needs. As a result of choosing the appropriate instance, your applications can perform better while also optimizing costs.

As databases are often a key component of internet infrastructure, IT departments may be challenged by poor connection management from the application. The Heimdall Proxy helps developers, database administrators, and architects horizontally scale out and optimize connections through connection pooling for Amazon Amazon RDS and Amazon Redshift without any application changes. As a result, you will reduce your database instance size and support higher user counts.