Hi all,
I've managed to configure AWS RDS SqlServer Data source in our Appian dev env application.
Current dev environment is running on vmware private cloud with Sql Server data source.
Could someone please suggest the procedure/steps how to replace current data source with RDS Sql Server?
Do we need to modify each DSE objects OR any recommended systematic approach to achieve this?
What are the objects that we need to check other than DSE please?
Can we update the application module by module basis? (i.e. Part of the application/functions will retain the current/existing data source, some of the specific modules will can use AWS RDS source? )
It would be helpful if someone can shed the light on any available whitepapers/ case studies resource and share the details of known challenges for this use case please. - Thanks.
Discussion posts and replies are publicly visible
AFAIK Appian uses the configured data source name to identify the DB in data store objects. When you create a new data source in the admin console and update all data stores to use this one, you should be good to go. After you did all the DB related migration steps that is.
Thanks Steve, I'll try this approach.
Hi Steve,
If I am taking the copy of existing Test environment, replacing with new RDS data source connection string, I assume that I need to replace existing data source settings with new one? i.e. If the existing data stores number around 300, I will have to do some bulk update to change the data source. Isn't it? Will it be any other objects other than data stores needs to be changed on updating data source connection pls? Query nodes too? Thanks.
As data stores are the connection between records and queries, you only need to update them. It could be that there are some query database nodes which use the data source name directly, then you might need to take a look at them too. There are some other objects using the JDBC name: CSV Import, Excel Import, Document Base64 to DB. There might be some more.
If you keep the data source names the same, then there is almost nothing to do.
Many thanks Steve, I'll work on this perspective.