DataStage Job Extraction Prerequisites
This topic briefs about the DataStage assessment job extraction prerequisites.
In This Topic:
Introduction
LeapLogic Assessment profiles existing inventory, identify complexity, lineage and provides comprehensive recommendations for migration to modern data platform.
LeapLogic accepts the jobs in XML format. Use this link to extract the DataStage jobs in the required format or follow the steps given below the link.
Export the repository objects without selecting them first using the Export menu.
- Choose Export > DataStage Components. The Repository Export dialog box appears, it is empty (even if you have objects currently selected in the repository tree).
- Click the Add hyperlink. The Select Items dialog box appears allowing you to select objects in the repository tree.
- Use the Add, Remove, and Select all hyperlinks to change the selection if necessary. Selecting Add opens a browse dialog box showing the repository tree.
- From the drop-down list, choose one of the following options to control how any jobs you are exporting are handled:
- Export job designs with executables (where applicable)
- Export job designs without executables (this is the only option available for XML export)
- Export job executables without designs
- Select the Exclude read-only objects check box to exclude such objects from the export.
- Select the Include dependent items check box to automatically include items that your selected items depend upon.
- Click the Options button to open the Export Options dialog box. This allows you to change the exporter’s default settings on the following:
- Under the Default > General branch:
- Whether source code is included with exported routines (yes by default)
- Whether source code is included with job executables (no by default)
- Whether source content is included for data quality items.
- Under the Default > Viewer branch:
- Whether the default viewer or specified viewer should be used (the default viewer is the one Windows opens this type of file with, this is normally Internet Explorer for XML documents, but you need to explicitly specify one such as Notepad for .dsx files). Using the default viewer is the default option.
- Under the XML > General branch.
- Whether a DTD is to be included (no by default)
- Whether property values are output as internal values (which are numeric) or as externalized strings (internal values are the default). Note that, if you chose the externalized string option, you will not be able to import the file that is produced.
- Under the XML > Stylesheet branch:
- Whether an external stylesheet should be used (no by default) and, if it is, the type and the file name and location of the stylesheet.
- Specify or select the file that you want to export to. You can click the View button to look at this file if it already exists (this will open the default viewer for this file type specified in Windows or any viewer you have specified in the Export Options dialog box).
- Select Append to existing file if you want the exported objects to be appended to, rather than replace, objects in an existing file. (This is not available for export to XML.)
- Examine the list of objects to be exported to assure yourself that all the ones you want to export have Yes in the Included column.
- Click Export to export the chosen objects to the specified file.
Also, share the following dependencies-
- All run time parameters (if applicable) used in DataStage jobs as key values pair in a text file.
- DDLs for all tables, views, and stored procedures used within the DataStage jobs (source, lookup, Intermediate and target DDLs)
- Any external scripts (example Shell) used or called by DataStage jobs.
- Test/ validation data sets (input and expected output results. For tables, data should be exported as CSV/TSV files)
Getting Help
Contact LeapLogic technical support at info@leaplogic.io