Sisense Data Connector for Amazon Redshift

Optimize Your Cloud Investments with Sisense and Redshift

Sisense offers a native data connector to Amazon Redshift, a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Store data in Redshift database and query this data in Sisense to optimize performance, improve cost control and deliver greater ease of use.

As well, Sisense provides the ability to prepare, govern, analyze and mashup data from multiple sources. The powerful In-Chip® engine unifies decentralized data and balances workloads. Use Sisense to optimize your investment in the cloud and build faster, more flexible analytical apps with reduced management overhead and cost.

In addition to Redshift, Sisense has data connectors to Kinesis Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, and many more out of the box. With Sisense, the benefits of Amazon Web Services empower more builders and analysts at every step of the BI workflow. 

Benefits of Amazon Redshift

Integrating your Redshift data warehouse with Sisense’s toolkit presents several noteworthy benefits including:

  • Best for frequent queries, real-time queries using columnar storage, complex data aggregations, already an AWS customer
  • If currently running on AWS, Redshift should be your first choice.  Redshift integrates with a variety of AWS services such as Kinesis Data Firehose, SageMaker, EMR, Glue, DynamoDB, Athena, Database Migration Service (DMS), Schema Conversion Tools (SCT), CloudWatch, etc.
  • In Redshift you are given control over how to tune your big data database. Enables you to tweak the data model and fine tune the cluster for the best performance and lowest infrastructure cost
  • Fastest for real-time queries using columnar storage

Amazon Redshift introduces RA3 nodes with managed storage enabling independent compute and storage scaling

Amazon Redshift RA3 nodes with managed storage are generally available and enable you to scale and pay for compute and storage independently, allowing you to size your cluster based only on your compute needs. Now you can analyze even more data cost-effectively.

RA3 nodes are built on the AWS Nitro System and feature high bandwidth networking and performance indistinguishable from bare metal. RA3 nodes use very large, high performance SSDs as local caches. RA3 nodes leverage your workload patterns and advanced data management techniques, such as automatic fine-grained data eviction and intelligent data pre-fetching, to deliver the performance of local SSD while scaling storage automatically to S3. RA3 nodes remain fully compatible with all your existing workloads.

To get started with RA3 nodes see the cluster management guide. You can find more information on pricing by visiting the Amazon Redshift pricing page.

Benefits of Sisense and Amazon Redshift

Instant Insights with Native Connection to Redshift

The Sisense live connection uses Amazon Redshift to power queries and dashboards in real time. Connect and create relationships to quickly prepare complex live data models for any purpose. Run live analysis on any dataset to make well-supported decisions on the spot.

Hybrid Architecture to Integrate Data from Redshift and Other Data Sources
Beyond live analysis, Sisense delivers easy-to-use analytics that seamlessly blends live data from Redshift and other data sources to make more informed decisions. Sisense’s high-performance In-Chip® engine and Elastic Data Hub analyze other data alongside real-time queries from Redshift. Whether you want to a connect a multi-cloud environment, combine data that’s not yet in Redshift, or keep pace with rapidly changing requirements, Sisense provides a hybrid solution to manage, prepare, combine, and analyze distributed data.

A True Single Version of the Truth
Perennial growth in data often leaves data sources outside of Redshift. Sisense eradicates these data silos by providing a single data analytics software for all data models and sources. Teams and departments can easily create multiple high-performance data models in the Sisene Elastic Data Hub that can be analyzed alongside live data from Redshift. This increases the adoption of Redshift and also brings all data into a unified governed platform reducing management overhead.

Quickly Migrate to the Cloud
Sisense enables you to connect and analyze data before and during your migration to Redshift. Native data models can be used to enable analysis and after migration; taking seconds to redirect any analysis to query live data in Redshift. This provides business continuity and enables you to get value from data instantly without waiting for a lengthy migration process.

Remove Bottlenecks for Ultimate Service Flexibility
Sisense ease of use matched with Redshift allows anybody to model and analyze complex data. Business users don’t need to seek technical assistance every time they want to query live data connections. Offer the right service model based on user needs and skills to provide analytics on demand.

Balance Complex Workloads for Operational Excellence
Shift data exploration and analysis to Elastic Data Models to optimize performance and lower TCO. Sisense’s In-Chip® engine gives you a time-saving, cost-efficient way to cache existing data. Instead of refreshing the whole database every time you add something new, query cached data for historical insights and connect live to Redshift for more timely questions.

Integrate Further with Managed Cloud BI
Focus on what matters and Sisense managed Cloud. With Sisense Managed Cloud, you don't need to worry about hardware or IT. Get Sisense fully-managed, secure, and scalable cloud service.

Getting Started

To start using the Redshift Connector, simply follow the instructions here.

Not a Sisense user yet?

Try Our Sisense Free Trial!