question Re: Sqoop: connect to random dbms? in Support Questions

Sqoop: connect to random dbms?

Vhodnoylogin — Fri, 16 Sep 2022 14:10:19 GMT

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?

Re: Sqoop: connect to random dbms?

Harsh J — Tue, 19 Feb 2019 14:25:17 GMT

> 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#p1a7nrsg36gaf8n1j33tfwf7nsj7.htm
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).

Re: Sqoop: connect to random dbms?

Vhodnoylogin — Tue, 19 Feb 2019 14:28:31 GMT

Wow, thanks. It looks as solution.