SSIS and SSAS
-
Hi I have a requirement to migrate the data from my standard OLTP database into an OLAP database based on the firing of a particular event. There will be some calculations performed on the OLTP data and the calculated/aggregated data will be inserted into the OLAP database. I have 2 options to do this. 1. Use a web service to insert data into the OLTP database, make required calculations and then insert the data into the OLAP database from within the web service itself. 2. Use SSIS to migrate the data from the OLTP database into the OLAP database. I am confused as to which option is better in terms of performance, security, maintainability as well as scalability of the application. My application deals with huge amounts of data which is required to be used for generation of reports. Thanks
-
Hi I have a requirement to migrate the data from my standard OLTP database into an OLAP database based on the firing of a particular event. There will be some calculations performed on the OLTP data and the calculated/aggregated data will be inserted into the OLAP database. I have 2 options to do this. 1. Use a web service to insert data into the OLTP database, make required calculations and then insert the data into the OLAP database from within the web service itself. 2. Use SSIS to migrate the data from the OLTP database into the OLAP database. I am confused as to which option is better in terms of performance, security, maintainability as well as scalability of the application. My application deals with huge amounts of data which is required to be used for generation of reports. Thanks
No you have only 1 option - you have to use SSIS. A web service is for publishing data to be consumed by a client, SSIS is an ETL tool, your job is ETL. The above description is a simplification of both tools but is essentially correct. This is especially true as you are transforming large volumes.
Never underestimate the power of human stupidity RAH
-
Hi I have a requirement to migrate the data from my standard OLTP database into an OLAP database based on the firing of a particular event. There will be some calculations performed on the OLTP data and the calculated/aggregated data will be inserted into the OLAP database. I have 2 options to do this. 1. Use a web service to insert data into the OLTP database, make required calculations and then insert the data into the OLAP database from within the web service itself. 2. Use SSIS to migrate the data from the OLTP database into the OLAP database. I am confused as to which option is better in terms of performance, security, maintainability as well as scalability of the application. My application deals with huge amounts of data which is required to be used for generation of reports. Thanks