Import utility in Diyotta Studio is used to deploy the Studio code available in JSON format. This along with export utility is used to deploy Diyotta code from one Diyotta environment to another. The JSON file to be imported always includes all the dependent and associated objects, so it is necessary that you use appropriate import options for each object included in the JSON file. These import options are explained further down. To import the Studio objects, follow below steps.

Step I: On the Navigation pane, click on Job Flow and on the Actions menu, click Import. 

Note: Import action is available under Actions menu of all the Studio objects interface. JSON file can be imported from any of the Studio objects interface.

Step II: In this scenario, Import Object window appears and allows you to select the JSON file to be imported, click Browse.

Step III: Once the JSON file is chosen, you can preview the encrypted JSON file details in the window. Click Next (here Job flow JSON file is selected for reference, but you can also select any studio object JSON file).

Step IV: Map the project(s) in the import JSON file to appropriate project in Diyotta.

The wizard displays the projects, layers and the groups in the JSON file under Name field and the projects, layers and groups in the Diyotta environment is displayed under Mapped To field. You need to select the appropriate mapping for these from Mapped To dropdown. This will ensure that the objects under certain project, layer and group in the JSON file are imported into the appropriate project, layer and group in the target Diyotta environment. Rules for default mapping are below.

  • If the project and layer with same name as in the JSON file exists in the Diyotta target environment then, in the Options dropdown this project and layer will be selected by default. 
  • If the project or layer with same name as in the JSON file does not exist in the target then, random assignment will be made. 
  • If the group with same name does not exist in target Diyotta environment then, the group will be created during import.
  • If the JSON file contains objects from global project then, ensure that a global project is selected from the Options dropdown for the target Diyotta environment.

Note: 

  • To go back to previous wizard, click Back.
  • To go back to Home screen, click Cancel.

Step V: Specify option to import studio objects.

When importing the studio objects select one of the below options. The options displayed and the one selected by default are based on the JSON file being imported and the target Project.

  • Import: Use this option when importing the object which is not already present. This is the default option if the object is not present in the Diyotta environment.
  • Rename: Use this option if you want to import the object with a different name or if the object already exists and you want to import it as a new object. When this option is used, the field next to it is enabled to specify the name to be given for the new object.
  • Ignore: Use this option if you want to skip the object while importing the file. This option should be used only if the object is not used as dependency in any other task. 
  • Reuse: Use this option if you do not want to import the object and use the existing object in the target project. This option will be shown only if the object is present in the Diyotta environment and is default in this scenario.
  • Replace: Use this option if you want to overwrite the object already present in the target project. This option will be shown only if the object is present in the Diyotta environment.
To apply same option to all the objects listed for import, select option for one data point, and click on the Apply To All icon next to options.

1. Specify option to import Data Point

If the import JSON file includes Data Point then this window will be displayed. Choose the required option and Click Next.

Note: 

  • To apply same option to all the data points listed for import, select option for one data point, and click on the Apply To All icon next to options.
  • If agent assigned to the data point being imported is not available in the target Project then, after import, the data point will be invalid and appropriate agent needs to be assigned.
  • Note below points when replace option is used during import of data point.
    1. If the data point being imported does not have all the database or schema which is present in the target Project then, after import, the objects associated to the missing database or schema will become invalid.
    2. If in the data point, the password is hardcoded value then, during export the value in the password field is masked. So, after importing this data point the password needs to be reentered by the user. If project parameter is used in password field then, the parameter appears as is post import also.

2. Specify option to import Job Flow

If the import JSON file includes Job Flow then this window will be displayed. Choose the required option and Click Next.

Note: 

  • To apply same option to all the jobs listed for import, select option for one job, and click on the Apply To All icon next to options.
  • If agent assigned to any job in the job flow being imported is not available in the target Project then, after import, these jobs will be invalid and appropriate agent needs to be assigned.

3. Specify option to import Data Flow

If the import JSON file includes Data Flow then this window will be displayed. Choose the required option and Click Next.

Note: To apply same option to all the data flow listed for import, select option for one data flow, and click on the Apply To All icon next to options.

4. Specify option to import Data Objects

If the import JSON file includes Data Objects, then this window will be displayed. Choose the required option and Click Next.

Note: 

  • To apply same option to all the data objects listed for import, select option for one data flow, and click on the Apply To All icon next to options.
  • When replace option is used during import of data object, if there is any difference in name or the attributes are less in the data object being imported compared to the target Project then, the data flows which use these data objects will become invalid.

5. Specify option to import UDF

If the import JSON file includes UDFs, then this window will be displayed. Choose the required option and Click Next.

Note: To apply same option to all the UDFs listed for import, select option for one UDF, and click on the Apply To All icon next to options.

6. Specify option to import Expression

If the import JSON file includes Expressions, then this window will be displayed. Choose the required option and Click Next.

Note: To apply same option to all the Expressions listed for import, select option for one Expression, and click on the Apply To All icon next to options.

7. Specify option to import Sequence

If the import JSON file includes Sequences, then this window will be displayed. Choose the required option and Click Next.

Note: To apply same option to all the Sequences listed for import, select option for one Sequence, and click on the Apply To All icon next to options.

8. Specify option to import Project Parameter

If the import JSON file includes Project Parameter, then this window will be displayed. Choose the required option and Click Next.

Note: 

  • To apply same option to all the Project Parameters listed for import, select option for one Parameter, and click on the Apply To All icon next to options.
  • For project parameters, only Import, Reuse and Replace option is available during import.

Step VI: Finally, review the objects being imported.

The wizard lists all the objects that are going to be imported. To complete the import process, click Finish.

Note: After importing any studio object, the wizard imports all the dependent objects as per the hierarchy.  

The imported objects will be displayed in the respective object interface windows.

Step VII:To save the changes, on the Actions menu, click Save.

Note: 

  • If the changes need to be reverted and not saved then, click Revert.
  • Once the changes have been saved then, click Close or Unlock so that it is editable by other users.