Sqoop: connect to random dbms?

Question

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?

Harsh J · Accepted Answer

> 1. What about connection-managerWhen there's no specialized connection manager, Sqoop will use itsgeneric/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 andwhat to use as its connection string. Searching over the web revealshttp://support.sas.com/documentation/cdl/en/jdbcref/63713/HTML/default/viewer.htm#p1a7nrsg36gaf8n1j33tfwf7nsj7.htmwhich 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 yourSqoop command may run from any host).

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.