Izenda Product Update: Redshift Reporting

Izenda Product Update

As your data scales into the millions of rows, it’s likely that analytic queries against it return too slowly for your users. If so, it may be time to move to a data warehouse for OLAP reporting.

With version 2.7.0, Izenda now adds support for one of the leading data warehouse solutions, Amazon Redshift. It’s a column-oriented relational database that’s optimized for fast querying against the high volumes of structured data required by business intelligence.

Redshift offers a number of benefits as a data warehouse:

  • It’s managed in the cloud, so there is no work managing servers, installing database software or replicating data on your end.
  • It’s pay as you go. You can start small and scale up as your data grows.
  • It’s a relational database (based on PostgreSQL 8.0.2) that has been expanded with some additional SQL functions. Organizations, especially those that are already using PostgreSQL, will find it more familiar than other data warehouse solutions.
  • You can still perform OLTP functions against it, like inserting and deleting data, while at the same time you can perform analytics on petabytes of data for incredibly fast response time for queries.

Redshift is supported as a reporting database, not an Izenda configuration database. The configuration database is required by Izenda to hold reporting metadata like report and dashboard definitions, database schema abstractions, data model definitions, and tenant, role, and user permissions, and can be installed on Microsoft SQL Server or Azure SQL, Oracle, MySQL or AWS Aurora or PostgreSQL.

According to Dawn Russell, Izenda VP of Customer Success, “Support of Redshift is part of Izenda’s commitment to report against the many data sources that our customers rely on, including those in the AWS ecosystem.”

For more about using Redshift as a data source to deliver business intelligence in your application, contact us for an online demo.

Leave a Reply