can we working datawareshouse projects useing msbi(ssis,ssrs,ssas) tool on amazon web services

• baladevu

  SSC Veteran

  Points: 298

  More actions

  November 20, 2013 at 1:37 am

  #285368

  HI,

  We are looking to usage on amazon web services.before going this services.

  i found some few things above amazon web serverices.its provideing different types of services like amazon ec2,amazon s3, amazon rds,amazon redshift etc services its provideing.

  ec2:its provideing different os(operating systems)

  s3:to storage data

  rds:its provideing different types of databases like sql server ,oracle,mysql.

  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.