| 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
|
|
|
