Microsoft Visio 2010 ERD using Custom Data Types from Database Drivers MySQL Oracle Access IBM DB2 ODBC
Microsoft Visio 2010 ERD (Entity Relationship Diagram)
Solution for matching data types on Microsoft Visio 2010 with your database needs.
Microsoft Visio 2010 – Limited Data Types
Hi guys! This topic discuss the solution on solving limited data types on Microsoft Visio. Previously, I was having some problem with data types when I am creating an ERD. The drop down combo box does not have a specific data type “TIMESTAMP” for my attribute “DATE_CREATED”. Below is the picture:
Microsoft Visio 2010 – Ribbon Database Tab (Database Driver)
However, after exploring each ribbons in Microsoft Visio 2010, I found out a feature which is the Database Drivers that allows user to switch Databases. By switching to the database that you are working with, it populates with the data type it contains as well.
Microsoft Visio 2010 – Selecting Database Driver
Microsoft Visio 2010 has a list of database drivers such as MySQL, ODBC, IBM DB2, Oracle, Microsoft Access, and OLE. By default, it uses Microsoft Access Data Types. Since I am using MySQL as my database, I select MySQL from the list and click OK. Microsoft Visio 2010 will automatically update the drop down combo box.
Microsoft Visio 2010 Testing the New Data Types
Now, if you try to browse through the drop down combo box for your attribute, you will notice there these data types belongs to your database. It took me an hour to figure out all these things lol. Couldn’t find it inside Microsoft Visio Help File. Hope this helps you and other newbies like me encountering such problems.