Hello Community,
I don't know if I'm searching the wrong terms to find answers in the documentation, so I'm going to lean on the community for some insight into my situation.
Background:
We are dealing with a rehosting scenario transitioning from Appian Cloud to another environment configured differently. I am unable to make changes to the new cloud space environment. I can only work redesign of our app. In Appian Cloud, we were the only system in our cloud space and utilized JDBC to connect to the underlying MariaDB. The new environment is a shared space. The use of JDBC is causing issues with the other tenants interfering with our data and tables. We have been asked to transition to the use of the connected system object.
Questions:
1. The database was set up in Appian Cloud by a different resource. When attempting to build a new Connected System to our MariaDB, it's requesting a username and password that I have no idea what should those would be from a systemic perspective. My own credentials don't make sense in that this connection would need to be constantly maintained.
2. Assuming the Connected System is built for use, how do I redirect the recordtypes in my apps to use the Connected System instead of JDBC. Everything I'm seeing is indicating this is done only at creation. I'm really hoping that is not the case. The ripple effect of the changing UUID for the recordtypes would impact thousands of objects.
Regards,
Spencer
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/26.1/appian-cloud-database-administration.html#appianprocess.createnewschema()
You will have to create a new schema and use the returned credentials in your connected system. Then switch the data source. I think that in the latest versions, this does not change the UUID of the record anymore.
Thanks Stefan. Does this mean I need to:
1. Create a new schema (gaining insight into the username/password)
2. Move all of the tables in the preexisting schema into the new one
3. Build a new Connected System object pointed at the new schema
then...
"Switch the data source" OK. I found where a record type can change it's data source. That still means I'd have to go into every individual record type and remap them?
Yes
As a side note, it would be nice for more Appian Solutions, partner solutions, and AppMarket apps to do this step as part of making their own app-specific Connected System object. This would make it a far easier to transition the app from Appian Cloud's database to the enterprise database as part of production-izing the install.