Bi-kipedia

SQL Server Data Quality Services (DQS), new since SQL Server 2012, is a knowledge-driven data quality product.

Master Data Services (MDS), part of SQL Server 2012, is Microsoft's answer to the Master Data Management challenge. Master Data Management (MDM) is a set of tools and processes that aim to deliver a single clean and consistent view of each master data entity (product, customer, employee, financial accounts, etc.) that exists within the organization.Master Data Services (MDS) was first released in SQL Server 2008 R2 and was the result of the integration of the acquired technology of Stratature into SQL Server.

Microsoft SQL Server Analysis Services (SSAS) is the OLAP component of the SQL Server suite. With Analysis Services, it is possible to quickly and easily slice and dice the information in your data warehouse. Storing the data of your warehouse in an OLAP architecture provides a faster and more intuitive way of accessing that data. In Analysis Services, as in any OLAP architecture, everything is based around a cube.The cube holds the:

With the introduction of SQL Server Integration Services in the SQL Server 2005 release, Microsoft finally possessed a tool that could perform ETL (Extraction, Transformation & Loading) tasks. The predecessor of SQL Server Integration Services, DTS – Data Transformation Services, already had the capability to Extract and Load data coming from several environments, but was lacking the often quite important "transform" functionality.

Microsoft SQL Server started out, in the early years, as a relational database management system and grew throughout the years to a complete Business Intelligence platform.Microsoft originally bought the code base from Sybase SQL Server and released Microsoft SQL Server 1.0 in 1989. Throughout the years there were new releases and SQL Server 7.0 and SQL Server 2000 were the last versions which were based on the legacy Sybase code.

IBM Cognos TM1 API's stands for Application Programming Interfaces. It installs required files that enable developers to work with the Cognos TM1 application programming interfaces like TM1 API, TM1 Java API and TM1 .NET API.

The IBM Cognos TM1 Application Gateway component is installed together with the TM1 Application Server. It is a java-based web application tier component. This gateway ensures that end users can work with Cognos TM1 Performance Modeler and Cognos Insight.

The IBM Cognos TM1 Application server runs on a java-based web application server. The TM1 applications allow you to design, deploy and run planning and contributor applications on Cognos TM1 data. The tool interacts with components like Cognos TM1 Performance Modeler and Cognos Insight.

The IBM Cognos TM1 Server is an application tier component and manages requests from IBM Cognos TM1 clients. It loads cubes and dimensions into memory and responds by executing calculations, consolidations and updates. Via the Cognos TM1 Server administrators can also manage security by granting or denying permissions to different server objects like cubes and dimensions.

The IBM Cognos TM1 Admin Server is an application tier component. This process keeps track of all Cognos TM1 servers running on a network. An Admin Server runs on a computer better known as an Admin Host. The moment a Cognos TM1 server starts, the server registers itself with an Admin Server that is running on a specified Admin Host. The Cognos TM1 clients reference the Admin Server to determine which Cognos TM1 Servers are available.