Ask Your Question

Can Data Collector ingest data from HP NonStop Database to Hadoop?

asked 2019-08-27 15:48:06 -0600

Goth gravatar image

updated 2019-08-28 23:07:11 -0600

metadaddy gravatar image

Does StreamSets Data Collector have the capability to ingest data from HP NonStop Database to Hadoop?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-08-28 23:05:41 -0600

metadaddy gravatar image

updated 2019-08-28 23:10:04 -0600

See the PDF NonStop JDBC Type 4 Driver Programmer's Reference for SQL/MX for instructions on retrieving the JDBC driver, t4sqlmx.jar.

You should install this file into Data Collector as an external library and use either the JDBC Query Consumer or JDBC Multitable Consumer Origin with a JDBC URL of the form:

jdbc:t4sqlmx://ip_address|machine_name:port_number/[:][property=value [;property2=value2]...]

You can then use the Hadoop FS Destination to write the data to Hadoop.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-27 15:48:06 -0600

Seen: 68 times

Last updated: Aug 28 '19