Deployment of VDTs

ONE DATA Core
1

Hi there,
I was wondering if there is already a solution to the following scenario:
We are working on an internal instance and are developing a “data-product” with test-data. Then I want to deploy this state of the data-product to a customer instance.
I then initialize my backend workflows with the customer data, meaning I create all necessary datatables from the customer data. However we are also using VDTs a lot.
How can I now transfer the VDTs based on certain datatables from the develop-instance to the customer-instance without overriding my datatables, that were initialized with customer-data, with the test-data from the export of our develop-instance.

TLDR: Is there a way to just transfer/update the VDTs without the need of also transferring actual datatables?

Thanks

2

maybe, you can use Python SDK to collect SQL queries of your VDT on the internal instance, and again using Python SDK you could create VDTs on the customer’s instance:

https://confluence.intranet.onelogic.de/display/OD/Virtual+Data+Tables+SDK

3

Thanks for your answer, we are already collecting the VDT-queries, however it is not possible to access the customer-instance easily via the internet.

So I guess there is no way to automate the manual step of setting up the VDTs (or doing another manual step like copying the query-definitions into a python-processor on the customer’s ONE DATA instance). :frowning: