You can translate the question and the replies:

How to create self-referential data source?

Hello Denodo experts, I want to create a base view from query from a self-referential data source..how do I create this self-referential data source? Please advise. Thanks!
user
06-12-2019 01:13:57 -0500
code

1 Answer

Hi, I did the following to create a self-referential data source: 1. In Virtual DataPort, create a new [JDBC data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources). 2. From the dropdown list, select the appropriate version of the Denodo Virtual DataPort database adapter (e.g. Denodo Virtual DataPort 7.0) which will fill in the driver class path and the driver class. 3. Provide the database URI and valid credentials for the Virtual DataPort server. Now, I can use ["Create Base View from Query"](https://community.denodo.com/kb/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option?category=Data+Sources) on top of this self-referential data source. You can take a look at this Community Q&A of a use case related to self-referential data sources in Denodo: * [Extract the origin of a data source in metadata for report view](https://community.denodo.com/answers/question/details?questionId=9060g000000bmSMAAY&title=Extract+the+origin+of+a+data+source+in+metadata+for+report+view) Hope this helps!
Denodo Team
06-12-2019 15:28:28 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here