Does visio support import from Postgres without issues?

Rupali Mayekar 1 Reputation point
2022-09-06T17:02:03.85+00:00

I'm exploring MS Visio trial app for creating ERD diagrams for our data model using a Postgres database. Unfortunately the trail version has the import from database feature disabled so I can't test it. I read about a possible issue with importing from Postgres where the datatypes do not get imported correctly. Is that still an issue with Visio 2019? Does Visio fully support importing from a Postgres database?

Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
246 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 54,281 Reputation points
    2022-09-06T17:07:41.293+00:00

    Hi @Rupali Mayekar

    My best suggestion is to rent the software (Visio 365 Plan 2) for a month as it is a small investment. You can also buy Visio 2021 with a one-time purchase option as seen in the below link if you want a buy-out option:

    https://www.microsoft.com/en-ca/microsoft-365/visio/microsoft-visio-plans-and-pricing-compare-visio-options?activetab=tabs:primaryr1

    ----------------------------------------------------

    If this is helpful please accept answer.

    0 comments No comments

  2. Ceasar Chen_MSFT 4,391 Reputation points
    2022-09-07T03:17:31.087+00:00

    Hi, @Rupali Mayekar
    Visio2019 does not correctly display the data type when importing the postgres database.
    The workaround is to download the driver on the Internet so that Visio recognizes the postgres data source as an ODBC data source, the driver needs you to find it yourself, Microsoft officially does not have this driver.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.