SwisSQL API On-the-fly SQL Query converter for Portable
Note: SwisSQL API product was previouly known as SwisSQL SQLOne API.
Todays fast paced business environment requires
future-proof applications to work with multiple databases.
With most applications designed to work with a single
database, porting these applications to support multiple
databases can be tedious, cumbersome, and time consuming.
SwisSQL API enables applications to work with
multiple databases without the need to port proprietary
SQL queries from one database to another.
Enterprises and ISVs can use SwisSQL API Java edition to convert embedded SQL queries in their java applications to suit any target database. SwisSQL API supports query conversion across Oracle, SQL Server, DB2, Sybase, Informix, PostgreSQL, MySQL, ANSI SQL, TimesTen and Netezza SQL dialects.
Enterprises and ISVs can directly Invoke SwisSQL API Java edition or use Virtual Drivers (JDBC based drivers) for dynamic SQL query conversions based on their application requirements. The table indicates the best cases for using direct API invocation and using virtual drivers.
can invoke SwisSQL API directly from within
the application for migrating selective queries
embedded within them
Drivers intercepts and seamlessly convert
all the SQL statements that emanates from
the application to the required target database
can invoke SwisSQL API function directly for
migrating selective queries embedded within
the application. This can be achieved with
minimal application modifications.
are Cached to avoid repetitive parsing and
conversion. This increases the overall performance
while using Virtual drivers
is supported across the following databases
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 99
Currently supports migration only from Oracle SQL and Sybase SQL to TimesTen SQL.
Currently supports migration only from Oracle SQL to Netezza SQL.
To buy the above products or for any queries contact sales.