For this test I used the ServiceNow Developer Sandbox and a local instance of SAP HANA express edition

First of all you must download the jdbc driver for SAP HANA DB ngdbc.jar. I found and download the driver from Internet.

Following this step I uploaded the driver to my midserver.

• I navigated to MID Server > JAR Files.
• I clicked New.
• I completed the following fields:
  
  1. Name: SAP HANA
     
  2. Description: SAP HANA
• I clicked the paper clip icon in the banner and attached the JAR(ngdbc-2.3.62.jar) file to the record
• I restarted the MID Server service.

Then I added the new JDBC format choice following this is the procedure:

• I navigated to System Import Sets > Administration > Data Sources.
• I clicked New, in the Data Sources form, right-clicked the Format field label, and select Show Choice List from the pop-up menu.

• I clicked New in the list of choices.
• I provided the following values to create the new database choice.
  
  1. Table: sys_data_source
     
  2. Label: HANA
     
  3. Value:com.sap.db.jdbc.Driver
     
  4. Dependent value: JDBC

The new data source now appears in the list of available JDBC formats.

Last step was create a new data source.

• I navigated to System Import Sets > Administration > Data Sources and clicked New.
• In the Data Source form, I selected JDBC from the list in the Type field.
• I selected the “HANA” from the choice list in the Format field.
• I added the Connection URL field configuring the form.

• I provided the connection URL: jdbc:sap://localhost:30015/?currentSchema=SAPECC

Here is the result:

Some useful link:

I hope this post is useful.

See you.