With DataSync, customers share data out to a database that can be queried by a multitude of reporting and analytics tools such as Tableau and Microsoft Power BI.

In some cases, customers will create database views by doing joins and unions of different tables replicated with DataSync to create reports and analytics to meet their business needs. Below are some example database view queries that you may find useful: 

Microsoft SQL Server

Below outlines the most commonly used Microsoft SQL Commands utilized with most Perspectium integrations:

JOIN

A Join statement is used to combine data or rows from two or more tables based on a common field between them. The table below outlines the join relationship between two tables and a brief explanation of the use cases.

[dbo].[sys_user] [sys_user] ON ([cmdb_ci].[assigned_to] = [sys_user].[sys_id])

LEFT JOIN [dbo].[task_sla] [task_sla] ON ([incident].[number] = [task_sla].[dv_task])

LEFT JOIN [dbo].[cmn_location] [cmn_location] ON ([incident].[location] = [cmn_location].[sys_id])

LEFT JOIN [dbo].[sys_user] [sys_user] ON ([incident].[caller_id] = [sys_user].[sys_id])

LEFT JOIN [dbo].[sys_user] [sys_user] ON ([incident].[dv_caller_id] = [sys_user].[name])

INNER JOIN `cmdb_ci` ON (`incident`.`cmdb_ci` = `cmdb_ci`.`sys_id`)

LEFT JOIN [dbo].[task_sla] [task_sla] ON ([task].[number] = [task_sla].[dv_task])