SwisSQL API (Java) 3.5

On the Fly SQL Conversion : Java API / JDBC Driver Plugin

SwisSQL API is a multi-dialect SQL parser and conversion engine. SwisSQL API enables applications to work with multiple databases without the need to port proprietary SQL queries from one database to another.It offers a JDBC API wrapper interface that bridges RDBMS vendors' JDBC drivers and end user applications. Applications using JDBC calls need not embed SwisSQL API. SwisSQL API supports Oracle, SQL Server, DB2, Sybase, Informix, PostgreSQL, MySQL,TimesTen and Netezza SQL dialects.

Features and Benefits:

• Multi-Dialect SQL parser parses all SQL dialect including SQL-99, SQL-92, Oracle, IBM DB2, Informix, Sybase, MS SQL Server, MySQL, PostgreSQL.
• Support for the conversion of Oracle SQL to Netezza SQL dialect.
• Support for conversion of Common table expressions (WITH statement) to all the databases.
• Timesten is now added to the Target database list with support for migrating SQLs from Oracle and Sybase.
• Supports Select, Update, Insert, Create, Delete and Drop statements
• High performance SQL conversion
• 100% Java based API for platform independent applications
• Minimal or no changes to applications using JDBC
• Direct SwisSQL API for applications to directly utilize SQL conversion features
• Low memory footprint
• SQL Object model for advanced users
• Enriches the Java Paradigm "Write SQL Once, Run Any DatabaseT"

Applications embedding SwisSQL API can use the API in two ways. Directly parse and convert SQL into different dialects. The second way is to use SwisSQL API JDBC Wrapper, which makes the parsing and conversion of SQL transparent to the applications.

Directly Using SwisSQL API From Applications

SwisSQL API Release 3.5 provides a simple and easy to use API to utilize the SQL parsing and SQL conversion features from inside the J2EE/Java applications directly. This feature ensures that applications are in control of when an SQL query needs to be converted to a different dialect. Also, repetitive parsing and conversion of the same SQL can be avoided. This architecture is illustrated in the figure below.

SwisSQL API JDBC Wrapper

Applications can use SwisSQL API's JDBC Wrapper as bridge between the application and the database specific JDBC driver. Existing applications can leverage seamless integration by just loading the SwisSQL JDBC driver without any other changes.The working model illustration is shown in the figure below.

Supported Database Versions