ETL+ Command Line Interface

Syntax for Windows Shortcuts and /wiki/spaces/DS/pages/1990131716 to ETL+

<path>

How to find the folder path containing \DataSelf ETL Plus.exe

1. Open the /wiki/spaces/DS/pages/1570832586page.

2. Select the Log and Working File Folder button > Select ETL App Folder

   

<entity-id>

The entity id is shown after the Entity label on the lower left hand corner of most ETL+ pages.

<job-id>

The job id is shown on the ID column of the /wiki/spaces/DS/pages/1571225805

Example

From

"C:\Program Files\DataSelf ETL Plus\DataSelf ETL Plus.exe" -e sample_entity -j 3

x

ETL+ Version 2022.08

Syntax for Windows Shortcuts and /wiki/spaces/DS/pages/1990131716 to ETL+

“<path>\DataSelf ETL Plus.exe" x<<parameter-1>x<parameter-2> … <parameter-n>

Parameters:

• Run an Entity’s Job: x-e <entity-id> x-j <job-id>

• Show the Log UI for an entity: x-e <entity-id> x-ui Log

• Show the Load UI for an entity’s running Job:
  x-e <entity-id> x-ui Load x-j <job-id>

Example:

Run job (ID) number 2 from Entity 1-j-acu4a:

• "C:\Program Files\DataSelf ETL Plus.exe" -e 1-j-acu4a -j 2

ETL+ Version 2022.02 and Before

Syntax for Windows Shortcuts and command line interface to ETL+

“<path>\DataSelf ETL Plus.exe" "<<entity-id>>" "0" "<RefreshBatchID>” [“<optional local logging>”]

Examples:

• "C:\Program Files\DataSelf ETL Plus.exe" "mycorp" "0" "1"
  Runs Refresh Batch #1 for mycorp entity.

• "C:\Program Files\DataSelf ETL Plus.exe" "mycorp" "0" "2" "1"
  Runs Refresh Batch #2 for mycorp entity and starts local-disk logging before ETL+ connects to its metadata in the cloud. This can be helpful when debugging if ETL+ is not working at all (usually, a Windows security issue).

The syntax above is also used in ETL+ tasks created in Windows Task Scheduler (WTS).

Related Pages

• /wiki/spaces/DS/pages/1892679685

• /wiki/spaces/DS/pages/1990131716

v2022.08 ✅