Idea by FMELizard · Oct 29, 2015 at 03:34 PM · enterprise capabilities formats real-time

SAP HANA (non-spatial)

Add comment

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

canvass5071 commented · Mar 21, 2018 at 02:57 PM

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" target="_blank">https://asha24.com/blog/sap-hana-studio-download-and-installation-guide">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

Add comment · Show 2

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

TiaAtSafe · Mar 21, 2018 at 05:26 PM 0

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.

canvass5071 · May 30, 2018 at 09:53 AM 0

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

scyphers commented · Jul 13, 2016 at 06:19 PM

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 docs

Robyn's awesome JDBC driver tips: JDBC writer knowledgebase article

i copied the .jar to here:

$apps/FME2016.1_64/plugins/ngdbc.jar

and 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.jar

and 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

Add comment

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

fmemeister commented · May 08, 2016 at 02:20 AM

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

Add comment

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

Mark2AtSafe commented · Nov 23, 2015 at 04:04 PM

FME 2016.0 beta

Add comment · Show 2

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

julien · Nov 27, 2015 at 02:52 PM 0

Do you have more informations about this Reader ? Thx

Mark2AtSafe ♦♦ julien · Nov 27, 2015 at 06:10 PM 1

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.

SAP HANA (non-spatial)

4 Comments

Your Opinion Counts

IDEA DETAILS

Related Ideas