Creating an ERD for Cloud DB

helmuta over 8 years ago

I have MySQL Workbench and I have used it to create several ERDs for local databases. I want to create an ERD for our Appian Cloud DB but I am not sure how to connect MySQL Workbench to the Appian Cloud DB. Does anyone have any ideas?

Thank you in advance for any ideas and suggestions.

Discussion posts and replies are publicly visible

0 Alok Mohare
Appian Employee
over 8 years ago

This is not permitted on Appian Cloud.

docs.appian.com/.../Appian_Cloud_FAQ.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Josh
Certified Lead Developer
over 8 years ago

If you just want to see the structure you could always download and install Appian locally. Push over some of your applications and do some quick smoke testing to populate data etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 8 years ago

Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 8 years ago

We generally run a structure-only export of the database (from phpMyAdmin) and then import that to a local MySQL installation (rather than a full Appian install). You can then connect MySQL workbench to that database and use the reverse engineer functionality to generate the ERM automatically. It's also possible to refresh the diagram at a later date by importing a new database export and using the "from source" option in MySQL workbench.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 8 years ago

Thank you Phil. I will give that a try.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel