SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for business analysts. Implementation of SAAS gives an opportunity to users to ask compound query and convert it into actionable insight where information for better business decision making will be available. Instead of just collecting raw database of large size, the Business Intelligence (BI) methods ensure that first the data is converted into actionable intelligence.
Composition of SQL Server:
SQL Server Analysis Service (SAAS): This helps in Online Analytical Processing (OLAP) that comprises of data mining solutions. For understanding tends, patterns, specialized algorithms are used.
SQL Server Reporting Service (SSRS): This gives a solution to create, publish, and distribute business reports to the users.
SQL Server Integration Services (SSIS): This performs ETL operations (Extract, Transform, and Load). Means, the data can be extracted from source, manipulated as per requirement, and it import to the recipient data.
Talking about the components of Business Intelligence, it’s only SQL Server Analysis Service. The worth highlighting fact about SSAS is it OLAP instead of OLTP!
Online Transaction Processing (OLTP): OLTP database is frequently updated with statements like (INSERT, DETELE, UPDATE). Its basic features include:
· Short Transactions
· Simple Queries
· Small portions of data involved
· Frequent Updates
Online Analytical Processing (OLAP):OLAP type database is queried using the SELECT statement. Its general attributes include:
· Long Transactions
· Complex Queries
· Large portion of data involved
· Less Frequent updates
Synchronizing Analysis Services using SQL Server Management Studio
In case of SSAS, synchronization can simply be considered as replicating database of System Analysis from one running instance to another. Database administrators generally keep a copy of database on test Server and then restore them to production Server. Synchronization is one of the finest techniques that can be adopted in order to ensure that all SAAS instances have same data. Here is how to proceed:
Step1) Launch SSMS and move to “Databases” folder. Right click on it and choose “Synchronize”.
Step2) A windows named “Synchronize Database Wizard”, type source Server and source database name. Similarly, provide credentials for destination database and Server.
Step3) a dialog box will appear on screen that will give the service to change location of the local partition. Utilize this option according to your requirement.
Step4) Provide security synchronization. Choose between any of the three security options. Click on “Finish” button to start synchronization.
Conclusion:
In the above description I have explained different services of SQL Server and synchronization with SQL Server analysis services. Step by step procedure of synchronization is briefly explained through which users will be able to understand the actual fact behind synchronization process. Further more details will be given to your in next blog.