none
need suggestion for setting up reporting database RRS feed

  • Question

  • HI ALL

    Transaction Data comes :MYSQL

    Reporting :SSRS

    Cube :SSAS

    Integration :SSIS

    Actually i need to do Reporting in SSRS based on cube where data comes from MYSQL .

    but i face collation issue and many more with this .

    So what we decide that we synch our MYSQL table in SQLSERVER on daily basis during OFF hours.

    I need your valuable suggestion for this that we are going in right direction ?

    I build an SSIS Packages to import related table that is needed in Reporting.?

    what issue can we face doing this ?

    and what benefit we achieve?

    Is there any other suggestion from your end .. kindly help..

    Regards

    BI_GROUP

    Monday, January 7, 2013 6:23 AM

All replies

  • when are you facing the collation issue, is it during the cube processing ?

    If so, you can change the collation of type of AS database also.


    Microsoft Partner Services Organization


    • Edited by Rakesh M J Monday, January 7, 2013 7:29 AM
    Monday, January 7, 2013 7:25 AM
  • many thanks for the reply

    i post my query here.

    http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/ae0069f6-0ad7-4f24-b446-f7685b49ec33

    kindly help me if you have any solution for this.?

    Monday, January 7, 2013 7:56 AM