<div>
Yes, you can load from SQL Server to HDFC using SQOOP..<br />
Please find the step by step instructions for your reference.<br />
<a href="https://www.mssqltips.com/sqlservertip/4426/use-sqoop-to-load-data-from-a-sql-server-table-to-a-hadoop-distributed-file-system/" rel="ugc">https://www.mssqltips.com/sqlservertip/4426/use-sqoop-to-load-data-from-a-sql-server-table-to-a-hadoop-distributed-file-system/</a>
</div>


Yes, you can load from SQL Server to HDFC using SQOOP..
Please find the step by step instructions for your reference.
https://www.mssqltips.com/sqlservertip/4426/use-sqoop-to-load-data-from-a-sql-server-table-to-a-hadoop-distributed-file-system/ [https://www.mssqltips.com/sqlservertip/4426/use-sqoop-to-load-data-from-a-sql-server-table-to-a-hadoop-distributed-file-system/]

<div>
Hi Raja, yes but I am using mac and I have installed SQL Server 2017 on mac using Docker. &nbsp;now how do I connect to this sql server using SQOOP which is in my cloudera virtual box. I already copied jdbc driver file into SQOOP folder. What are the the next steps ?<br />
<br />
Thanks
</div>


Hi Raja, yes but I am using mac and I have installed SQL Server 2017 on mac using Docker.  now how do I connect to this sql server using SQOOP which is in my cloudera virtual box. I already copied jdbc driver file into SQOOP folder. What are the the next steps ?

Thanks

<div>
Not a Mac user, however kindly check the below items:<br />
1. Kindly confirm whether your SQL Server 2017 on Docker and your HDFS on Cloudera Virtual box can ping each other or not as that is required for any data transfer to happen. If not, then you might need to get it fixed out..<br />
2. If they are accessible, then you can simply follow the steps mentioned in the above link from your Cloudera Virtual box using SQOOP command..
</div>


Not a Mac user, however kindly check the below items:
1. Kindly confirm whether your SQL Server 2017 on Docker and your HDFS on Cloudera Virtual box can ping each other or not as that is required for any data transfer to happen. If not, then you might need to get it fixed out..
2. If they are accessible, then you can simply follow the steps mentioned in the above link from your Cloudera Virtual box using SQOOP command..

<div>
Hi Raja, can you please let me know how to see if &nbsp;my SQL Server 2017 on Docker and your HDFS on Cloudera Virtual box can ping each other or not ?<br />
<br />
Thanks
</div>


Hi Raja, can you please let me know how to see if  my SQL Server 2017 on Docker and your HDFS on Cloudera Virtual box can ping each other or not ?

Thanks

IT Consultant

gvamsimba

<div>
<div class="content wysiwyg-content">
I have installed &nbsp;SQL Server 2017 on my Mac on Docker along with SQL Server Azure Data studio . &nbsp;I have Cloudera virtual box installed on this Mac with Hadoop<br />
<br />
Now I need to connect to my SQL Server 2017 and import a table into HDFC using SQOOP &nbsp;. Can anyone please tell me what exactly I need to do to achieve this ?<br />
<br />
Many Thanks
</div>
</div>


I have installed  SQL Server 2017 on my Mac on Docker along with SQL Server Azure Data studio .  I have Cloudera virtual box installed on this Mac with Hadoop

Now I need to connect to my SQL Server 2017 and import a table into HDFC using SQOOP  . Can anyone please tell me what exactly I need to do to achieve this ?

Many Thanks

Connecting to SQL Server using SQOOP

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Big data describes data sets that are so large or complex that traditional data processing applications are inadequate. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying and information privacy. The term often refers simply to the use of predictive analytics or certain other advanced methods to extract value from data, and seldom to a particular size of data set.

Big Data

Docker is a computer program used to run software packages called containers in an operating-system-level virtualization process called containerization. It’s developed by Docker, Inc. and was first released in 2013.

Docker

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.