Config Bridge
Config Bridge Database installations happens automatically. Please make sure to create a Database (MSSQL) or a Schema/PDB (Oracle).
Important: The connection string to a Shopfloor Management DB needs to be configured for each tenant. This can be done in the ConfigBridge UI.
The following script creates an empty config bridge database. This script is not necessary within Bosch as database provisioning will be done by the Central IT Department Bosch Digital.
Database scripts Oracle
Please replace the following placeholders before executing this script.
-
$$SchemaUsername$$
-
$$SchemaPassword$$
-
$$DATAFILEPATH_1$$
-- create tablespaces
CREATE BIGFILE TABLESPACE $$SchemaUsername$$DATA_CB DATAFILE '$$DATAFILEPATH_1$$' SIZE 1G AUTOEXTEND ON NEXT 500M MAXSIZE 50G;
-- create users
create user $$SchemaUsername$$ identified by $$SchemaPassword$$
default tablespace $$SchemaUsername$$DATA_CB
temporary tablespace TEMP
quota unlimited on $$SchemaUsername$$DATA_CB;