Database Configuration in Visual Paradigm

Database configuration is to setup the connection details required to connect to your database from Visual Paradigm. Database configuration is required because:

• It allows you to use DBMS specific data types in your ER model
• Visual Paradigm has to access the target database when you perform database generation

To configure database:

1. Select Tools > DB > Database Configuration... from the toolbar.
2. At the top left corner of the Database Configuration window, set the (Programming) Language of your project.
3. Check all the DBMS(s) you use from the list of vendor on the left hand side. When you are you drawing an Entity Relationship Diagram (ERD), you will be able to select data types supported by the DBMS selected here.
   

   Select DBMS

4. If you use multiple DBMS, you have to select the default DBMS by right clicking on the DBMS and selecting Set as default from the popup menu. Database and DDL generation follow the default DBMS selection made here.
5. Enter the Driver Setting.
   

   Property Description Version There might be a slightly difference in database setting for different database versions. In order for the database connectivity to work properly, choose the version of your database here. Driver A driver is a software component essential for us to connect to your database. There are different driver suppliers on the market. Choose the one you like or leave it as default if you are uncertain. Driver file JDBC is a popular option in database connectivity. We use JDBC in connecting with database. In order for DB generation to function, you have to specify the JDBC driver here. It can be downloaded automatically by clicking . If it failed to find one, you will be redirected to the download URL. Connection URL Enter the information required for the JDBC driver to connect to the database. User The username of the user who has the access right to the database. Password The corresponding password for the user input in the User field. Engine (MySQL and Maria DB only) MySQL and MariaDB supports different types of table engines. The two most commonly used engines are Innodb and MyISAM.

   Driver settings

6. Click Test Connection. If the database settings are confirmed alright, you will be prompted a dialog box showing Connect Successful. Now, you can design database in ERD with the data types available under the chosen default DBMS.

Related Resources

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

• FREE Online Training - Database Design and Management
• Visual Paradigm on YouTube
• Visual Paradigm Know-How - Tips and tricks, Q&A, solutions to users' problems
• Contact us if you need any help or have any suggestion