Supported databases
Many users ask us what database(s) does WinSQL work with. The answer to this question is
that WinSQL works with ANY database for which a driver is available - ODBC driver in the case
of WinSQL and JDBC driver in the case of JaySQL.
WinSQL as well as JaySQL strictly adheres to the open specifications of ODBC and JDBC, which is not specific to any database.
All relational databases these days support these specifications and therefore all you need is an ODBC/JDBC driver
to connect to the back-end database.
All database specific features are provided via Plugins, which are plain XML files.
Here is a partial list of databases that you can use with WinSQL
| |
|
|
Oracle Plugin available
Sybase Plugin available
IBM DB2 Plugin available
MS SQL Server Plugin available
Informix Plugin available
Pervasive SQL Plugin available
MySQL Plugin available
PostgresSQL Plugin available
Mimer SQL Plugin available
Sybase SQL Anywhere Plugin available
Netezza Plugin available
Teradata Plugin available
Yellowbrick Plugin available
|
What are plugins?
Plugins allow WinSQL to retrieve data from the database that is normally not possible with ODBC API.
For example there is no API in ODBC to fetch scripts for Triggers, Views and Stored Procedures.
This void is filled by plugins.
IMPORTANT: If we do not provide plugin for a database it does NOT mean you cannot connect to it.
If you like you can write your own plugin, which are plain text files in XML format.
|
|
|
ANTs Database
Centura
Clipper
DBase
FileMaker
Firebird
Interbase
|
MS Access
MS Excel
Daffodil DB
NexusDB
OpenIngres
Paradox
Progress
|
SOLID
SQLBase
Teradata
Text files
ThinkSQL
TimesTen
And the list goes on...
|
