The External Process File Provider is a highly configurable option to connect to data within Workbench. By executing a script, you can connect to data, hardware, or even perform transformations between two databases. If you can write a script to perform the action, you can execute it using the External Process File Provider in Workbench.
Using the External Process File Provider
To create an External Process File Provider DataSet job in Workbench 4,
- Click Add New in the DataSet Jobs grouping in the Buttons toolbar at the top of the Workbench window.
This opens the Workbench DataSet Job Creation Wizard.
(Conditional) If requested, select the desired Domo server. (This screen only appears if you have set up more than one connection to Domo.)
In the DataSet Job Name field, enter a name for the DataSet Job. This is the name of the job as it appears in Workbench, not the name of the uploaded DataSet in Domo.
In the DataSet Name field, enter the name of the DataSet. This is the name of the uploaded DataSet in Domo.
Select the desired update method in the Update Method menu:
a. Select Replace DataSet if you want the DataSet to be replaced entirely upon updating.
b. Select Append to DataSet if you want new data to be added to the existing DataSet upon updating.
In the Transport Method menu, select External Process File Provider.
In the DataSet Type field, select the type of DataSet in the dropdown or enter a custom name.
The DataSet type you select or enter here is reflected as the connector type in Domo after you execute the job.
Tip: It is recommended that you select or enter the DataSet type that tells users what data is being represented, not the data reader you are using to present the data. For example, you might be connecting to an ODBC database that contains Twitter data. In this case, the best option would be to enter "Twitter" rather than selecting ODBC because the data you are representing in Domo is from Twitter.
(Optional) Enter a description in the DataSet Description field.
A new External Process File Provider DataSet Job is added to the list of jobs for the currently authenticated server in the Accounts pane.
Under the External Process File Provider DataSet Job that was just added to the jobs list, select Source.
A panel opens with options for configuring your External Process connection and defining your script file.
The following table describes the available options:
|Program Executable||Locate and enter the executable application file (script) to pull data into Workbench|
|Arguments||Locate and enter the executable application file (script) to pull data into Workbench|
|Output File Path||Specify what the file path is for the output file that the executable/script will generate.|
|Direct Upload||Specify whether Workbench should or should not directly upload your output file to Domo.
All you need to use this option is the knowledge to build an executable file and because they are so highly configurable, your capabilities with this option are limitless. Below are just a few use cases of what can be done using the External Process File Provider.
Connect to an API when a pre-built connector doesn't exist.
Unencrypt and output encrypted data.
Pull data from Domo, perform a series of transformation, then upload back into Domo to bypass building a DataFlow.
Store passwords in an external file script and run them through this option to avoid storing passwords in Workbench.