Skip to main content
R
radhikam0005
September 7, 2023
Question

Data from two different schemas from Appian database

  • September 7, 2023
  • 12 replies
  • 0 views

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?

    12 replies

    stefanhelzle0001
    stefanhelzle0001
    September 7, 2023

    Nowadays, you would use connected systems to connect to the database. Just create two of them and you should be good.

    R
    radhikam0005Author
    September 7, 2023

    How will I create a Record from it containing data from the tables of respective schemas?

    mathieud0001
    mathieud0001
    September 7, 2023

    When you create your Record it will let you choose which Schema (via the Connected System) you want to use.

    H
    harishs1855
    March 11, 2025

    Hi radhikam0005,  How did you solve this problem?  We have two different databases(Mariadb and Oracle),  One legacy and one current database. We don't want to import legacy data into current database.   Our requirement is similar to yours,  connect both the DB schemas in one application and do legacy search.  Can you provide details on how you approached and solved this problem?

    konduruc733182
    konduruc733182
    March 11, 2025

    Hello [mention:d6dd242d6b6549cb91c68462173d1e54:e9ed411860ed4f2ba0265705b8793d05] , This is a two year old thread. Please Create new post for your query.

      Terms & ConditionsAccessibility statement