Reply
New Contributor
Posts: 3
Registered: ‎04-02-2015

importing data from microsoft sql server to sqoop

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?

Highlighted
Cloudera Employee abe
Cloudera Employee
Posts: 109
Registered: ‎08-08-2013

Re: importing data from microsoft sql server to sqoop

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.
Announcements