# JDBC Connection to SAP HANA

**URL:** <https://discuss.elastic.co/t/jdbc-connection-to-sap-hana/123193>\
**Category:** Logstash\
**Created:** [March 9, 2018, 5:41am UTC](https://discuss.elastic.co/t/jdbc-connection-to-sap-hana/123193 "2018-03-09T05:41:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chandra\_Bhandaru](https://avatars.discourse-cdn.com/v4/letter/c/858c86/32.png) [@Chandra\_Bhandaru](https://discuss.elastic.co/u/Chandra_Bhandaru)\
**Post date:** [March 9, 2018, 5:41am UTC](https://discuss.elastic.co/t/jdbc-connection-to-sap-hana/123193/1 "2018-03-09T05:41:01Z")

</div>

Below is my config and I am not able to connect to SAP HANA. I have right driver and am able to connect via standalone java program.  
input {  
jdbc {

```
    jdbc_connection_string => "jdbc:sap://<host:port>"
    jdbc_user => "<user>"
jdbc_password => "<password>"
    jdbc_driver_library => "C:/tools/lib/SAP_Hana_ngdbc.jar"
    jdbc_driver_class => "com.sap.db.jdbc.Driver"
    statement => "SELECT * from test"
}

```

}

Error:

connection\_retry\_attempts\_wait\_time=\>0.5, parameters=\>{"sql\_last\_value"=\>1970-01-01 00:00:00 UTC}, last\_run\_metadata\_path=\>"C:\Users\/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\>  
Error: Java::JavaSql::SQLException: No suitable driver found for jdbc:sap://host:port  
Exception: Sequel::DatabaseConnectionError

Command:

logstash -f logstash.conf --debug --log.level=debug --verbose --config.debug

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 6, 2018, 5:41am UTC](https://discuss.elastic.co/t/jdbc-connection-to-sap-hana/123193/2 "2018-04-06T05:41:17Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.