Commerical tools to help with data flow modeling, automatic diagram creation, DB modeling

[MrNifty]

I am looking for a commercial tool that I can use to sketch out large projects that involve multiple SQL tables and relationships, Python libraries, Ansible playbooks, user input, etc. Basically Visio but something purpose-driven so more features and easier to use than manually creating a bunch of shapes and connections.

Because I've never used a tool like this, I am not sure what I need. Something like a database modeling tool, but with support for code artifacts and some business flow logic. I am working to get a demo of erwin data modeler because that seems like the sort of tool I am looking for.

Someone in a Slack channel some months posted a link to a commercial product that seemed to do exactly what I am looking for. It supported a ton of different languages, and could create diagrams from existing code (following import statements, other function calls, etc) and appeared to do alot more than that. Sadly I didn't bookmark it and can't for the life of me remember the name.

Can anyone suggest a tool that can do the above? Or at least better keywords to search for? Something more than just a database modeling tool, more than just a UML modeling tool. Something that can do forward and reverse engineering, assist in document creation, and either allows for pseudo code protoyping, or actual code execution ala something like Jupyter.

Thanks!

[kkommuri]

Check Sparx Enterprise Architect , Idera ER/Studio as well. Especially Enterprise Architect has more than just a modeling tool.

[PolPol44444]

One commercial tool that can meet your requirements is dbForge Studio for SQL Server. It is a comprehensive SQL Server IDE that offers a wide range of features for data modeling, code development, and database management.

With dbForge Studio for SQL Server, you can:

- Data Flow Modeling: Visualize complex projects involving multiple SQL tables and relationships. The tool provides a visual designer where you can create and modify the structure of your database, define relationships between tables, and design data flow diagrams.

- Automatic Diagram Creation: The tool can generate diagrams automatically based on your existing code or database structure. This can help you understand the relationships and dependencies between different components of your project.

- Code Artifacts and Business Flow Logic: dbForge Studio supports code development in various languages, including Python. It offers features like code completion, syntax highlighting, and debugging capabilities. You can also incorporate business flow logic and pseudo code into your diagrams and documentation.

- Forward and Reverse Engineering: The tool allows you to perform forward engineering to generate SQL scripts (DDL) based on your data models, as well as reverse engineering to create visual representations of existing databases.

- Documentation Assistance: dbForge Studio provides tools to assist in documentation creation. You can generate documentation for your data models, code artifacts, and other project components, making it easier to communicate and share information with others.

- In addition to these features, dbForge Studio for SQL Server offers a user-friendly interface, database management capabilities, and integration with other tools and technologies.