Use Microsoft SSIS to Interact with Big Data (Cloudera)
Big Data, today could make larger space into the field of Data warehousing and business intelligence for obvious reasons, speed, reliability and cost.
Data integration in big data is most crucial part of any Big Data engineer.
Till date thru various researchers and via developers, we know that there are so many tools are around when it comes to ETL into big data world and Microsoft SSIS (Microsoft SQL Server Integration service) is no behind here.
This article will describe how one can leverage the power of Microsoft SSIS to interact with Big Data, especially with Cloudera Big Data Eco-system.
Before we begin, here is the list of pre-requisite tools.
Clearly, we can see, we are going to use Open Database Connectivity here to interact with Cloudera Big Data using Microsoft SSIS.
Please note, this solution is applicable to SSIS/Data tools version 2012 or above only.
You can see an entire tutorial with a real-world working example in the link below.
Feel free to spread the knowledge and add your comments to improve it.