Importing dataflows
Dataflows are imported Data Transformation Editor and PDI client transformation (KTR) and job (KJB) files tagged for use in Dataflow Studio. When importing, you can also tag dataflows to assign group permissions that define user access to the dataflow file. Your tagged, imported files are then available for users to view, configure, schedule, and execute in Dataflow Studio, depending upon their permissions settings in LDOS.
When you tag in the Extended Description field of the KTR or KJB, you can identify the file as a dataflow, and can assign group permissions to it. As an LDOS administrator or data engineer, you must enter the tag #dataflow
to import a file as a dataflow. Optionally, you can add the tag #group
, where group is the group name, to assign permissions for the dataflow to a specific group or groups.
For example, you could have the following text in the extended description field: #dataflow #HR #Finance #Sales
. In this case, the file appears in Dataflow Studio with permissions assigned to the HR, Finance, and Sales groups. If the dataflow does not include permissions tagging, then it will be available to all users in Dataflow Studio. See Managing users and permissions for details about assigning groups and users to content permissions.
Your dataflow files and permissions are initially imported into Dataflow Studio depending on the interval setting in the Dataflow Importer. Afterward, the dataflow is only reimported if a parameter has been added or removed from the associated KTR or KJB file.
You can make changes to an already imported dataflow:
- To change a parameter or setting, see Editing dataflows.
- To change the permissions, see Manage dataflow permissions.
- To remove a dataflow from Dataflow Studio, delete the existing dataflow file from the import directory. See Upload your KTR and KJB files into Lumada DataOps Suite.
The following steps outline the general workflow when importing dataflows from Data Transformation Editor and the PDI client:
First, Identify KTR and KJB files as dataflows including permissions so they successfully import as dataflows.
Then, Upload your KTR and KJB files into Lumada DataOps Suite to complete the import process.
Identify KTR and KJB files as dataflows including permissions
#dataflow
in the extended description in the main file and
not on the individual KTRs or KJBs, or within any sub-transformations or
sub-jobs within that file. Otherwise, each tagged occurrence creates a separate
dataflow file.Perform the following steps to identify your KTR and KJB files as dataflows.
Procedure
From the Data Transformation Editor or the PDI client, click
.NoteIf your KTR and KJB files are kept in a Pentaho Repository, you must export the files from the repository to perform the following steps to identify them as dataflows. See Export content from the repository in the Pentaho documentation for details.The Open dialog box appears.Browse to and then double-click the KTR or KJB file that you want as a dataflow.
Your selected file opens.Double-click the canvas.
Depending on the selected file type, the Transformation properties dialog box appears or the Job properties dialog box appears.Proceed according to your file type.
- KTR files: In the Transformation tab of the Transformation properties dialog box, locate the Extended description field, then enter
#dataflow
and click OK. To include permissions for the dataflow, add#group
, where group is the group’s name, for each group that requires permissions. To add multiple permissions, separate each additional#group
by a space. - KJB files: In the Job tab of the Job properties dialog box, locate the Extended description field, then enter
#dataflow
and click OK. To include permissions for the dataflow, add#group
, where group is the group’s name, for each group that needs permissions. To add multiple permissions, separate each additional#group
by a space.
NoteIf your Extended description field already contains text, you can add #dataflow after the existing text. You just need to include#dataflow
anywhere in the Extended description field for your KTR and KJB files to become dataflows. Add any group permissions after#dataflow
.- KTR files: In the Transformation tab of the Transformation properties dialog box, locate the Extended description field, then enter
Click
.
Results
Next steps
Upload your KTR and KJB files into Lumada DataOps Suite
Procedure
Check with your system administrator as to the location of the NFS directory set up to upload KTR and KJB files into Lumada DataOps Suite as dataflows.
Navigate to the location of the KTR and KJB files you want to upload into as dataflows.
Copy the KTR and KJB files you want to upload to Lumada DataOps Suite.
Navigate to the specified NFS directory.
Paste the copied files into the NFS directory.
Results
Next steps