Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

importing data from microsoft sql server to sqoop

importing data from microsoft sql server to sqoop

New Contributor

I need to import data from Microsoft SQL server using sqoop 2. I've seen lots of examples connecting to MySQL, but nothing on SQL Server. Is this possible?

1 REPLY 1
Highlighted

Re: importing data from microsoft sql server to sqoop

Expert Contributor
It should be. The Generic JDBC Connector should be able to connect to MS SQL server. It's important to make sure the SQL server JDBC jar is included in Sqoop2 server's classpath via /var/lib/sqoop2 directory.
Don't have an account?
Coming from Hortonworks? Activate your account here