AWS Partner Network (APN) Blog

Category: Amazon Redshift

Esri-AWS-Partners-1

Leveraging the Power of Esri’s ArcGIS Enterprise Through Amazon Redshift

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.

Read More
Deloitte-AWS-Partners

Managing the Evolution of an Amazon Redshift Data Warehouse Using a Declarative Deployment Pipeline

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.

Read More
HVR-AWS-Partners

How to Get Real-Time SAP Data into Amazon Redshift with HVR

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.

Read More

Amazon Redshift Benchmarking: Comparison of RA3 vs. DS2 Instance Types 

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.

Read More
Heimdall-Data-AWS-Partners

Advanced Connection Pooling with the Heimdall Proxy

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.

Read More
Matillion-AWS-Partners

How Matillion Multiplies the Performance of Complex ETL Jobs with Amazon Redshift Materialized Views

Amazon Redshift recently announced support for materialized views, which lead to significantly faster query performance on repeatable query workloads. That, in turn, reduces the time to deliver the datasets you need to produce your business insights. Matillion ETL for Amazon Redshift provides comprehensive enterprise-grade features to simplify and speed up building and maintaining these pipelines.

Read More
Cognizant-AWS-Partners

Change Data Capture from On-Premises SQL Server to Amazon Redshift Target

Change Data Capture (CDC) is the technique of systematically tracking incremental change in data at the source, and subsequently applying these changes at the target to maintain synchronization. You can implement CDC in diverse scenarios using a variety of tools and technologies. Here, Cognizant uses a hypothetical retailer with a customer loyalty program to demonstrate how CDC can synchronize incremental changes in customer activity with the main body of data already stored about a customer.

Read More
Onica-AWS-Partners

Best Practices from Onica for Optimizing Query Performance on Amazon Redshift

Effective and economical use of data is critical to your success. As data volumes increase exponentially, managing and extracting value from data becomes increasingly difficult. By adopting best practices that Onica has developed over years of using Amazon Redshift, you can improve the performance of your AWS data warehouse implementation. Onica has completed multiple projects ranging from assessing the current state of an Amazon Redshift cluster to helping tune, optimize, and deploy new clusters.

Read More
Mactores-AWS-Partners

Optimizing Presto SQL on Amazon EMR to Deliver Faster Query Processing

Seagate asked Mactores Cognition to evaluate and deliver an alternative data platform to process petabytes of data with consistent performance. It needed to lower query processing time and total cost of ownership, and provide the scalability required to support about 2,000 daily users. Learn about the the three migration options Mactores tested and the architecture of the solution Seagate selected. This effort improved the overall efficiency of Seagate’s Amazon EMR cluster and business operations.

Read More
AWS-Service-Ready-1

AWS Service Ready Helps Customers Find Validated Products That Integrate with AWS Services

Before making a purchasing decision, AWS customers tell us they want to know if a tool or application will integrate with AWS services running in their cloud environment. To meet this need for customers, we are excited to introduce AWS Service Ready. This program identifies and validates products from APN Technology Partners that integrate with specific AWS services, and recommends these products to customers.

Read More