Background

Wanted to quickly add SQL Anywhere to the list of databases that DBeaver can connect to.

Outline

1. SAP SQL Anywhere Database Client
   • Artifacts
     • Download
   • Install
2. Dbeaver
   • Register Data Source
   • Configure Data Source
   • Connect

 

Tasks

SAP SQL Anywhere Database Client

Artifacts

Anywhere Database Client is available :-

SAP SQL Anywhere Database Client Download
Home > Community > Archived Documents > SAP SQL Anywhere
Link

Install

Please install.

DBeaver

Launch

Please launch DBeaver

Database Connection

Unfortunately, SQL Anywhere is not one of the Databases availed by default within DBeaver.

Let us to go register it as Data Source.

Outline

1. Access Driver Manager
   • Click on menu option “Database” \ “New Driver Connection”
2. Driver Manager Window
   • Click on the New Button
3. Configure Driver Manager
   • Driver Name
     • Anything you want it to be
     • For us, we used “SQL Anywhere”
   • Driver Type
     • Generic
   • Class Name
     • sap.jdbc4.sqlanywhere.IDriver
   • Windows Authentication ( Yes or No )
     • Yes, Windows Integration
       • URL Template
         • jdbc:sqlanywhere:host={host}:{port};database={database}
       • No authentication
         • We checked the “No authentication” check box
     • No, Username  & password Credential
       • URL Template
         • jdbc:sqlanywhere:host={host}:{port};database={database};UserID={username};Password={password}
       • No authentication
         • We ensured that “No authentication” is not checked
         • This forces us to use username/password credential
   • Libraries
     • {SQL Anywhere } \ Java\ sajdbc4.jar
     • {SQL Anywhere } \ Bin64\ dbjdbc17.jar

 

Images

New/Edit Driver

 

Connection

Unfortunately, SQL Anywhere is not one of the Databases availed by default within DBeaver.

Let us to go register it as Data Source.

Outline

1. Create New Connection
   • JDBC URL
     • jdbc:sqlanywhere:host={host}:{port};database={database}
   • Host
     • Enter machine name
   • Port
     • Enter port number
   • Database/Schema
     • Enter database name

 

Images

New/Edit Connection

 

References

1. SAP
   • Home > Community > Archived Documents > SAP SQL Anywhere
     • Download
       Link
   • SAP IQ Programming Reference
     • Home/JDBC support/SQL Anywhere JDBC driver/
       • SQL Anywhere JDBC driver connection strings
         Link
   • SQL Anywhere 17
     • SQL Anywhere 17 » SQL Anywhere Server – Programming » JDBC support » SQL Anywhere JDBC driver
       • SQL Anywhere JDBC driver connection strings
         Link
   • SAP SQL Anywhere Forum
     • JDBC driver for Oracle Data Modeler
       Link
2. Apache.org
   • ambari.apache.org
     • ambari git commit: AMBARI-16157. JDBC Connect String for Ranger modified wrong for non-default port.(vbrodetskyi)
       Link