Post reply

Checklist to connect cassandra

  • November 18, 2016 at 9:40 pm

    #72659

    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

  • November 20, 2016 at 8:20 am

    #1913607

    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?

    😎

  • November 20, 2016 at 8:28 am

    #1913610

    Yes exactly, Eirik. You got it.

    Thanks,
    Charmer

  • November 20, 2016 at 8:59 am

    #1913613

    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.

    😎

  • November 20, 2016 at 9:08 am

    #1913614

    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

  • November 20, 2016 at 9:21 am

    #1913617

    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

    😎

  • November 20, 2016 at 9:32 am

    #1913618

    Thank you , Eirik. Take your time . I'll definitely be waiting to hear from you.

    Thanks,
    Charmer

  • November 27, 2016 at 10:09 pm

    #1914652

    Hi Eirik,

    Were you able to get any information ?

    Thanks,
    Charmer

  • January 6, 2017 at 7:00 am

    #1921103

    Hello Guys,

    It would be pleasure if anyone help us on the comment raised above.

    Regards,

    Debasish

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply