msbi tool working enviroment support or not in amazon cloud

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  November 16, 2013 at 12:22 am

  #395837

  HI,

  We are looking on amazon web services.before going this services is it support microsf tool ssis(etl part extract,transformation,loading),ssrs(reporting part),ssas(analystical part) and sql server database.present our company is services based now client asked there data warehouse projects implement in amazon cloud.in present enviorment when ever we install sql server database in our systems that time sql server management studio and

  Business intilegence studio futures added here.that time while using sql server management studio we did sql server database related data(lke queries).

  And while usging business intilegence studio that time we did ssis(etl part extract,transformation,loading),ssrs(reporting),ssas(analytical).and if any need third part tolls that time we install odbc drivers here.in the same how amazon cloud providing same services.

  Actually I heard while choosen amazon ec2 its pull support operations systeme with sql server. And I heard one more amazon rds that is suooprt sql server,oracle,mysql. Here I have small doubt which choosen amzon ec2 that time its providing operating system with database. Why required superate amzon rds services.If we choose that option time what ever we need businetilegence studio futures added or not. Is there any services we needed.

  Please clarify above things.