SAP HANA (non-spatial)

Hi @canvass5071, would you be able to post this as a new question on our Q&A Forum? It's the best place to get answers from community members.

Ooops I meant to post that at top level. have tried this to great effect thank you Robyn and Mark2. The FME docs describe where to source the driver and where to put the required ngdbc.jar file in your FME install to make the generic JBDC R/W and the SAP R/W to work when writing records to SAP HANA.SAP Writer - FME Help docsRobyn's awesome JDBC driver tips: JDBC writer knowledgebase articlei copied the .jar to here:$apps/FME2016.1_64/plugins/ngdbc.jarand restarted FME.i believe you can also perhaps add a CLASSPATH env variable to your SAP HANA studio .jar file and FME will be happy. FME is always happy, you know 'happier' to hang out with SAP HANA. e.g. C:\Program Files\sap\hdbstudio\configuration\org.eclipse.osgi\147\0\.cp\lib\ngdbc.jarand then stored a DB connection.'a nice snippet of the HANA port number variants can be found here:The SQL port to be used for the connection.Port = 3xxyy where xx is the SAP HANA instance number and yy is a two-digit number as follows:Port = 3xx15 is for a SAP HANA single-container system.Port = 3xx13 is for the system database of a SAP HANA multitenant database container.and then kick off several long table writes to run concurrently. 71mil so far (last one still running) #statsRule@RetiredRobyn@XiaomengAtSafe

Do you have more informations about this Reader ? Thx

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

Hi There,   Thank you. Absolutely perfect! I was SOOOOO excited after seeing the blog and these instructions were absolutely wonderful! You’re a life saver!   I want your expert advice for following SAP Business One HANA environment. 1. SAP Business One Server tools is installed in Server01 2. SAP HANA Database is installed in Server02, where real time replication is done on Server03 based on SAP HANA High Availability configuration.  We are trying install Backup Service in server tools but, got an error that "Database is not running on current server". The XS engine allows web applications to build. SAP HANA Information Modeling (also known as SAP HANA Data Modeling) is a part of HANA application development SAP HANA training USA. is it possible to install backup service alone separately in Server02 and Server03, and schedule backup through either SLD or RSP.  Appreciate your effort for making such useful blogs and helping the community. Cheers, Kevin 

This has been released as part of FME 2016.1 . Visit http://www.safe.com/downloads to download and try it.

Hello Buddie,Nice tutorial! Let's keep our fingers crossed that this works. I would like to put this all to rest.I'm working on a protection and recovery procedure where I need to recover from a server failure of the local OS boot drives. Ideally I will have a backup image or file backups of the server OS boot volume; however, in the event I don't, how do I reinstall the SAP HANA . I am trying to test and document how I would recover the SAP HANA database server where I have mountable data, log, and shared volumes of my database and I just need to reinstall the SAP HANA server. My initial thought process was this should be simiple - install the OS, use hdblcm to reinstall the server, reconnect the volumes and reboot. Humm...there isn't an option for that...Appreciate your effort for making such useful blogs and helping the community.Obrigado,Rahul

I know a few things. FME accesses it via SAPs JDBC driver which must be installed separately. It does support FME's named database connections. I believe we support insert, update, and delete operations. Tables can be created/dropped/truncated. Most attribute types seem to be supported. I don't have a lot more than that at the moment, but do contact us (me) directly if you need info on specific items.

FME 2016.0 beta