Turning operational data into something people can decide on: business intelligence platforms, reporting, data warehousing, big data and the data engineering behind them. Our consultants share what they learned on analytics projects.
Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General…
FTIntegrity is used to verify indexing after migration or to get a status after a normal indexing. The tool is a standalone Java program that verifies all types that are registered in the dmi_registry_table with the user dm_fulltext_index_user. By default, the utility compares the object ID and i_vstamp between the repository and xPlore. In this blog I will share with…
Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d’Ouchy”. After a coffee and a welcome speech by Yann Neushaus, Ludovico Caldara and Flora Barriele, the event starts with 2 global sessions: A l’heure du serverless, le futur va-t-il aller aux bases de données distribuées? Franck Pachot makes a comparison between Oracle…
Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate your SQL Server instances, but some are missing that can be very useful. You have the possibility to move an SSISDB environment but this is only possible in another folder…
In the case you have the following configuration and requirements Your Power BI, paginated mobile KPI reports are published on your on premise Power BI Report Server (Named i.e. SRV-PBIRS), their data sources is an Analysis Services located on another server (Named i.e. SRV-SSASTAB\INST01, INST01 being the named instance) and you want to track/monitor who is accessing the data on…
Power BI 5 top custom visuals The development of Power BI itself is fast. But, the means to represent data is too. I mean there are constantly new Power BI custom visuals developed by the community and Microsoft. You can develop your own custom visuals and publish them on the marketplace for your organization or the whole community. Tips :…
Optimizing Multi-Billion Row Tables in Tabular in 2018 I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is stored and organized in a Tabular model. It is of course using the xVelocity in-memory capabilities with the Vertipac column storage…
The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the future” and Microsoft is working in this direction. The use of AI and analytic to transform the customer business is also a…
Designing Modern Data and Analytic Solution in Azure After having explained the pros and cons of Azure and the decision drivers for going to an Azure Architecture, some interesting messages were delivered like the decoupling of the storage and compute aspect on Azure, even if some of services still combine both. Another message that we all know but is essential…
Hitachi Content Intelligence (HCI) is a search and data processing solution. It allows the extraction, classification, enrichment, and categorization of data, regardless of where the data lives or what format it’s in. Content Intelligence provides tools at large scale across multiple repositories. These tools are useful for identifying, blending, normalizing, querying, and indexing data for search, discovery, and reporting purposes.…
This blog post describes how to create a hosted Cloudera repository and use it in your Cloudera Manager deployment. The first step is to install a web server, which will host RPM packages and repodata. The common way, is to use an Apache web server. Installing Apache HTTPD service [cdhtest@edge ]$ sudo yum install httpd -y Starting Apache HTTPD…
Let’s assume we need to create an HDFS home directory for a user named “dbitest”. We need first to verify if the user exists on the local filesystem. It’s important to understand that HDFS is mapping users from the local filesystem. [cdhtest@master ~]$ cat /etc/passwd | grep dbitest Create a user on the local file system When the user is…
