How to join Microsoft SQL Server Analysis Services (SSAS) and ExactTarget

Discover how to join Microsoft SQL Server Analysis Services (SSAS) with ExactTarget for integrated analysis.

WITH PIPES OR PIPES PROFESSIONAL
How to join Microsoft SQL Server Analysis Services (SSAS) and ExactTarget with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to join Microsoft SQL Server Analysis Services (SSAS) and ExactTarget with Logical Data Warehouse


About Microsoft SQL Server Analysis Services (SSAS)

Microsoft SQL Server Analysis Services, SSAS, is an OLAP and data mining tool in Microsoft SQL Server. SSAS is used by organizations as a tool to analyze and understand information that may be spread across multiple databases or in different tables or files. Analysis Services provides a group of OLAP and data mining functions.

About ExactTarget

Salesforce Marketing Cloud formerly known as ExactTarget is a leading provider of analytics software services and digital marketing automation. It is used to create one-to-one journeys with mobile and email aspects, web experiences and social advertising. The Salesforce Marketing Cloud creates personalized and scalable data based email marketing campaigns designed for customer experiences across all channels.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Microsoft SQL Server Analysis Services (SSAS), ExactTarget and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.