---
title: "Improvements in the creation of ontologies on external databases"
canonical: "https://onesaitplatform.refined.site/space/DOCT/2220828530/Improvements%20in%20the%20creation%20of%20ontologies%20on%20external%20databases"
format: markdown
---
Before this release, you could only generate ontologies from external databases that came directly with the connection (and, therefore, forcing to include the database and/or the schema, depending on the database type, in the connection url). With this, you don’t have the abilities to cross-reference tables that are in different schemas or databases in the same connection and that the database itself allows crossing. Besides, this forced you to generate a connection of each smaller level to be able to access the tables.

With the new platform version, you can now choose the database and/or the schema (as applicable in each database) before selecting the table.

![image](media://7a0e2e9c-1979-4c6f-8659-743ade2c6a8d)

It is also possible to create new tables with these options, allowing for a comprehensive management of a database with a single connection.

Internally, the executed query will be translated into the complete path to the ontology itself.

![image](media://f674901d-52e0-4087-943b-d319d1b8cdb6)

![image](media://34d39562-a7c4-4863-864d-112c4a440b2d)

Given this query:

![image](media://c855a97d-6325-494b-a7b9-1852eb0b44c1)

Its actual execution will be:

![image](media://7653a341-5f96-4eaa-a17d-8ce4fa7f7655)