Member since
02-07-2018
3
Posts
0
Kudos Received
0
Solutions
02-08-2018
05:35 PM
Hello folks, I am facing knowledge gap while trying to work with Cloudera CHD with AWS services . The issues enlisted down, I am pretty sure these have been faced and resolved, given the popularity of cloud hosted ms-sql servers. Would be grateful to recieve help I was able to solve the "class not found"issue by downloading another jar file from this website : http://www.java2s.com/Code/Jar/s/Downloadsqljdbc420jar.htm and added to the sqoop2 library. This is done with the Generic-jdbc- connector. However, I am not able to establish the connection , and I suspect the problem is with the JDBC connection string. I am supposed to connect from the sqoop's Cloudera Quickstart VM to MS-SQL server that is running on the AWS RDS instance. So the syntax of the Connection string I have given is as follows: jdbc:sqlserver://<RDS end point DNS>:<Port Name>/<DataBase name> I have configured the security group of my RDS instance to allow outbound connections, so this could rule out the firewall issues(I suppose) I have an understanding void with the RDS end point DNS value being resolved into an IP address The IP address the DNS lookup provides isn't static and tend to chane for failover reasons, could this be the issue to establish a connection? Thank you for your time.
... View more
02-08-2018
07:09 AM
My database runs on Microsoft Sql Server.
... View more
02-07-2018
11:42 AM
Which connector was used to solve this issue ? I am using the generic jdbc connector that came with my sqoop 1.99.5. I have no luck with the class name of the microsoft jdbc driver that you mentioned. It says the class is not found. I am assuming it has to do with the connector and not the driver. As I have placed my sqlserver jar file in sqoop library. However, in my cloudera quickstart terminal,when I list files in the sqoop library, I find that the "mysql-connector-java.jar" is color coded in blue and "sqljdbc41.jar" is color coded in red. Any light on what does this mean? Thank you for your time.
... View more