Skip to main content
Solved

Adding SAP HANA ngdbc.jar to FME Server config

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

View original
Did this help you find an answer to your question?

3 replies

richardatsafe
Safer
Forum|alt.badge.img+10
  • richardatsafeSafer
  • Safer
  • 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
  • March 13, 2018
richardatsafe wrote:

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
  • 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

Reply


Helpful Members This Week

Community Stats

30,983
Posts
117,425
Replies
38,765
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.