You can translate the question and the replies:

How to get Database url

Hello all , Please i need the command to get all database URL on the server Thanks
user
02-02-2023 04:02:38 -0500
code

1 Answer

Hi, I was able to get the Database URL on the Virtual DataPort server with the help of [**GET_ELEMENTS**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_elements) stored procedure and [**DESC Command**](https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands). For a detailed answer, you could refer to the similar Community [**Q&A**](https://community.denodo.com/answers/question/details?questionId=906Du00000000j8IAA&title=List+of+All+DataSource) **Note**: Before creating the **GET_ELEMENTS** stored procedure as a view, create a new JDBC Data source with the respective Denodo Virtual DataPort Database adapter and provide the necessary server configuration details. Then navigate to the Create from Query option and create the Stored procedure view. Once the base view is created, please navigate to the **Search methods ->wrapper source configuration** and ensure the option **Delegate SQL sentence as subquery** is set to **'No'**. By setting this option to No, you can execute the stored procedure without any errors. Hope this helps!
Denodo Team
02-02-2023 08:58:26 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here