You can translate the question and the replies:

Denodo REST API for DB specific properties file

Hi, Can you plase provide the details on the API that can be used to import the properties file to the target environment in the promotions process. Thanks
user
12-10-2022 09:54:03 -0400
code

1 Answer

Hello, I understand that you want to programmatically implement the promotion from the source environment to the target environment. To accomplish this you need an API to import the VDP properties file. The implementation of promotion involves [Creation of Revision](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/promotions/creating_revisions/creating_revisions#sm-creating-revisions) on source environment and [Deployment of Revision](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/promotions/revisions_table/revisions_table#deploy-revisions) on the target environment. The API available in Denodo to create revision is specifically with a VQL file only and for deployment from existing list of revisions.You can refer to the document [Create Revision Using VQL File](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/appendix/rest_api/rest_api#create-a-revision-from-a-vql-file) and [Deployment From List of Revision](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/appendix/rest_api/rest_api#start-a-new-deployment-from-a-list-of-revisions) to know more about these API. In order to programmatically implement promotion from source environment to target environment, following approaches could be considered : 1. In this approach, first create the revision with VDP properties file graphically in the Solution Manager by clicking on **Source Environment > New Revision** and then deploy it using the Deployment From List of Revision API. 1. In this approach you can use the Create Revision Using VQL File API for creating the revision step and Deployment From List of Revision API to deploy the created revision. You can refer to the [Q/A](https://community.denodo.com/answers/question/details?questionId=9064u0000004FdZAAU&title=Using+Create+Revision+API+of+Solution+Manager) to get more information on generating the required VQL file. Hope this helps!
Denodo Team
13-10-2022 21:01:17 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here