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.

Sqoop: connect to random dbms?

Solved Go to solution

Sqoop: connect to random dbms?

Hi.

 

I need to import data from non-trivial dbms: SAS (it isn't db at all)...

So, i have jdbc-driver (class "com.sas.rio.MVADriver"), and i have socket (host and port). And i have no connection-manager at all.

 

What should i do? How to write working import-string?

1. What about connection-manager

2. "driver" looks like 

jdbc:mysql://<ip>:<port>/

 So "mysql" is strange part of it. How to replace it?

3. Where must i put drives (jar-files) to use it from sqoop?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sqoop: connect to random dbms?

Master Guru
> 1. What about connection-manager

When there's no specialized connection manager, Sqoop will use its
generic/standard one that's inbuilt. There's a chance this may be adequate.

> 2. "driver" looks like
> jdbc:mysql://:/
> So "mysql" is strange part of it. How to replace it?

Your JDBC driver download should have come with a manual that shows how and
what to use as its connection string. Searching over the web reveals
http://support.sas.com/documentation/cdl/en/jdbcref/63713/HTML/default/viewer.htm#p1a7nrsg36gaf8n1j3...
which seems to suggest jdbc:sasiom://host:port (and other options).

> 3. Where must i put drives (jar-files) to use it from sqoop?

Place it directly under /var/lib/sqoop/, preferably on all hosts (if your
Sqoop command may run from any host).
2 REPLIES 2

Re: Sqoop: connect to random dbms?

Master Guru
> 1. What about connection-manager

When there's no specialized connection manager, Sqoop will use its
generic/standard one that's inbuilt. There's a chance this may be adequate.

> 2. "driver" looks like
> jdbc:mysql://:/
> So "mysql" is strange part of it. How to replace it?

Your JDBC driver download should have come with a manual that shows how and
what to use as its connection string. Searching over the web reveals
http://support.sas.com/documentation/cdl/en/jdbcref/63713/HTML/default/viewer.htm#p1a7nrsg36gaf8n1j3...
which seems to suggest jdbc:sasiom://host:port (and other options).

> 3. Where must i put drives (jar-files) to use it from sqoop?

Place it directly under /var/lib/sqoop/, preferably on all hosts (if your
Sqoop command may run from any host).
Highlighted

Re: Sqoop: connect to random dbms?

Wow, thanks. It looks as solution.