DBeaver / SQL Anywhere – Database Connection Setup

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

DriverManager.SQLAnywhere.01.20190724.1205PM

 

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

SQLAnywhere.connection.01.20190724.1214PM.PNG

 

References

  1. SAP
    • Home > Community > Archived Documents > SAP SQL Anywhere
    • 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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s