To extract and load Cassandra data, create a Cassandra data object in the Developer tool. You can include the data object as a source or target in a mapping. You can run the mapping or add the mapping to a workflow to process the data.

PowerExchange for Cassandra includes the Informatica Cassandra ODBC driver that connects to the Cassandra database. You can create an ODBC connection to extract data from or load data to a Cassandra database.

You can also configure the multinode Cassandra server setup with the corresponding replication strategy. The

Data Integration Service

can fail over to secondary servers if the primary server fails.

The Developer tool imports a column based on the schema that you set for the column family. If a column contains a collection such as a set, list, or map, the Developer tool creates a virtual table and imports the collection as columns at the same level as other columns. The Developer tool creates a virtual table for each collection in the column family.

You can identify sets, lists, and maps with the naming convention of the column. The naming convention of a collection is <top level element name>.<collection>.

When you run a

mapping, the Data Integration Service uses the Cassandra ODBC data source name in the machine that runs the Data Integration Service

to extract data from or load data to a Cassandra database.