Skip to Main Content
Return to Navigation

Importing and Exporting Repository Components

Using the DataStage Designer import and export facilities enable you to move jobs or other components between projects. You can also move projects, jobs, or components from one system to another. In addition, you can import components from text files or XML documents, and you can export to XML documents. XML documents can be used as a convenient way to view descriptions of repository objects using a web browser.

Importing

The DataStage Designer import facility enables you to import:

  • ETL projects, jobs, or other components that you export from another system.

  • DataStage components, such as table definitions, from text files or XML documents.

You can use the Import facility to import table definitions from a variety of file types, including sequential files, ODBC, and XML.

Image: Import Menu Item

This example illustrates the Import Menu Item.

Import Menu Item

Image: Import DSX Component

This example illustrates the Import DSX Component.

 Import DSX Component

Exporting

The DataStage Designer export facility enables you to export:

  • ETL projects, jobs, or other components.

  • Jobs or other components to XML documents.

  • Job executables.

  • Package server jobs using the Packager Wizard.

When you export projects or components, by default they are stored in text files with the file extension .dsx. You can also export to XML files by selecting the appropriate check box in the Export window. You also have the option to append the exported items to an existing file.

Image: Export Menu Item

This example illustrates the Export Menu Item.

Export Menu Item

Image: Export - Repository Export window

This example illustrates the Export - Repository Export window.

Export - Repository Export window