You can translate the question and the replies:

Function to synchronize the VDP server metadata with Data Catalog

Hi Team, Do we have the feature in some high version Denodo (such as Version 7.0) , which can have auto metadata synchronize the VDP server metadata with Data Catalog? Then we will have no need to do manual sync VDP metadata to Data catalog, and we will also have no need to do the sync defined in https://community.denodo.com/docs/html/browse/latest/vdp/data_catalog/appendix/rest_api/rest_api#synchronize-elements-with-the-server For developers perspectives, I think it should be a default function to sync the VDP metadata to Data catalog, should be not a alternative option for developers.
user
24-11-2020 23:36:12 -0500

5 Answers

Hi, You can enable the Data Catalog synchronization option in the Solution Manager, the Data Catalog metadata will be synchronized during the deployment process. For more details, you can refer to [Data Catalog Server Synchronization](https://community.denodo.com/docs/html/browse/latest/solution_manager/administration/environment_configuration/configuring_deployments#data-catalog-server-synchronization) section of the Solution Manager Administration Guide. Hope this helps!
Denodo Team
25-11-2020 11:40:24 -0500
Hi, team My senario is, if I do not migrate from solution manager, I just create some objects directly in VDP, will it be shown in Data catalog instantly? Do we have ths function?
user
25-11-2020 21:23:35 -0500
Hi, You could also make use of the [Denodo Scheduler Tool](https://community.denodo.com/docs/html/browse/latest/scheduler/administration/index) to create a VDP job to perform the Data Catalog synchronization task by creating a [JSON data source](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) in the Virtual DataPort Server leveraging the Data Catalog REST API. Currently there is no function to do the synchronization. Hope this helps!
Denodo Team
07-12-2020 12:09:55 -0500
Can you please explain what is the procedure to set this up in Scheduler? I have created a json data source to get the data from Denodo Data catalog Thanks
user
19-03-2021 06:16:24 -0400
Denodo Customer, You can follow the below steps to make use of the Scheduler Tool to schedule a job to perform the Data Catalog synchronization task by leveraging the Data Catalog REST API: 1) Using the Virtual DataPort Admin Tool: * Create a new [JSON data source](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources#json-sources), right-click on the Server Explorer and click New -> Data source -> JSON. * In the Configuration tab, choose HTTP Client from the drop down list as Data route and click on configure button. * Under the Configuration section of the Edit HTTP Connection window, You can use the below values for the parameters to synchronize the server metadata using the REST API request: **HTTP Method:** POST **URL:** <host>:<port>/denodo-data-catalog/apirest/synchronize **Request body:** ``` { "serverName": <text> | "allServers": "true", "type": "view | ws | all", "priority": "local | server | server_with_local_changes" } ``` **HTTP Headers:** Content-Type : application/json Authorization : <User Credentials> * Click on Test Connection button to ensure connection is successful and click on OK button * Save the JSON data source. 2) Create a Base View from the JSON Datasource using "Create Base View" option and execute it. * If everything is working fine you will see a field "result" with value "OK" and then a field "data" which contains an array with information about the last execution of this synchronization. 3) Create a new VDP job using the Denodo Scheduler in order to execute this View (JSON base view). * You will need to add an VQL Query at the [Extraction Section](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section#vdp-extraction-section) in order to execute this view. * You can configure the execution of this job daily at the [Triggers Section](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/time-based_job_scheduling_section#time-based-job-scheduling-section) of the job. Please refer to the [Synchronize Elements with the Server](https://community.denodo.com/docs/html/browse/7.0/vdp/data_catalog/appendix/rest_api/rest_api#rest-api) section of REST API in Data Catalog Guide and [General Structure of a Job](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/general_structure_of_a_job#general-structure-of-a-job) section of the Scheduler Administration Guide to get more information about this. Hope this helps!
Denodo Team
31-03-2021 08:57:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here