SAP SQL Anywhere

Try Pentaho Data Integration and Analytics

Version

9.3.x

Audience

anonymous

Part Number

MK-95PDIA000-11

Vendor Name	Details
Recommended Native Driver
SAP	Company URL: https://www.sap.com/products/sql-anywhere.html
Driver URL: The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. Visit the SAP website for more information.
JDBC URL Syntax by Type: Server `jdbc:sybase:Tds:<server>[:<port>]/<databaseName>`	Default Port: 2638
JDBC Class: `com.sybase.jdbc4.jdbc.SybDriver`	JDBC JAR File Name: N/A
Comments: This open source jTDS driver works with SAP ASE (formerly Sybase) as well. Note that although you can use jTDS open source JDBC driver, we recommend that you use the SAP-supplied JDBC driver instead. Connections might not work reliably if you use the jTDS JDBC driver.

Vendor Name

Details

Recommended Native Driver

SAP

Company URL:

https://www.sap.com/products/sql-anywhere.html

Driver URL:

The jConnect JDBC driver can only be installed from the SAP Adaptive Server Enterprise Installer. Visit the SAP website for more information.

JDBC URL Syntax by Type:

Server: jdbc:sybase:Tds:<server>[:<port>]/<databaseName>

Default Port:

2638

JDBC Class:

com.sybase.jdbc4.jdbc.SybDriver

JDBC JAR File Name:

N/A

Comments:

This open source jTDS driver works with SAP ASE (formerly Sybase) as well. Note that although you can use jTDS open source JDBC driver, we recommend that you use the SAP-supplied JDBC driver instead. Connections might not work reliably if you use the jTDS JDBC driver.