SwisSQL API – On-the-fly SQL Query converter for Portable
applications
Note: SwisSQL API product was previouly known as SwisSQL SQLOne API.
Today’s 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 to convert embedded SQL queries in their 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.
SwisSQL API .NET Edition for VB, PB, VC++ and C# applications
Enterprises and ISVs can directly Invoke SwisSQL API
or use Virtual Drivers (JDBC or ODBC 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.
Direct
API Invocation
Using
Virtual Drivers
Applications
can invoke SwisSQL API directly from within
the application for migrating selective queries
embedded within them
Virtual
Drivers intercepts and seamlessly convert
all the SQL statements that emanates from
the application to the required target database
Applications
can invoke SwisSQL API function directly for
migrating selective queries embedded within
the application. This can be achieved with
minimal application modifications.
Queries
are Cached to avoid repetitive parsing and
conversion. This increases the overall performance
while using Virtual drivers
Supported Database
Versions
SQL Migration
is supported across the following databases
Oracle 8.1.7, 9i, and 10g
MS SQL Server 2000
IBM DB2 UDB 8.x
Informix 4.x
Sybase ASE 12.x
MySQL 4.X
PostgreSQL 7.x and
ANSI-SQL - SQL 92 and SQL 99
TimesTen
Netezza
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.
