Do we have an option to create bulk dataflows like 10 dataflows at a time??

Scenario:

I have a scenario, where I need to create bulk number of data flows at once. Is there any option to achieve this functionality. Rather than creating all the data flows manually.

Beginner Asked on February 11, 2020 in Diyotta Studio.
Add Comment
2 Answer(s)
Yes, through Data Movement Wizard we can create bulk data flows at a time.
Steps:
1. Click on DMW Wizard in Studio
2. Select required Data base as native from list.
3. Check “Create Data Flow for each Target” check box.
4. Select required sources(different databases can be selected)
5. Select Data objects
6. Select the required data base as target.
7. Select all sources or required sources by checking the check box then click on “Generate Targets” button
We can create bulk data flows in only one native at a time.
Multiple source’s can be from any data base and target database which we choose applies for all the sources
Expert Answered on February 18, 2020.
Add Comment

In the 4.5 version of Diyotta,  DMW Wizard is made easily accessible by placing it beside the Data Flow option in the list screen.  Simply hovering over the Data Flow lets us create a DMW in the Studio module.

 

1. Click on DMW Wizard in Studio

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??

2. Select the required Database as native from list.

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??

3. Select required sources(different databases can be selected)

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??


5. Select Data objects

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??


6. Select the required database as a target.

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??


7. Select all sources or required sources by checking the checkbox then click on “Generate Targets” button

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??

RE: Do we have an option to create bulk dataflows like 10 dataflows at a time??

We can create bulk data flows in only one native at a time.
Multiple sources can be from any database and target database which we choose applies for all the sources

 

Expert Answered on June 24, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.