Hi All,
One of our requirement is to merge the data from two applications into one. Both of the applications are created in same Appian instance and database is Appian cloud.
One of the application uses default Appian schema whereas other one has it's own schema under Appian cloud. This schema is already added to Admin console.
Now we need a way to connect this two schemas to be able to merge the application, is there any way to do that?
Discussion posts and replies are publicly visible
Nowadays, you would use connected systems to connect to the database. Just create two of them and you should be good.
How will I create a Record from it containing data from the tables of respective schemas?
When you create your Record it will let you choose which Schema (via the Connected System) you want to use.
What if there is no relationships between this two records we gonna create using Connected System, how will they relate to each other and make a single subset of data?