Skip to main content
  • EN

How does one add the ngdbc.jar SAP HANA driver to FME Server and update the FME Server Config?

I have tried to publish a script reading tables using both Native HANA reader and the generic JDBC reader connection and the script will not run. The error is java.sql.SQLException: No suitable driver found

I presume the ngdbc.jar file needs to be here, and FMEServer restarted?

C:\\$apps\\FMEServer\\Server\\lib

Can someone please assist me in setting up the drivers and subsequent CommonConfig changes on FME Server?

Hi @scyphers,

Yes the jar usually goes on the share and server does need to be restarted, but the jars usually need to be placed here: <FMEServerSystemShare>/Resources/engine/Plugins/Java so it can be shared with all the engines. Please have a look at the document below.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/jdbc/getting_started_jdbc.htm

Thanks,

Richard

Hi @scyphers,

Yes the jar usually goes on the share and server does need to be restarted, but the jars usually need to be placed here: <FMEServerSystemShare>/Resources/engine/Plugins/Java so it can be shared with all the engines. Please have a look at the document below.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/jdbc/getting_started_jdbc.htm

Thanks,

Richard

Thank you Richard, apologies I had not checked-in in a few days. I did look around in the Docs for JDBC but i clearly did a Steve Look. I will read the docs page at the link and have deposited the driver in the plugins folder described above. I will get it working now.

 

 

Hi
There,

Thank
u For sharing this unique article. Definitely a life saver.

 


 


Need your help to validate if solution recommended
by SUSE support to upgrade the existing kernel - 4.4.21-69.1 ( SP2-Nov-2016
) to latest available kernel - 4.4.114-92.67.1 ( Feb-27-2018 ) for SLES
12.2 SAP Application SP2 is compatible / supported for on Hyper-V VMs.called?Appreciate your effort for making such useful blogs and helping the community.

Many
Thanks,

Irene
Hynes

Reply


Community Stats

30,469
Posts
115,713
Replies
38,289
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.