Hi Guys, Could you help me understand how do we read data from Cassandara in SAS RTDM. Since cassandara stores data as key value pair, direct integration with RTDM (which requires structured data) seems difficult, also no SAS/Access for cassandara complicates the things further. One approach I could think of and need your evaluation is to have a parser piece of code deployed between the RTDM and cassandara database. The parser code will convert incoming file from RTDM to a format which is understood by cassandara and vice versa. This conversion of XMLs would have to be again deployed as a BI webservice. So in short the process node from the RTDM campaign will pass a normalized XML to the BI service, this web service (the parser code) will then convert the normalized XML in to an XML which would be understood by cassandara and fetch data. Again the response from cassandara would be converted to normalized XML by the parser code and the normalized XML would be given to RTDM for further processing. However this seems to be a time consuming process, hence request your guidance to understand the best possible solution in this case. Regards, mySAS1
... View more
