You can translate the question and the replies:

vql to get only the exact database URI for data source in Denodo

HI team, do we have some system table, or vql command, which get only the exact database URI for a Denodo data source, for example we only want to get below kind of information: jdbc:oracle:thin:@aassddcc.compant.com:6566/aassddcc I understand we have "desc datasource JDBC data_source_name" can get above inforamtion, but it return much information, what we want to get is only the database URI information. Thanks.
user
13-02-2021 03:06:12 -0500

3 Answers

Hi, To obtain only the database URI of the datasource, I would perform the below steps in the Virtual DataPort Administration Tool: * **[Create a JDBC datasource](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources)** by selecting the appropriate Denodo Virtual DataPort adapter as the Database adapter and provide necessary details. * Then, create a base view using the **[create from query](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries)** option and use the **[DESC](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands#output-schema-of-the-desc-commands)** command with **[interpolation variables](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables)** like ‘**Desc datasource @datasource_type @datasource_name**’ * Navigate to **Options** -> **Search methods** of the created base view and in the **wrapper source configuration** section, I would set the ‘**Delegate SQL sentence as subquery**’ as ‘**NO**’ in order to send the query to the datasource directly instead of sending as a subquery. * Then, **[create a selection view](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#creating-selection-views)** upon this base view to get only the Connection URI as the output field. Now, when I execute this selection view by providing the database name and data source name, I was able to get the Database URI information for the inputs specified. You can take a look at a similar community **[data source connection string information](https://community.denodo.com/answers/question/details?questionId=9060g0000004ElSAAU&title=data+source+connection+string+information)** for more information. Hope this helps!
Denodo Team
15-02-2021 06:29:18 -0500
Thanks for your reply, so for the first step "Create a JDBC datasource selecting the appropriate Denodo Virtual DataPort adapter as the Database adapter", not very understand, what is the " appropriate Denodo Virtual DataPort adapter"? Can I use an oracle adapeter? does it mean to create a datasource to connect any denodo VDP? can this data soruce to connect to the VDP that this data source in?
user
16-02-2021 08:36:12 -0500
Hi, To query the **[DESC](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/describing_catalog_elements/describing_catalog_elements#syntax-of-the-statement-desc)** command, Virtual DataPort server has to connect to itself by creating Virtual DataPort server as a data source. For creating the Virtual DataPort server as a data source , I would **[create a JDBC datasource](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources)** by selecting the **Virtual DataPort 8.0** as the **Database adapter** from the drop down list. Then, I would configure the default **Database URI** for the Virtual DataPort server like **“jdbc:vdb://localhost:9999/admin”** and provide the authentication credentials for establishing the connection. You can take a look at the **[Supported JDBC Data Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources#supported-jdbc-data-sources)** section of the Virtual DataPort Administration Guide for the list of supported Virtual DataPort Adapters in Denodo Platform. Hope this helps!
Denodo Team
23-02-2021 00:23:51 -0500
You must sign in to add an answer. If you do not have an account, you can register here