Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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.

Examples

Import all jobs from a given directory

isx import command line options
$> 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:

$> 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
 * 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
 * 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
  • No labels

© 2015-2024 Data Migrators Pty Ltd.