err, just one extension and configure it via service center?
so, in the operation-tab of the extension you have a "Logical Database" information
there you point it towards the correct database.
this you will change according to which database you have to point to.
those database-connection are set in the adminstration tab and then databaseconnections.
see for more info: https://www.outsystems.com/help/servicestudio/9.1/#t=Integrating_with_other_systems%2FConnect_to_an_External_Database.htm
how do you name the entities?
Chances are you have the "table or view name" as something like "somename"."myentity".
and you simply have to remove "somename".
furthermore, are you sure that logging in via the new connection you do get the new schema?
if this is not helping, I suggest to provide some example and "dummy" screenshots of the several connections etc...
For anyone else still facing this issue, check out the "Remove database name from the Extension in Dev environment" section of the new step by step guide on how to deploy an integration with an external SQL Server or Azure Server database.
Cheers
Sorry for resurrecting this topic, but context is very important.I faced the exact same problem today, but I found a very strange thing in Integration Studio importing or defining a Logical Database.I was using a component from forge and the queries against platform log tables were failing due to table not found.I created a new database connection with known logical name and edited and republish the extension to use that logical database name and it still failed.I then reimported the tables and see that integration studio were fixing the database name in physical table name.Then if I desire to map an extension that use different databases per environment it will never work because the database name may be different between environments.It makes no sense to have the database name fixed on extension entity definition and use an Service Center database connection where I can choose any database even with different credentials.I think the platform was using the connection do Main database and not one to the connection defined in Service Center and mapped in extension operation page.If the user of main database does not have access to database of new database connection them the query will not run...I think it is not by design and may be changed over time.Can you tell me if it had behave different in the past?Regards,Márcio.