Category Archives: Business Intelligence

Business Intelligence solutions, ETL, Analysis, Reporting, Dashboards.

Talend job to lookup geographic coordinates into a shape file

Introduction Recently for an open data integration project I had to select some tools in order to be able to process geospatial data. I had a couple of choices: I could use R and try to work out a solution … Continue reading

Posted in Business Intelligence, Geospatial data, Open Data, Talend | Tagged , , , , | 2 Comments

Connect to Hive using Teradata Studio 16

Introduction Teradata Studio is the client used to perform database administration task on Aster and Teradata databases, as well as moving data from and to Hadoop. Recently I was asked to test a solution to integrate Hadoop with Teradata in … Continue reading

Posted in Big Data, hadoop, Teradata | Tagged , , , , | 9 Comments

Teradata Express 15.10 Installation using Oracle VirtualBox

Introduction For professional reasons I needed to start learning Teradata after some years of intensive Microsoft BI projects. To start breaking the ice and have a playground to test everything I want, I decided to download the newest Teradata Express … Continue reading

Posted in Business Intelligence, Teradata, VirtualBox | Tagged , , , , , , | 5 Comments

Introduction to R Services and R client – SQL Server 2016

Introduction After some time using R and SQL server as two different tools (not 100% true because I already have imported data from SQL Server into R Studio), now Microsoft is offering as part of the SQL Server 2016 R … Continue reading

Posted in Analytics, Business Intelligence, R, SQL Server | Tagged , , , | 1 Comment

Export data to Hadoop using Polybase – Insert into external table

Introduction This post is a continuation of Polybase Query Service and Hadoop – Welcome SQL Server 2016 One of the most interesting use cases of Polybase is the ability to store historical data from relational databases into a Hadoop File System. … Continue reading

Posted in Big Data, hadoop, SQL Server | Tagged , , , , | 17 Comments

Polybase Query Service and Hadoop – Welcome SQL Server 2016

Introduction One of the coolest features of SQL Server 2016 is Polybase. Already available for Parallel Data Warehouse, this functionality is now integrated in SQL Server 2016 and allows to combine relational and non-relational data, for example, query data in … Continue reading

Posted in Big Data, Business Intelligence, Data Processing Engines, hadoop, SQL Server | Tagged , , , | 2 Comments

My experience building Hadoop 2.7.1 on Windows Server 2012

Introduction Building the Hadoop sources on windows could be cumbersome even when the official documentation states: “… building a Windows package from the sources is fairly straightforward”. There are several good resources containing the steps needed in order to successfully … Continue reading

Posted in Big Data, hadoop | Tagged , , , , , , | 2 Comments