PowerExchange for Cassandra supports Cassandra Query Language (CQL) to write queries to the Cassandra database. PowerExchange for Cassandra creates virtual tables to normalize data in Cassandra collections, such as a list, set, or map.

You can use PowerExchange for Cassandra in the following data integration scenarios:

Your organization needs to extract data from Cassandra and aggregate data into a data warehouse or data mart for interactive data exploration and analysis.
Your organization needs to load data from flat files, relational database, or message queues to Cassandra.
Your organization needs to ensure consistency between your SQL data store and Cassandra data store.