SAP PowerDesigner (formerly from Sybase) is an enterprise data architecture modeling tool, used to Build a blueprint of the current enterprise architecture and visualize the impact of change before it happens.
N/A
Microsoft Visio
Score 7.7 out of 10
N/A
Microsoft offers Visio, a diagramming tool for building flowcharts, diagrams (e.g. network diagrams), org charts and floor plans, available online as a subscription and also in enterprise level packages (e.g. Visio Professional).
$5
per month per user
Pricing
SAP PowerDesigner
Microsoft Visio
Editions & Modules
No answers on this topic
Visio Plan 1
$5.00
per month per user
Visio Plan 2
$15.00
per month per user
Visio Standard 2024
$309.99
one-time fee On-premises diagramming solution, licensed for one PC
Visio Professional 2024
$579.99
one-time fee On-premises diagramming solution, licensed for one PC
SAP PowerDesigner allows our team of data modelers to work and collaborate from a single repository and single data dictionary. This helps enforce consistency as data elements are referenced in other objects. Prior to our use of PD, we might have an element named "ppt" in one table, "participant" in another table and "part" in a third table. By forcing everything to be used from the data dictionary, we avoid these situations because everyone has to go to the dictionary. And we are able to easily do peer reviews on models before they are released because we are collaborating through the use of the repository.
Visio is by far and away the best tool that I have used to do Value Stream Mapping sessions with the warehouse I support. It has all of the shapes needed built in to be able to represent all areas of the processes. I also like how you are able to make the drawing as big as needed and when printing it out of Visio you have the ability to use the necessary paper size. The biggest complaint that I have with the software if how it can be cumbersome for non-Visio users (that is, people without a license in the orgnaization) to interact with the Visio Map. We normally have to dedicate one Visio SME to be able to make the changes that Process SME's find since they do not have access to the software.
Microsoft Visio is excellent for organizing thought processes related to our more complex research.
The diagrams created with Microsoft Visio are ideal for graphically displaying the internal organization of work and research groups through flow diagrams.
Microsoft Visio is a great tool for managing our students' activities by creating flowcharts that help us graphically visualize the steps of their group work.
When navigating through swim lanes, the user must be careful between switching from the point to the connection features as it can be difficult to remember which mode you’re in.
When drawing “decision points,” it can be difficult to type words like “yes” or “no” between the connection lines.
The exporting options aren’t ideal. They are hard to create in PDF format.
We use Microsoft Visio to keep our diagrams updated and to that end we will need the subscription to keep using the software. Otherwise we will be left with PDF versions of the diagrams.
I have always struggled with some basics, such as connection points, object alignment, font consistency, arranging layers and their order (bring forward, send backward), and managing overlap. I usually need to create an initial rough draft and then do a separate cleanup pass to bring the diagram up to my quality standards. If I skip that step, the result generally does not look very good. And once a diagram becomes busy or the file gets large, Visio has been unstable for me in the past, including occasional crashes that caused non-recoverable edits.
We did have to reach out to support to learn how to properly utilize the repository feature and share the data model across many developers. Support was able to help us get this set up correctly. The downside was it took us several weeks before we gave up and contacted support. We should have done that earlier. I would say, however, the documentation wasn't clear on how to do this. So support was a great big help!
Overall, I feel that Microsoft's support is weak. They are now such a behemoth that their model of putting documentation online for their users to sift through is totally outgrown. Given the amount of money you pay for these licenses, Microsoft should provide easy one-on-one support for their products via email or chat. The idea of paying their rates for support incidents is ridiculous. If you have an enormous amount of time on your hands, use their support websites and you will eventually find a solution most of the time.
Oracle SQL Developer Data Modeler : Unfortunately this tool only supports Oracle Databases as a target database, but has many features similar to SAP Sybase PowerDesigner. erwin Data Modeler: Has some issues when switching from Conceptual Model to Physical Model, Impact Analysis, and formatting copy and pasting. Vertabelo: Only supports online models and from a governance perspective, it is impossible for me to connect my target database with an online application because of company policy and regulation requirements.
Even though it’s a more expensive solution, Vizio is built for the enterprise. Therefore, it integrates perfectly with our existing Microsoft stack, and quite frankly, because it’s such a more mature product, it provides exactly the functionality we need and expect.
Reduces the amount of time I need to create process flow diagrams. In the past I would use Powerpoint or Word which required a lot more effort and time and never looked as good. Visio just takes that headache away.
Only negative is that I personally believe it should always have been part and parcel of the Office suite, thus giving more users the opportunity to use it rather than specifically having to justify its separate purchase within our organisation. Different now with Office 365 of course!
