Sybase IQ supports ODBC and JDBC connectivity. Sybase IQ 15.2 uses SQL Anywhere to store catalog information.
Sybase IQ versions earlier than 12.0 used Adaptive Server as the catalog server. ODBC applications used as client front–end tools with older versions of Sybase IQ will continue to run in IQ version 12.x, but third–party and customer–written Open Client™ DB–Library and Client–Library applications are unlikely to perform as expected.
When you develop Open Client applications to run with Sybase IQ 12.x, do not use catalog tables or system stored procedures supported by Adaptive Server but not Sybase IQ. See Appendix A, “Compatibility with Other Sybase Databases,” in the Sybase IQ Reference Manual.
Sybase IQ is compatible with clients (like Open Client–Library and DB–Library) that use Tabular Data Streams (TDS). Open Client version 11.1.1 supports TDS 5.x and applications developed using these tools work with Sybase IQ, if these applications use the system tables, views, and procedures in Sybase IQ. System procedures, catalog tables, and views available in Sybase IQ are listed in the Sybase IQ Reference Manual. There are no restrictions for accessing data in the IQ Store through any supported interface.
