AnsweredAssumed Answered

GRLoader-Load data from Oracle database

Question asked by Lovaraju_KB on Feb 27, 2015
Latest reply on Mar 2, 2015 by Mark_HE


Hi All,

 

I am looking for the syntax of the GRLoader command to load data from a Oracle DB ( Eg:MyTable in TESTDB on TESTHOST ). In the technical guide example available for SQLServer but no example for  Oracle. 

I have the driver jar files(odbc5,odbc6 etc) available on my server which came with Oracle Client installation.

 

Syntax:

 

GRLoader -dbdriver ? -dburl ? -dbuser testuser -dbpswd password -s http://hostname:8080 -a -n -E -dbstmt "Select xxxxx from MyTable" -e jdbc_err.xml

 

Now what should I mention for dbdriver and dburl?

 

Thanks,

Lova

Outcomes