Hello,
I currently have this new requirement that says I have my environment that has multiple applications all of them are connected to a single MSSQL Database for the sake of the question let's call it "OS_Dev"
I want to create a new database schema let's call it "OS_Meetings" I want a specific application to read and write from and on the new schema how is that possible
Note: My DevOps/System administrator is currently indisposed and I am taking the role as a developer on this task
Note:2 I did my research and I am not looking to connect to an external database but a database that my tables on the data tab in service studio can connect to
Thank You very much
Hi,
You can use integration builder or intigration studio for coonect other database in outsystem.
once you follow the step of coonection.the entity will shown in service studio.
https://www.outsystems.com/low-code-platform/integration-builder/
Thanks
CV
Hello Ahmad,
First of all, you cannot create a new DB/schema from Outsystems data tab. It can only be done in specific DBMS client.
You want to maintain 2 DB for a single connection within internal DB, that is also not possible, a platform can be connected to only one DB/Schema at a time and that also done at time of your platform installation as platform requires a DB.
Ref: https://success.outsystems.com/documentation/11/setup_outsystems_infrastructure_and_platform/setting_up_outsystems/default_platform_server_and_database_configurations/
The only way to maintain another DB for a specific application will be using external DB connection. you can actually create a new connection and connect to same DB server(as internal). you can restrict DB permissions for different user while creating a new connection.
Hope it helps!