Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
7 subscribers
Views
2072 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
#PrimaryDatabase. We are on 7.11 cloud and MySQL is the Primary database. We are
sathishkumars
over 9 years ago
#PrimaryDatabase. We are on 7.11 cloud and MySQL is the Primary database. We are planning to upgrade to 16.1 soon. 16.1 supports SQL Server as primary database. Can we move our primary database from MySQL to SQLServer ? If yes, will the Appian Product's upgrade team take care of configuring the jdbc drivers, moving the table structures, data, stored proc, views, datastore and entity mappings etc because we are on cloud ? Any other considerations/suggestions on this ?
OriginalPostID-197065
OriginalPostID-197065
Discussion posts and replies are publicly visible
0
Vamsi Sunkara
Appian Employee
over 9 years ago
Only MySQL is offered as the primary database in the cloud.
You may connect to any of the other supported databases on your premises using VPN.
forum.appian.com/.../Query_Database_Smart_Service.html
(the section that applies to cloud customers)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathishkumars
over 9 years ago
Thanks Vamsi, the link you shared is useful. But it is not evident (unless I missed it) in
forum.appian.com/.../Appian_Release_Notes.html
or
forum.appian.com/.../System_Requirements.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Vamsi Sunkara
Appian Employee
over 9 years ago
SQL Server 2014 is indeed supported from 16.1, however, it is not provided on the cloud. If you have a VPN connection setup, you'll be able to integrate it with your Appian instance. (as your business data source, primary still has to be the MySQL that we provide on the cloud)
The second link applies to on-premise customers only. You can integrate any of those databases to your cloud site as additional datasources, just not as the primary.
Perhaps, this link might explain it better,
forum.appian.com/.../Appian_Cloud_Web_Administration.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathishkumars
over 9 years ago
Thank you Vamsi
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel