jdbc:sybase:Tds:host.at.some.domain:5000/db_name?SQLINITSTRING=set quoted_identifier on
Sybase translator (sybase)
Also see common JDBC Translators information.
The Sybase translator, known by the type name sybase, is for use with SAP ASE (Adaptive Server Enterprise), formerly known as Sybase SQL Server, version 12.5 or later.
If you use the default native import, you can avoid exceptions during the retrieval of system table information, if you specify import properties.
If errors occur when retrieving table information, specify a
schemaPattern, or use
excludeTables to exclude system tables.
For more information about using import properties, see Importer properties in JDBC translators.
If the name in the source metadata contains quoted identifiers (such as reserved words, or words that contain characters that would not otherwise be allowed), and you are using a jConnect Sybase driver, you must first configure the connection pool to enable quoted_identifier:
If you are using a jConnect Sybase driver and will target the source for dependent joins, set the
jdbc:sybase:Tds:host.at.some.domain:5000/db_name?SQLINITSTRING=set quoted_identifier on&JCONNECT_VERSION=6
Indicates that the open source JTDS driver is being used. Defaults to false.