Member since
05-21-2014
6
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