KB442629: How to check topic data in Linux for MicroStrategy Platform Analytics

Description

This article outlines the commands used to check topic data in Linux for Strategy Platform Analytics 11.0 and above.

Getting started with checking data in each topic:

Navigate to the Kafka folder:
cd /opt/MicroStrategy/MessagingServices/Kafka/kafka_2.11-1.1.0/bin
 
To check topic IsSessionStats: 
./kafka-console-consumer.sh --bootstrap-server localhost:9092 --topic Mstr.PlatformAnalytics.IsSessionStats --from-beginning
 
To check topic IsReportStats:
./kafka-console-consumer.sh --bootstrap-server localhost:9092 --topic Mstr.PlatformAnalytics.IsReportStats --from-beginning
 
Frequently used options:
 
Option                                   Description                           
------                                   -----------                           
--bootstrap-server <String: server to    REQUIRED (unless old consumer is      
  connect to>                              used): The server to connect to.    
 
--from-beginning                         If the consumer does not already have 
                                           an established offset to consume    
                                           from, start with the earliest       
                                           message present in the log rather   
                                           than the latest message.            
 
--max-messages <Integer: num_messages>   The maximum number of messages to     
                                           consume before exiting. If not set, 
                                           consumption is continual.           
 
--offset <String: consume offset>        The offset id to consume from (a non- 
                                           negative number), or 'earliest'     
                                           which means from beginning, or      
                                           'latest' which means from end       
                                           (default: latest)        
--partition <Integer: partition>         The partition to consume from.         
                                           Consumption starts from the end of   
                                           the partition unless '--offset' is   
                                           specified.               
 
--topic <String: topic>                  The topic id to consume on.           
 
 
 To list all the topics:
./kafka-topics.sh --list --zookeeper localhost:2181
 

Learning Resources

Refer to the Technical Document below for a complete list of PA topics and mapping tables:
KB442628: Platform Analytics Kafka Topics and mapping tables in MicroStrategy 11.0 and above
 
 
 
Article Reference Number: KB442629