Page Comparison

Page Properties

hidden	true
id	mettleci-cli

Namespace	isx
Command	import
Plugin Name	isx
Plugin File	dm-isximport-plugin.jar
Credentials	IS/DS

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 switch.

Include Page

	isx import command syntax
	isx import command syntax

Examples

Import all jobs from a given directory

Code Block

isx import command line options

title	language	bash

$> 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 (ignores designs), 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:

Code Block

language	bash

$> 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
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_STOCKITEM.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_TRANSACTION_TYPE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_MOVEMENT.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_EMPLOYEE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Utilities/UT_LOAD_TABLE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Utilities/UT_CONTROL.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_MOVEMENT.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_EMPLOYEE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_TRANSACTION_TYPE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_STOCKITEM.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_EMPLOYEE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCKITEM.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pDMSqlServer_OLTP.pst - 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
 * Check test2-engn.datamigrators.io/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED
 * 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
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_STOCKITEM.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_TRANSACTION_TYPE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_MOVEMENT.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_EMPLOYEE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_CUSTOMER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Utilities/UT_LOAD_TABLE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_ORDERS.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Utilities/UT_CONTROL.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_CITY.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_MOVEMENT.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_SALE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_TRANSACTION.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_EMPLOYEE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_PURCHASE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_SUPPLIER.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Extract/EX_TRANSACTION_TYPE.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Load/LD_PAYMENT_METHOD.pjb - COMPLETED
 * Check test2-engn.datamigrators.io/myproject/Jobs/Transform/TR_STOCKITEM.pjb - 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

...

Versions Compared

Old Version 11

New Version 12

Key

Purpose

Examples