I have been assigned to a new project where data load s gonna happen from oracle to cassandra through SSIS and then to render the report by SSRS from Cassandra (spark). That is the architecture plan.
I have been asked to prepare the check list items for SSIS and SSRS. I have never worked on cassandra before so I have no idea about what would be the difficulties to load data into cassandra and then query data using reporting services. I have not yet been provided dedicated machine to test myself.
so some one please help me identify the things needed to connect cassandra and what difficulties would it be to render report using SSRS?
We are going to use SQL server 2012 version.
Any suggestions would be much appreciated.