Connecting to SQL Server using SQOOP

gvamsimba
gvamsimba used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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/
gvamsimbaIT Consultant

Author

Commented:
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
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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..
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

gvamsimbaIT Consultant

Author

Commented:
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
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Simple, assign an IP to your SQL Server 2017 on Docker so that SQL Server can be accessed on this IP.
Your Cloudera Virtual Box should also have an IP available..
If both these IP's are reachable or pingable, then you should be able to connect with each other.

If you don't have an IP assigned to your SQL Server 2017 on Docker or it is not pingable with your Cloudera Virtual Box, then you can work with your System admin or network admin to ensure these IP's are communicable.
gvamsimbaIT Consultant

Author

Commented:
good.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome, glad to assist!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial