Highlighted
Cadet 3rd Class
Cadet 3rd Class
646 views

Driver for SAP HANA

Jump to solution

Hi,

We are asked to integrate SAP HANA with NetIQ IDM. I see that there is no native connector against this system in the NetIQ IDM 4.8 documentation. Have any of you integrated it before using a JDBC, LDAP or webservices connector? Any help will be welcome.

Best Regards,

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Commander
Commander

https://www.netiq.com/documentation/identity-manager-47-drivers/jdbc/data/auto-configure-jdbc-driver-parameters.html

More detail above

requirements

ngdbc.jar - You can download on SAP. copy this file to <eDirectory installation>/eDirectory/lib/dirxml/classes 

- JDBCConfig.jar - <eDirectory installation>/eDirectory/lib/dirxml/classes

 

Steps:

1 - Creating your custom driver JDBCCustomConfig.jar

  a. copy JDBCConfig.jar to JDBCCustomConfig.jar and uncompress JDBCCustomConfig.jar. Remove all unnecessary files. You only need the files I am indicating below.  

 b. Under JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver 

  create a xml that represent your new driver. In my case I created a file named as  saphana_jdbc.xml. 

And under  JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/db a file named as saphana.xml

c. content of saphana_jdbc.xml and saphana.xml

Content of saphana_jdbc.xml

JDBCdriverXML fig1.png

 

 

 

 

 

 

 

 

 

 

Content of saphana.xml

JDBCdriverXML fig4.png

 

d. define the drive description for type and  codes

JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import

saphana_types.xml

JDBCdriverXML fig2.png

saphana_codes.xml

JDBCdriverXML fig3.png

 

 

 

e . compress your JDBCCustomConfig.jar and copy to <eDirectory installation>/eDirectory/lib/dirxml/classes. Restart nds.

f. check your JDBCCustomConfig.jar 

 jar tf JDBCCustomConfig.jar

META-INF/

META-INF/MANIFEST.MF

com/

com/novell/

com/novell/nds/

com/novell/nds/dirxml/

com/novell/nds/dirxml/driver/

com/novell/nds/dirxml/driver/jdbc/

com/novell/nds/dirxml/driver/jdbc/db/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/import/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/saphana.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/saphana_jdbc.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/saphana_codes.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/saphana_types.xml

 

g . configure your JDBC driver for Hana DB

JDBCHana figure1.png

 

JDBCHana figure2.png

 

 

 

 

 

 

 

 

 

JDBCHana figure3.png

 

JDBCHana figure4.png

 

 

View solution in original post

8 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

The suggested integration path is to configure SAP HANA for LDAP authentication with an eDirectory authentication tree. (See https://blogs.sap.com/2019/05/07/ldap-based-authentication-for-sap-hana-2.0/)

Additionally you can use a JDBC driver if you have not enabled automatic user creation or if you want to programmatically map LDAP groups to SAP HANA roles.

--
Norbert
Highlighted
Commander
Commander

We are integrated with JDBC driver. Was necessary to create a descriptor for this database. It is working but I Opened a service request for microfocus in order to receive an official descriptor created by microfocus team. Until now I am working with my own descriptor. best regards.

Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

I am curious, what did you need to chaneg in your custom descriptor file?  I.e. How wonky is the DB?

 

You can read more about the descriptors in this article I wrote way back in 2007!!!

https://community.microfocus.com/t5/Identity-Manager-Tips/Using-the-JDBC-IDM-Driver-with-Custom-Descriptor-Files/ta-p/1773355

 

Oldy but wordy...

 

0 Likes
Highlighted
Commander
Commander
I Will share with you later. But if you decide to use it is at your own risk.
Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Always the case!

More I am curious how the DB looks to a driver, different than a standard DB.

Getting info on SAP is often tricky. Big beast of a product and complicated as heck.

0 Likes
Highlighted
Commander
Commander

https://www.netiq.com/documentation/identity-manager-47-drivers/jdbc/data/auto-configure-jdbc-driver-parameters.html

More detail above

requirements

ngdbc.jar - You can download on SAP. copy this file to <eDirectory installation>/eDirectory/lib/dirxml/classes 

- JDBCConfig.jar - <eDirectory installation>/eDirectory/lib/dirxml/classes

 

Steps:

1 - Creating your custom driver JDBCCustomConfig.jar

  a. copy JDBCConfig.jar to JDBCCustomConfig.jar and uncompress JDBCCustomConfig.jar. Remove all unnecessary files. You only need the files I am indicating below.  

 b. Under JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver 

  create a xml that represent your new driver. In my case I created a file named as  saphana_jdbc.xml. 

And under  JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/db a file named as saphana.xml

c. content of saphana_jdbc.xml and saphana.xml

Content of saphana_jdbc.xml

JDBCdriverXML fig1.png

 

 

 

 

 

 

 

 

 

 

Content of saphana.xml

JDBCdriverXML fig4.png

 

d. define the drive description for type and  codes

JDBCCustomConfig/com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import

saphana_types.xml

JDBCdriverXML fig2.png

saphana_codes.xml

JDBCdriverXML fig3.png

 

 

 

e . compress your JDBCCustomConfig.jar and copy to <eDirectory installation>/eDirectory/lib/dirxml/classes. Restart nds.

f. check your JDBCCustomConfig.jar 

 jar tf JDBCCustomConfig.jar

META-INF/

META-INF/MANIFEST.MF

com/

com/novell/

com/novell/nds/

com/novell/nds/dirxml/

com/novell/nds/dirxml/driver/

com/novell/nds/dirxml/driver/jdbc/

com/novell/nds/dirxml/driver/jdbc/db/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/import/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/db/saphana.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/saphana_jdbc.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/saphana_codes.xml

com/novell/nds/dirxml/driver/jdbc/db/descriptor/driver/import/saphana_types.xml

 

g . configure your JDBC driver for Hana DB

JDBCHana figure1.png

 

JDBCHana figure2.png

 

 

 

 

 

 

 

 

 

JDBCHana figure3.png

 

JDBCHana figure4.png

 

 

View solution in original post

Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Now that is what I call an excellent response.  Thank you, that was as comprehesive as I have seen a post.

Well done indeed.

Highlighted
Commander
Commander

I updated my post because was missing a file. Now it is ok. I created the JDBCCustomConfig.jar based on JDBCConfig.jar. I wanna to emphasize this descriptor is not completed considering all codes and types that exists on Hana Db. But it is working fine here more than 1 year. I hope you can help us to ask microfocus a compromise to write an official descriptor to be used more safely. Thanks. I hope I've helped.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.