Hi I am hadoop beginner and exploring some hadoop options from our existing project. here is my question.
We have Hortonnetwork version of hadoop on windows.
Iam trying to use below command to load data from on-premisis sql server to HDFS :
sqoop list-databases –connect jdbc::sqlserver://<servername>:1433 –username <MyUserName> –password <MyPassword>
This is just to check my connection before pulling actual tables in HDFS..but the command throws below error :
“Got error creating database manager: java.io.IOException: No manager for connect string: jdbc::sqlserver:<Servername>”
few background points:
– Able to ping the server from hadoop server.
– Have copied sqljdbc4.jar file to sqoop/lib directory.
-sql server 2012
Can anyone share their experiences/solutions if you have any such.