SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Checklist to connect cassandra


Checklist to connect cassandra

Author
Message
Charmer
Charmer
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8425 Visits: 1124
Hi Friends,

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.

Thanks,
Charmer
Eirikur Eiriksson
Eirikur Eiriksson
SSC Guru
SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)

Group: General Forum Members
Points: 99988 Visits: 20894
Charmer (11/18/2016)
Hi Friends,

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.


So if I understand this correctly, you have your OLTP data in Oracle, then you are going to use SSIS as a pump for extracting that data to Cassandra where you are going do the analysis using Spark and then present and visualise the reports in SSRS, is this correct?
Cool
Charmer
Charmer
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8425 Visits: 1124
Yes exactly, Eirik. You got it.

Thanks,
Charmer
Eirikur Eiriksson
Eirikur Eiriksson
SSC Guru
SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)

Group: General Forum Members
Points: 99988 Visits: 20894
Charmer (11/20/2016)
Yes exactly, Eirik. You got it.


Just a thought, do you have an option of using SQL Server 2016 and PolyBase? Just forming an idea, not thought this fully through though.
Cool
Charmer
Charmer
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8425 Visits: 1124
I don't think they gonna use SQL 2016. So I'm not sure, Eirik. But please let me know about your idea. I will take it up to my architect team. I would explain them if it is better to have SQL 2016 and polybase. Rest is up to them.

Thanks,
Charmer
Eirikur Eiriksson
Eirikur Eiriksson
SSC Guru
SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)SSC Guru (99K reputation)

Group: General Forum Members
Points: 99988 Visits: 20894
Charmer (11/20/2016)
I don't think they gonna use SQL 2016. So I'm not sure, Eirik. But please let me know about your idea. I will take it up to my architect team. I would explain them if it is better to have SQL 2016 and polybase. Rest is up to them.


Will do Charmer, on the road right now so cannot look further into this until tomorrow, have couple of similar projects so I definitely will have to:-D
Cool
Charmer
Charmer
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8425 Visits: 1124
Thank you , Eirik. Take your time . I'll definitely be waiting to hear from you.

Thanks,
Charmer
Charmer
Charmer
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8425 Visits: 1124
Hi Eirik,

Were you able to get any information ?

Thanks,
Charmer
dswain118
dswain118
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 101
Hello Guys,
It would be pleasure if anyone help us on the comment raised above.

Regards,
Debasish
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search