Versions Compared

Old Version 29

changes.mady.by.user John McKeever

Saved on

compared with

New Version Current

changes.mady.by.user John McKeever

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

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

Syntax

...

Include Page
isx export command syntax
isx export command syntax

...

The export location is structured to mirror the structure of your DataStage repository. In the example below we use a -jobname filter to select a set of jobs in the /Jobs/Load category of our DataStage project. The isx export command mirrors this be creating our exported ISX files in a /Jobs/Load folder which it creates during the export process.

Code Block
languagebashnone
# Export our ISX files

C:\MettleCI\cli> mettleci isx export ^
     -domain myteam-svcs.corp.com:59445 ^
     -username myuser -password mypassword ^
     -server myteam-engn.corp.com ^
     -project myproject ^
     -jobname .*LD_S.*
Exporting [.*LD_S.*] from repository...
Exporting DataStage assets...
 * Export 'myteam-engn.corp.com/myproject/Jobs/Load/LD_SUPPLIER.pjb' - COMPLETED
 * Export 'myteam-engn.corp.com/myproject/Jobs/Load/LD_STOCK_HOLDING.pjb' - COMPLETED
 * Export 'myteam-engn.corp.com/myproject/Jobs/Load/LD_STOCKITEM.pjb' - COMPLETED
 * Export 'myteam-engn.corp.com/myproject/Jobs/Load/LD_SALE.pjb' - COMPLETED
Export complete

# See the created Jobs directory

c:\MettleCI\cli>dir
 Volume in drive C has no label.
 Volume Serial Number is 8C74-3344

 Directory of c:\MettleCI\cli

15/09/2022  07:29 PM    <DIR>          .
15/09/2022  07:29 PM    <DIR>          ..
15/09/2022  07:29 PM    <DIR>          <SNIP>
15/09/2022  07:29 PM    <DIR>          Jobs
               8 File(s)          9,555 bytes
               8 Dir(s)  15,827,730,432 bytes free

# ... sub-directory

c:\MettleCI\cli>dir Jobs
 Volume in drive C has no label.
 Volume Serial Number is 8C74-3344

 Directory of c:\MettleCI\cli\Jobs

15/09/2022  07:29 PM    <DIR>          .
15/09/2022  07:29 PM    <DIR>          ..
15/09/2022  07:29 PM    <DIR>          Load
               0 File(s)              0 bytes
               3 Dir(s)  15,827,730,432 bytes free

# ... and our ISX files

c:\MettleCI\cli>dir Jobs\Load
 Volume in drive C has no label.
 Volume Serial Number is 8C74-3344

 Directory of c:\MettleCI\cli\Jobs\Load

15/09/2022  07:29 PM    <DIR>          .
15/09/2022  07:29 PM    <DIR>          ..
15/09/2022  07:29 PM            14,161 LD_SALE.isx
15/09/2022  07:29 PM            13,623 LD_STOCKITEM.isx
15/09/2022  07:29 PM            10,010 LD_STOCK_HOLDING.isx
15/09/2022  07:29 PM            11,916 LD_SUPPLIER.isx
               4 File(s)         49,710 bytes
               2 Dir(s)  15,827,783,680 bytes free

c:\MettleCI\cli>

...

Incrementally export project binaries, C:/shared/myproject/export is a directory containing previously exported ISX files and C:/shared/myproject/cache contains state files related to incremental operations performed against myproject:

Code Block
languagebashnone
C:\MettleCI\cli\> mettleci isx export ^
     -domain myteam-svcs.corp.com:59445 ^
     -username myuser -password mypassword  ^
     -server myteam-engn.corp.com  ^
     -project myproject  ^
     -location C:\shared\myproject\export  ^
     -include-binaries  ^
     -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 myteam-engn.corp.com/myproject/Jobs/Connections/DMSqlServer_DW.dcn - COMPLETED
 * Check myteam-engn.corp.com/myproject/Jobs/Connections/DMSqlServer_OLTP.dcn - COMPLETED
<SNIP>
 * Check myteam-engn.corp.com/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED
 * Check myteam-engn.corp.com/myproject/Jobs/ParameterSets/pDMSqlServer_DW.pst - COMPLETED
Change identification complete
Inspecting ParameterSet definition changes...
ParameterSet definition change identification complete
Deleting assets...
 * Export 'C:\shared\myproject\export\Jobs\Transform\TR_PURCHASE.isx/Jobs/Transform/TR_PURCHASE.pjb' - DELETED
 * Export 'C:\shared\myproject\export\Jobs\Transform\TR_ORDERS.isx/Jobs/Transform/TR_ORDERS.pjb' - DELETED
Deletion complete
Exporting DataStage assets...
 * Export 'myteam-engn.corp.com/myproject/Jobs/Transform/TR_ORDERS.pjb' - COMPLETED
 * Export 'myteam-engn.corp.com/myproject/Jobs/Transform/TR_PURCHASE.pjb' - COMPLETED
Export complete
Attempting to identify last change with 4 working threads.
Inspecting DataStage assets for last change...
 * Check myteam-engn.corp.com/myproject/Jobs/ParameterSets/pDMSqlServer_OLTP.pst - COMPLETED
 * Check myteam-engn.corp.com/myproject/Jobs/ParameterSets/pGlobal.pst - COMPLETED
<SNIP>
 * Check myteam-engn.corp.com/myproject/Jobs/Transform/TR_PURCHASE.pjb - COMPLETED
 * Check myteam-engn.corp.com/myproject/Jobs/Transform/TR_ORDERS.pjb - COMPLETED
Last change identification complete

...