On the Fly SQL Conversion : Java API / JDBC Driver
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.
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
Supports Select, Update, Insert, Create,
Delete and Drop statements
High performance SQL conversion
100% Java based API for platform independent
Minimal or no changes to applications using
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.
Migration is supported across the following
Oracle 8.1.7, 9i, and 10g
MS SQL Server 2000
IBM DB2 UDB 8.x
Sybase ASE 12.x
ANSI-SQL - SQL 92 and SQL
Currently supports migration only from Oracle SQL to Teradata SQL.
Currently supports migration only from Oracle SQL to Netezza SQL.
Currently supports migration only from Oracle SQL and Sybase SQL to TimesTen SQL.