Toll Free US: +1 888 720 9500 | Intl: +1 925 924 9500
+1 800 443 6694 (alternative number)
|
|
|
|
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 is available in two versions
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
- 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. |
|
|
|
|
|
|
|
