Skip to main content
erazemk6135
April 26, 2024
Question

Deploying to a locally hosted environment

  • April 26, 2024
  • 3 replies
  • 0 views

Hello,

we have a locally hosted production environment and a cloud development environment. We want to deploy the application from the cloud to the local machine. When we export in dev and import the app to prod environment the database tables are understandably not linked to the record types. However when I connect them and tell Appian where they are (I am running a local MariaDb and connected it to Appian via admin console) they are connected up until I import another version of the application. So on each import I have to go through each record type and add the data source which is the database table. How to solve this? There has to be a better way to do this.

3 replies

stefanhelzle0001
Brainy
April 26, 2024

How do you connect to the DB? Is that set up in admin console? If yes, I think that the names of the data sources must be equal.

A better idea might be to use a connected system to create the DB connection.

erazemk6135
April 26, 2024

Yes it is set up in the admin console. But the development environment uses the default cloud database and the data sources list in admin console is empty. So I can set up the production data source to any name I want but the cloud data source doesn't have any name.

Regarding the DB connection, I have to somehow create a new database in the cloud instance (to mimic the setup I have locally) but I don't have access to the system where all of this runs.

mathieud0001
Brainy
April 28, 2024

Yeah, I would recommend creating a new schema, copying the database over and creating a connected system that points to that new schema. Your imports should work fine after that.

Otherwise, you could also try naming your Data Source on your on-prem instance the same name as the cloud instance name?