DB Change Setting
DANGER
Before starting DB Change Setting, all development and operational tasks related to the database (e.g., DDL, batch processing, DB execution, configuration, and Web/Mobile user access) must be stopped.
Since this involves changing the DB connection for the core functions of Cals Platz, repeated execution may cause inconsistencies in system table data. Careful planning and execution are required.
The DB Setting for Silo and Bridge models manages system-related DB connections, which are separate from the DB connections used by Studio users when connecting to BO (Business Object). Therefore, the task of mapping the tables' data sources or schemas must be carried out separately before and after completing the DB Change Setting.
Pool → Silo
This is similar to the initial setting of the Silo model. However, table data migration is added before the Tenant DB connection. Table data migration is optional and not mandatory.
Data Source Registration
Navigate to Physical Layer > Data Source in the App environment.
Register data sources for both the Sandbox and Production databases using the information provided by the TA team. Use environment variables configured in System Admin > Environment to specify the host information.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment. Save the configuration for both the Sandbox Target DB (for the Sandbox tenant) and the Production Target DB (for the production environment tenant).
- Open Attribute View for the selected tenant to configure Target DB.
- Sandbox Target DB: Select the data source registered in Data Source Registration, reflecting the actual Sandbox environment.
- Production Target DB: Select the data source registered in Data Source Registration, reflecting the actual production environment. (If configured via environment settings, it will match the Sandbox Target DB.)
- Select the table to migrate data, open Attribute View.
- Change Transfer to 'YES' for the target table before saving.
Provisioning
After configuration in the App environment, complete provisioning in both Sandbox and Production environments.
Although configuration is performed in the App environment, the actual integration and data migration occur in the Sandbox environment. Therefore, provisioning must be completed for the Production environment as well.
Sandbox Table Data Migration (Optional)
Proceed if the Table Transfer value in the Tenant DB Setting is set to 'YES'.
When modifying the data model, the system table data stored in the previous database will be migrated.
Two migration methods are available:
Overwrite: Copies data from the Source DB to the Target DB, resulting in identical data in both databases. Once the Tenant DB is connected, data will only be loaded to the Target DB.
Move: Migrates data from the Source DB to the Target DB and deletes it from the Source DB.
WARNING
If using Move, the data in the Source DB table will be deleted and cannot be overwritten afterward.
① Select a table and perform Sandbox Overwrite.
② Select a table and perform Sandbox Move. (Do not perform Move if Overwrite has already been executed.)
- Since only the selected table is executed, repeat the process for each table set to 'YES'.
Sandbox Tenant DB Connection
Navigate to Tenant Setting > Tenant DB Setting in the Sandbox environment.
INFO
Tenant Setting in the Sandbox environment is accessible only via an administrator account.
Sandbox DB Connection: Assign the Sandbox Target DB to the tenant’s DB settings. When successfully connected, the details will be recorded in the Connection History ②.
Use the Connection History to check the connection status for both the Sandbox and Production environments.
Production Table Data Migration (Optional)
① Select a table and perform Production Overwrite.
② Select a table and perform Production Move. (Do not perform Move if Overwrite has already been executed.)
Production Tenant DB Connection
Navigate to Tenant Setting > Tenant DB Setting in the Sandbox environment.
INFO
Tenant Setting in the Sandbox environment is accessible only via an administrator account.
Production DB Connection: Assign the Production Target DB to the tenant’s DB settings. When successfully connected, the details will be recorded in the Connection History ②.
Use the Connection History to check the connection status for both the Sandbox and Production environments.
Pool → Bridge
This is similar to the initial setting of the Bridge model. Table data migration is optional.
For detailed steps not specified here, refer to the Pool → Silo process.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment.
Save the configuration for both the Sandbox Target DB (for the Sandbox tenant) and the Production Target DB (for the production environment tenant).
- Open Attribute View for the selected tenant to configure Target DB.
- Sandbox Target Schema: Specify the schema used by the tenant in the Sandbox environment.
- Production Target Schema: Specify the schema used by the tenant in the Production environment.
Provisioning
Sandbox Table Data Migration
Sandbox Tenant DB Connection
Production Table Data Migration
Production Tenant DB Connection
Silo → Pool
This process switches from using separate database instances to using a single database instance. Initial data migration requires input of Source DB information.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment.
Enter the Sandbox Source DB and Production Source DB information if data migration is necessary.
- Select Pool as the DB Isolation type.
- Specify the data source from the previously separated Silo for Sandbox Target DB. (Information to be used when migrating tables.)
- Specify the data source from the previously separated Silo for Production Target DB. (Information to be used when migrating tables.)
Provisioning
Sandbox Table Data Migration
Sandbox Tenant DB Connection
Production Table Data Migration
Production Tenant DB Connection
Bridge → Pool
In the case of Bridge Initial Setting, the configuration was done by entering only the schema information based on the Application Default DB Instance information.
However, when switching to the Pool method, it is necessary to register the data source for the schema information used in the existing Bridge model.
Data Source Registration
Register the data source that was used as the Target DB in the Bridge model.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment.
Enter the Sandbox Source DB and Production Source DB information if data migration is necessary.
- Select Pool as the DB Isolation type.
- Select the Sandbox Target DB data source of the previous Bridge model newly registered in Data Source Registration
- Select the Production Target DB data source of the previous Bridge model newly registered in Data Source Registration
Provisioning
Sandbox Table Data Migration
Sandbox Tenant DB Connection
Production Table Data Migration
Production Tenant DB Connection
Silo → Bridge
This process switches from the Silo model to the Bridge model.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment.
Save the configuration for both the Sandbox Target DB (for the Sandbox tenant) and the Production Target DB (for the production environment tenant).
- Enter the Sandbox Target Schema and Production Target Schema.
- Specify and enter the data source used in the previous Silo model using the Sandbox Source DB and Production Source DB information.
Provisioning
Sandbox Table Data Migration
Sandbox Tenant DB Connection
Production Table Data Migration
Production Tenant DB Connection
Bridge → Silo
In the case of Bridge Initial Setting, the configuration was done by entering only the schema information based on the Application Default DB Instance information.
However, when switching to the Silo model, it is necessary to register the data source for the schema information used in the existing Bridge model.
Data Source Registration
It is necessary to register the data source to be used as the Target DB in the Silo model and the data source previously used as the Target DB in the Bridge model.
Tenant DB Setting
Navigate to Application Setting > Tenant DB Setting in the App environment.
Enter the Sandbox Source DB and Production Source DB information if data migration is necessary.
- Select Sandbox Target DB and Production Target DB from the data sources.
- Specify the previous Silo model data sources for Sandbox Source DB and Production Source DB.