Reply
Explorer
Posts: 23
Registered: ‎12-10-2018
Accepted 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?

Posts: 1,893
Kudos: 432
Solutions: 302
Registered: ‎07-31-2013

Re: Sqoop: connect to random dbms?

> 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
Explorer
Posts: 23
Registered: ‎12-10-2018

Re: Sqoop: connect to random dbms?

Wow, thanks. It looks as solution.
Announcements
New solutions