- All solutions at a glance within the Azure Integration Services
- Automating Data Processes
- Integration as a service vs analytics integrations
In this blog we explain you all you need to know about Microsoft Data Integration Services. Microsoft Data Integration Services divides into two categories:
In this blog, we will only focus on the different solutions within the AIS platform.
AIS is mainly intended to move data and is an umbrella name for five solutions contained within it. You can think of transferring data from the various systems of an organization to a data warehouse (data hub) environment. AIS has connectors to make connections to such systems. The data that can be retrieved in different formats:
The different solutions within AIS can be divided into two application areas: Integration as a service and Analytics
IAAS is characterized by real-time data shifts between numerous systems and is often the heart of a company. Think of an order placed in a web application and moved to the accounting system and an order management system using an IPAAS (Integration Platform as a Service). This type of data integration is often near real-time and event-based. Also, many of the integrations are based on APIs. The solutions in the Azure Integration Services that are used for this include Logic Apps, Service Bus, API Management, and Event Grid
Different systems are made accessible in analytics applications, and this data from the various sources is written into a data hub. You can then use this data in many other systems. Consider, for example, the reporting tool PowerBI or Tableau. The loading and preparation of the data takes place separately in a central environment. This creates consistent results that can be reused. In this case, data (unlike IAAS) usually loads in batches. There is also a more direct connection to source systems, and data refreshes are usually scheduled or triggered. The Azure Integration Services solutions used for this include Logic Apps, Azure Data Factory, and Azure Analysis Services.
Here is a brief overview of these different solutions from both domains and what they can do:
With Rockfeather, we use these solutions by creating an intermediate layer when we retrieve the data from systems, whether this is for an IAAS question or more for an Analytics question.
For example, we provide access to the ERP system, an HR system, and a tool with an API. We can write all this to a data hub. We then use these as a source for the solutions as mentioned above. The advantage of this is that we can load the same results regardless of the solution. In addition, it is efficient and clear to retrieve the data and transform it where necessary. After we have all this down, it will continue to update fully automatically.
The fact that Power BI can be used to create dashboards is by now known to many organisations. However, many people do not know that there is a tool within Power BI that can help when there is a specific demand for (automated) PDF or Excel reports. This tool is called Power BI Report Builder. In this article, we will take a closer look at Power BI Report Builder to give you a better understanding of this tool.
As the worlds of Finance and IT are moving closer and closer, companies are looking to harvest the vast amounts of data within their domain and use it for their benefit. Our customers are looking to insert a data driven mindset within their company. On one hand that is achieved through a broader consumption of data within the company, but also to combine several data sources in one reporting platform.
On January 28th our webinar “The best-kept secret for better Power BI dashboards” took place. In this webinar, we showed you how to drastically improve your Power BI dashboards with the help of International Business Communication Standards (IBCS) and the Zebra BI plug-in. Click here to watch a recording of this free webinar.