With the rapid growth of data, the Apache Hadoop open-source ecosystem has gained significant momentum, centered around its core components: the distributed file system (HDFS) and MapReduce. Today, establishing connectivity between SQL Server and Hadoop is crucial due to their complementary nature. Hadoop efficiently manages petabytes of unstructured data with longer query times, while SQL Server 2012 handles terabytes of structured data with rapid query capabilities, necessitating seamless data integration between the two platforms.