Document toolboxDocument toolbox

DataStage Capture Command

Owned by Barry Squire
Last updated: Sept 04, 2024 by John McKeever
3 min read

Purpose

This command captures the current state of a DataStage project by exporting its content to ISX files and updating the project cache. The resulting ISX files and project cache can be used by the DataStage Deploy command to incrementally deploy changes that have occurred after DataStage Capture was performed.

  • the -location parameter specifies the root directory of ISX files exported from the project.

  • the -project value is the name of the DataStage target project.

  • the -project-cache parameter specifies a shared directory containing state information for this DataStage target project. These are the DataStage asset fingerprints which are used to identify changes in your DataStage code. See our more detailed explanation.

  • the -threads parameter specifies how many concurrent compilation operations will be performed.

Syntax

 

Example

Capture the current state of the project.

c:\> mettleci datastage capture ^ -domain datastage-services.myorganization.com:59445 ^ -server datastage-engine.myorganization.com ^ -project myproject ^ -username isadmin ^ -password **** ^ -location datastage ^ -threads 4 ^ -project-cache "C:\MettleCI\cache\datastage-engine.myorganization.com\myproject" MettleCI Command Line (build 128) (C) 2018-2022 Data Migrators Pty Ltd Analyzing DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject Exporting DataStage assets... * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_SUPPLIER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Connections/DMSqlServer_OLTP.dcn' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Utilities/UT_CONTROL.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_TRANSACTION.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_PURCHASE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_TRANSACTION_TYPE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_CUSTOMER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_CITY.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_STOCKITEM.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_ORDERS.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_STOCKITEM.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_STOCK_HOLDING.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/ParameterSets/pDMSqlServer_DW.pst' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_MOVEMENT.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_SALE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/ParameterSets/pGlobal.pst' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_MOVEMENT.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_ORDERS.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_TRANSACTION_TYPE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_EMPLOYEE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_CUSTOMER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Connections/DMSqlServer_DW.dcn' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_ORDERS.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_TRANSACTION_TYPE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Utilities/UT_LOAD_TABLE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_CITY.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_CUSTOMER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_CITY.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_PAYMENT_METHOD.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_EMPLOYEE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/ParameterSets/pDMSqlServer_OLTP.pst' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_STOCKITEM.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_TRANSACTION.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_MOVEMENT.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_SUPPLIER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_TRANSACTION.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_PAYMENT_METHOD.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_SALE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Load/LD_PURCHASE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_SALE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_PURCHASE.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_PAYMENT_METHOD.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_SUPPLIER.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Transform/TR_STOCK_HOLDING.pjb' - COMPLETED * Export 'DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject/Jobs/Extract/EX_EMPLOYEE.pjb' - COMPLETED Export complete Attempting to identify last change with 4 working threads. Inspecting DataStage assets for last change... Last change to project occurred at 2023-12-21 04:37:37 GMT

 

The DataStage Project has been captured as a set of ISX files and the project cache. Deploying the captured state back into the source project will not cause any changes to be detected:

c:\> mettleci datastage deploy -domain datastage-services.myorganization.com:59445 -server datastage-engine.myorganization.com -project myproject -username isadmin -password **** -assets datastage -threads 4 -project-cache "C:\MettleCI\cache\datastage-engine.myorganization.com\myproject" MettleCI Command Line (build 128) (C) 2018-2022 Data Migrators Pty Ltd Analyzing DATASTAGE-ENGINE.MYORGANIZATION.COM/myproject Attempting to identify changes with 4 working threads. Inspecting DataStage assets for changes... Change identification complete, 0 asset changes detected in project

 

© 2015-2024 Data Migrators Pty Ltd.