Following are the steps for connecting Securonix with SAP HANA to import data:

  1. Get the file: ngdbc.jar from the SAP Client installation (Not available openly on the internet, available with SAP Hana Client installation only).
  2. Put the jar file in path : /webapps/Profiler/WEB-INF/lib of Securonix Installation.
  3. Restart the application. (Now the jar will be in the application's classpath and will be able to get referenced).
  4. While creating the datasource, select any database from the database type drop down (eg- MySQL). We can now enter the JDBC URL, Driver class and the connection details there.
  5. Put JDBC Driver class as : com.sap.db.jdbc.Driver
  6. Put JDBC URL as jdbc:sap://<server_hostname>:30015/?autocommit=false
  7. Put the credentials for the server below in the username/password fields and press Test Connection/Save & Close.

Apart from these steps, please also check sufficient privileges have been provided to the user accessing the database.

Reference : http://help.sap.com/saphelp_hanaplatform/helpdata/en/ff/15928cf5594d78b841fbbe649f04b4/content.htm

asked 10 Feb, 11:48

tdawer's gravatar image

tdawer
252
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1
×1
×1
×1

Asked: 10 Feb, 11:48

Seen: 37 times

Last updated: 10 Feb, 11:48

Related questions