Skip to Content (Press Enter)
2023-08-18 10-40-36
Deepak M
55Views
7Comments
Is it possible to create two schemas in outsystems database?
Question
Database

Is it possible to create two schemas in outsystems database? In on-premise 

0
0
03 Jun 2024
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi Deepak,

As documented this is only possible in OutSystems 11 Onpremise installations:

https://success.outsystems.com/support/enterprise_customers/maintenance_and_operations/multiple_database_catalogs_and_schemas/

Regards,

Daniel

0
0
03 Jun 2024
Copy Link
2023-08-18 10-40-36
Deepak M

1. Can these two schemas will be separately deployed

2. Regarding CI and CD how does it works (Without script execution)

0
0
03 Jun 2024
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Replying to Deepak Mani's comment on 03 Jun 2024 08:41:33

All that is documented regarding multiple schema's is found in the URL that I shared.

0
0
03 Jun 2024
Copy Link
2023-08-18 10-40-36
Deepak M

Replying to Daniel Kuhlmann's comment on 03 Jun 2024 09:18:00


The following point mentioned in the document,

  1. Finish the solution staging

    1. In Service Center, publish the solution;

    2. The Platform Server first checks that all tables (of the moved modules) are created in their destination Catalogs. Then it displays a ‘Use Matching Tables’ option that is to be selected, and continue with the publishing process;

    3. All Consumer modules should be republished. Republish them or build a solution and publish it in a single step;

    4. Bring modules online using the ‘Bring Online’ button on the detail screen of each application they belong to;

    5. The solution is now staged and all moved modules using their new Catalogs.


Does this point mean that the deployment will be in CI CD mode?


0
0
04 Jun 2024
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP
0
0
04 Jun 2024
Copy Link
2024-06-01 07-14-16
Vaishali Thakur

Hello Deepak,

To create a new database schema, go to Service Center, and in 'Database Schemas' select 'Configure new schema'. Fill in the information for the new schema and download the configuration script. Then, execute the script (as a DBA) in the Oracle database to create the new schema effectively. 

it is helpful for you.

Thanks

1
0
03 Jun 2024
Copy Link
2021-11-12 04-59-31
Manikandan Sambasivam
AI Generated

In OutSystems, the database schema is typically managed by the platform, and it doesn't natively support the creation of multiple schemas within the same environment for a single OutSystems application. However, there are ways to interact with multiple schemas if needed, especially in an on-premise setup where you have more control over the database configuration.

Ways to Work with Multiple Schemas

  1. Use External Databases:

    • You can connect to external databases that have multiple schemas using the Database Connection feature in OutSystems.
    • This approach allows you to interact with tables and views from different schemas by defining entities in OutSystems that map to these external database structures.

  2. Direct Database Access:

    • If you have direct access to the underlying database (e.g., SQL Server, Oracle), you can create additional schemas manually.
    • You can then create views or stored procedures in the primary schema that access data from the secondary schema.

  3. Advanced Queries:

    • In your SQL queries within OutSystems, you can reference tables in different schemas by using fully qualified names (e.g., SchemaName.TableName).


0
2
03 Jun 2024
Copy Link
This answer was AI-generated. Please read it carefully and use the forums for clarifications
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.