Back to overview
Today we are delving into a classic area of the data warehouse. This article deals with the topic of outbound and in particular with the creation of generic XML exports using the XMLAGG database function in conjunction with Informatica PowerCenter....
With Terraform as an Infrastructure as Code (IaC) tool, IT infrastructures (such as virtual servers, networks, containers, storage, etc.) can be configured in an infrastructure code. This allows changes to be made quickly, securely and automatically in...
At in-factory, all employees meet twice a year for further training or a team event, which takes place for one or two days in a hotel. In the past, this has mostly involved presentations by employees on customer-specific topics.
In our "BigData" project at an automobile manufacturer, deployment became an increasingly important point in the development of the software. Due to the increased scope of the packages and the diverse environments, combined with the requirement to create an environment...
Many web applications today consist of a JavaScript frontend (Angular, React, Svelte, etc.) and a separate backend. One of the most popular backend options are REST APIs. Most of the web applications that we develop for one of our clients...
Data architectures for business intelligence systems Based on the definition of the data warehouse according to William H. Inmon[1], the hub-and-spoke approach is first presented as a fundamental architecture in the data warehouse environment. Building on this, the...
The Data Vault method and its most important elements In this article, the Data Vault method is first introduced in principle and the modeling approach is explained using a case study. A data vault model consists of the following three components:...
This blog entry gives a quick insight into Git basics, is aimed at beginners and is intended to make working and getting started easier. The very first steps are shown, the most important functions are presented, and the advantages and disadvantages are...
Nowadays, most of the applications we use are based on a so-called 3-tier architecture. In this article, we will take a closer look at this architecture and the most commonly used technology stack. First, the...
With fresh input from MicroStrategy World 2022, our Business Intelligence experts introduce you to the elements of MicroStrategy 2020 in this blog article. MicroStrategy 2020 Software Architecture This software consists of 4 layers, which in turn consist of...
With fresh input from MicroStrategy World 2022, our business intelligence experts share their MicroStrategy schema know-how and best practices with you. How does the MicroStrategy schema work? Basically, BI software does not "invent"...
MicroStrategy World 2022 took place at the beginning of February. Our BI experts Aleksandar Cupic and Felix Hoffacker were there and share their experiences with you here. The two-day online event covered two thematic blocks: Agenda Analytics and...
Optimize your website (SEO-compliant) - but how? The question of why you should optimize your website almost answers itself. You want to be found and seen. This is why the topic of search engine optimization (SEO) falls into the category of marketing....
What is Cloud Application Integration (CAI)? CAI is the provision of applications and data in the cloud. CAI is part of the Informatica Intelligent Cloud Services (IICS). With CAI, it is possible to create easy-to-use cloud applications even without programming...