Part I. Getting started

Part II. UML modeling

Part III. Project glossary

Part IV. BPMN toolset

Part V. Project management

Part VI. Modeling toolset

Part VII. ArchiMate tools

Part VIII. Team collaboration

Part IX. Code engineering

Part X. Database design and engineering

Part XI. Advanced modeling toolset

Part XII. Document production

Part XIII. Business modeling

Part XIV. Business rule

Part XV. Agile development

Part XVI. Wireframe

Part XVII. Impact analysis

Part XVIII. CMMN toolset

Part XIX. SoaML modeling

Part XX. Design animation

Part XXI. IDE Integration

Part XXII. Interoperability and integration

Part XXIII. Process simulation

Part XXIV. Zachman and BMM

Part XXV. Appendix A - Application Options

Part XXVI. Appendix B - Project Options

Part XXVII. Appendix C

 

Supported Database, JDBC Drivers and .NET Drivers

Visual Paradigm provides a visual modeling environment for modeling software systems. By connecting a relational database to Visual Paradigm, Visual Paradigm can automate the mapping between database design (ER model) and relational database. Visual Paradigm supports the most common relational databases, including Oracle, DB2, Microsoft SQL Server, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, MySQL, HSQLDB, Cloudscape/Derby and PostgreSQL. Their relative JDBC Drivers and .NET Drivers are listed in the following tables.

In order to connect to any of the supported database, the relative JDBC and .NET Drivers are required for configuring the database connection. All of the required JDBC and .Net Drivers are not bundled with Visual Paradigm. Yet, you can get the driver files by using the automatic download function provided, or to have them manually downloaded.

Table shows the supported DBMS and their corresponding JDBC Drivers.

DBMS JDBC Driver Name
Cache InterSystems Cache
Cloudscape/Derby 10.6.2.1 or lower
Cloudscape/Derby (Embedded)
Cloudscape/Derby (Server)
Cloudscape/Derby 10.7 or above
Derby 10.7 (Embedded)
Derby 10.7 (Server)
DB2 7/8
DB2 (Type 4 Driver)
DB2 (App Driver)
DB2 (Net Driver)
DB2 (AS/400 Toolbar for Java JDBC Driver)
DB2 (DataDirect Connect Driver)
Firebird Firebird
FrontBase FrontBase
H2 H2
HSQLDB 1.61 - 1.8
HSQLDB (In-process)
HSQLDB (Server)
IBM Informix IBM Informix (Client)
IBM Informix (Server)
Informix (DataDirect Connect Driver)
Ingres Ingres
MariaDB MariaDB
MS SQL Server 2005 or lower MS SQL Server (jTDS Driver)
MS SQL Server (Microsoft Driver)
MS SQL Server 2005 (Microsoft Driver)
MS SQL Server (SequeLink Driver)
MS SQL Server (DataDirect Connect Driver)
MS SQL Server (WebSphere Connect Driver)
MS SQL Server (JSQL Driver)
MS SQL Server (JTURBO Driver)
MS SQL Server (Weblogic Connect Driver)
MS SQL Server 2008 or higher MS SQL Server (jTDS Driver)
MS SQL Server 2005 (Microsoft Driver)
MS SQL Server (SequeLink Driver)
MS SQL Server (DataDirect Connect Driver)
MS SQL Server (WebSphere Connect Driver)
MS SQL Server (JSQL Driver)
MS SQL Server (JTURBO Driver)
MS SQL Server (Weblogic Connect Driver)
MySQL 5.0.4 or lower MySQL (Connector/J Driver)
MySQL 5 (Connector/J Driver)
MySQL 5.0.5 or higher MySQL 5 (Connector/J Driver)
OpenEdge OpenEdge
Oracle Oracle (DataDirect SequeLink Driver)
Oracle 8i Oracle8i (THIN JDBC Driver)
Oracle 9i Oracle9i/10g (or above)
PostgreSQL PostgreSQL
Redshift Redshift
SQLite SQLite
Sybase Adaptive Server Enterprise 12.5 Sybase Adapter Server Enterprise (jConnect Driver)
Sybase Adapter Server Enterprise (JTDS Driver)
Sybase (DataDirect Driver)
Sybase SQL Anywhere 9 Sybase SQL Anywhere (jConnect Driver)

Supported DBMS and their corresponding JDBC Drivers

Table shows the supported DBMS and their corresponding .NET Drivers.

DBMS .NET Driver Name
Cache InterSystems Cache
DB2
DB2 (IBM DB2 Data Provider)
Firebird Firebird (Firebird .NET Data Provider)
Firebird (Firebird Client)
Ingres Ingres
MS SQL Server 2005 or lower
MS SQL Server
MS SQL Server 2005 or higher MS SQL Server
MySQL 5.0.4 or lower MySQL (MySQL Connector/Net 1.0)
MySQL (MySQL Connector/Net 6.1)
MySQL 5.0.5 or higher MySQL (MySQL Connector/Net 1.0)
MySQL (MySQL Connector/Net 6.1)
Oracle Oracle (.NET Framework Data Provider)
Oracle (Oracle Data Provider for .NET)
PostgreSQL Postgre (Npgsql)
SQLite SQLite (SQLite .NET Data Provider)
Supported DBMS and their corresponding .NET Drivers

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

 
4. Sharing Database Configuration between Projects Table of Contents Chapter 2. Designer Guides

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.OK