Document toolboxDocument toolbox

ISX Import Command

Owned by Stuart Norton
Last updated: Apr 11, 2024 by John McKeever
2 min read

Purpose

Imports the contents of ISX files underneath a defined location into a DataStage project.  Incremental imports can be performed by including the -project-cache parameter.

See Repeatable DataStage Project Deployments for more details on how the -project-cache parameter is used to implement incremental imports. For more information on using the -project-cache parameter see our detailed explanation.

Note that the isx import commands requires access to a correctly-functioning istool command and so is only executable on a Windows-based DataStage Client Tier.

Syntax

 

image-20240411-021538.png

 

Examples

Import all jobs from a given directory

$> mettleci isx import \ -domain test2-svcs.datamigrators.io:59445 \ -username myuser -password mypassword \ -server test2-engn.datamigrators.io \ -project myproject \ -location /tmp/isx_location Analyzing test2-engn.datamigrators.io/myproject Optimising assets for import Attempting to import with 1 working threads. Importing DataStage assets... * Import 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SALE.pjb' - COMPLETED * Import 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb' - COMPLETED * Import 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCKITEM.pjb' - COMPLETED * Import 'test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SUPPLIER.pjb' - COMPLETED Import complete

Incrementally import project binaries only

This example incrementally imports project binaries, ignoring Job design information. Any Jobs in the project which do not exist in the source directory are deleted from the project.  C:/shared/myproject/export is a directory containing ISX files (with binaries) to be imported and C:/shared/myproject/cache contains state files related to incremental operations performed against myproject:

$> mettleci.cmd isx import \ -domain test2-svcs.datamigrators.io:59445 \ -username myuser -password mypassword \ -server test2-engn.datamigrators.io \ -project myproject \ -location c:/shared/myproject/export \ -exclude-designs \ -project-cache c:/shared/myproject/cache Analyzing test2-engn.datamigrators.io/myproject Attempting to identify changes with 4 working threads. Inspecting DataStage assets for changes... * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_MOVEMENT.pjb - COMPLETED * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_TRANSACTION_TYPE.pjb - COMPLETED <SNIP> * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_DW.pst - COMPLETED * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED Change identification complete Deleting assets... * Delete 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb' - COMPLETED * Delete 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb' - COMPLETED Deletion complete Optimising assets for import Attempting to import with 1 working threads. Importing DataStage assets... * Import 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb' - COMPLETED * Import 'test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb' - COMPLETED Import complete Attempting to identify last change with 4 working threads. Inspecting DataStage assets for last change... * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_OLTP.pst - COMPLETED * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_DW.pst - COMPLETED <SNIP> * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_EMPLOYEE.pjb - COMPLETED * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCKITEM.pjb - COMPLETED Last change identification complete

 

© 2015-2024 Data Migrators Pty Ltd.