We are using a cloud version of Appian, after creating the database using mySQL

mohamedb over 9 years ago

We are using a cloud version of Appian, after creating the database using mySQL workbench what is the best way to export the tables to XSD(s) for import in Appian? We also want to have the XSD(s) use Appian JPA notation.

What are the best tools and steps to use/follow?

Discussion posts and replies are publicly visible

0 Alok Mohare
Appian Employee
over 9 years ago

Most of the FAQ's for Appian Cloud can be found here:
forum.appian.com/.../Appian_Cloud_FAQ.html

That said, you can review the Database Administration Guide for Appian Cloud at the following link:
forum.appian.com/.../Appian_Cloud_Web_Administration.html

Let me know if that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 9 years ago

Thanks Alok! That answers the What part of my question.

Do you know "how" we can create the "right" XSDs from SQL Workbench showing a database like in attached image ... Are there any tools Appian recommend?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 9 years ago

sorry - this attachement
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 9 years ago

I would like to avoid a manual build if possible ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 akshayan
Certified Lead Developer
over 9 years ago

You can not create xsd for Appian CDTs automatically using SQL workbench. You need to use either Appian Data Type Designer or manually create XSD using any text editor.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 9 years ago

Thanks Akshay ... that was very helpful ... but how will the database on the cloud maintain the referential integrity ... Do we need to maintain it manually too?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Josh
Certified Lead Developer
over 9 years ago

Yes, you will need to update the cloud database manually as you make changes to your cdts.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohamedb over 9 years ago

That helps too my friend. Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel