Skip to main content
Solved

Adding SAP HANA ngdbc.jar to FME Server config

  • March 8, 2018
  • 3 replies
  • 110 views
scyphers
Participant
Forum|alt.badge.img+5

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?

Best answer by richardatsafe

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

richardatsafe
Safer
Forum|alt.badge.img+10
  • richardatsafeSafer
  • Safer
  • 217 replies
  • Best Answer
  • March 9, 2018

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

scyphers
Participant
Forum|alt.badge.img+5
  • scyphersParticipant
  • Author
  • Participant
  • 22 replies
  • March 13, 2018

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.

 

 

C
Forum|alt.badge.img
  • chide6325
  • 2 replies
  • April 20, 2018

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

Community Stats

32,087
Posts
121,852
Replies
39,729
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.