Features and Benefits:

• Multi-Dialect SQL parser can parse any SQL Dialect including SQL-99, SQL-92, Oracle, IBM DB2, MS SQL Server, Informix, Sybase, MySQL, PostgresSQL etc.
• Support for the conversion of Oracle SQL to Netezza SQL dialect.
• Support for conversion of Common table expressions (WITH statement) to all the databases
• Support for Select, Update, Insert, Create, Alter and Delete, Drop statements
• High Performance SQL conversion
• 100% C#(CSharp) based implementation
• SwisSQL API (.NET) library component can be leveraged by legacy VC++/VB/COM based applications too
• Low memory footprint
• SQL Object model for advanced users
• "Write SQL Once, Run Any Database"

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 ODBC Wrapper, which makes the parsing and conversion of SQL transparent to the applications.

Directly Using SwisSQL API .NET From Applications

SwisSQL API (.NET) Release 3.5 provides a simple and easy to use C# API to utilize the SQL parsing and SQL conversion features from inside the .NET and ASP/COM applications. This ensures applications can leverage the full power a a database's SQL features without needing to worry about portability of the SQL queries across databases. Just by embedding the SwisSQL API (.NET)component, the .NET or the ASP/COM application becomes compatible with other databases.

SwisSQL API ODBC Wrapper

Applications can use SwisSQL API's ODBC Wrapper as bridge between the application and the database specific ODBC driver. Existing applications can leverage seamless integration by just loading the SwisSQL ODBC driver without any other changes.The working model illustration is shown in the figure below.

Supported Database Versions