What is the best practice for deploying tables during an application package import to a new environment?

Hi All,

I wanted to get your views on the best way to import the tables associated with an application package in Appian when we move the application package from one source environment to a new target environment. As of the practice is that the administrators ask the developers to provide them with the application package and the associated SQL scripts for the application. Then the administrators first import the package on the target environment and then manually run the scripts in the cloud database’s SQL view.

Another school of thought is that the administrators should import the package and then go into Appian Designer navigate to the newly deployed package’s Data Source Entity and under Schema Management click on the “Verify” button to check if the tables exist if not create the tables to add the Data Entities on the cloud database?

Which of the above two approaches is the ideal?

Thanks & Regards,

Sam

  Discussion posts and replies are publicly visible

Parents
  • Certified Senior Developer

    Hi Sam, 

    In general, if you have the SQL scripts for tables/views definition, the best approach would be to run the given SQL scripts first in the target environment and then import an application package contains CDTs and Data Store. In this way the application package will be imported without any warnings and you don't need to verify and publish the data store once the package is deployed.

    Hope this answers your question.

    Cheers!

  • Hi Naresh, thanks for your response.

    1. With your approach we are assuming that the SQL's would always be correct and in case a wrong SQL is is run, the only way we will find out is when the application throws an error during run-time.

    2. Also when we deploy a package on a new environment from what i have seen so far we never get a warning for tables not existing in the database.

  • Hi Naresh,

    1.You just verify the data store, in that case you will get to know whether all tables are exist or not .

    2. While deploying application it wont check for the database schema and CDT match, it will check only for the all objects and its dependency , while publishing Data store you will get a warning message.

    Thanks,

    Yash

  • Agreed Yash. So the best way would be post the import to go to the Data Source Entity and Verify/Publish & Save to ensure the tables are created correctly and Appian will refresh the CDT as and when changes are made to the same.

Reply Children
No Data