GenWise uses Database Providers to connect your projects and applications to different databases. For each database that is supported there has to be a specific Database Provider. The Database provider allows you to define a connection to a database in GenWise Studio through the connection dialog and the connection designer. It then manages the retrieval of metadata about tables, primary keys, constraints, relations and views into a Database Repository.
New Database Providers can be registered with the Database Providers dialog that is available from the Tools menu of GenWise Studio. If you open this dialog you'll find that Database Providers for most supported databases have already been registered during the installation of GenWise Studio.
A GenWise Database Provider is a DLL that implements certain interfaces and therefore can be plugged into the GenWise IDE. The Database Provider performs tasks that are specific to the database, and adapts SQL statements to the SQL dialect of the database.
In theory communication with a database may be channeled through different Database Providers, for instance an Oracle database could refer to a native Oracle provider, an OleDb provider, or an ODBC provider. In most common scenarios there is one preferred Database Provider that should be used exclusively.
GenWise currently supports the databases listed below through Database Providers that are available.
 | Caché (beta) |