SwisSQL API (Java) 5.0

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

SwisSQL API is a multi-dialect SQL parser and conversion engine. SwisSQL API enables Java based applications to work with multiple databases without the need to port proprietary SQL queries from one database to another. SwisSQL API can convert DDL, DML and Select statements on the fly across multiple databases like Oracle, SQL Server, DB2, Teradata, Sybase, Informix, PostgreSQL, MySQL,TimesTen and Netezza SQL dialects.

SwisSQL API also offers a JDBC (Java Database Connectivity) Driver wrapper interface that bridges RDBMS vendors' JDBC drivers and your application. Applications using JDBC calls need not embed SwisSQL API. They could just plug-in the SwisSQL JDBC driver wrapper and seamlessly convert SQL queries from one database to another, instantly without any code change.

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 Teradata SQL dialect.
• 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 5.0 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