Category Archives: BusinessIntelligence

SSAS Data Connection and Impersonation Info

When we create a datasource in SSAS, we need two types of connection information Data Connection: As the name goes, this information is used to connect to data source. This can be a standard User ID / Password combination (can … Continue reading

Posted in BusinessIntelligence, SSAS | Tagged | Leave a comment

SSIS ETL Framework

  In my current job, we have a custom ETL framework to control the execution of SSIS packages. Some of the features of our ETL framework is as follows: a) Control the execution of packages using metadata tables We use … Continue reading

Posted in BusinessIntelligence, DataWareHousing, SSIS | Leave a comment