Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop: connect to random dbms?

avatar

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

avatar
Mentor
> 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).

View solution in original post

2 REPLIES 2

avatar
Mentor
> 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).

avatar
Wow, thanks. It looks as solution.