{"id":10498,"date":"2016-09-08T10:28:45","date_gmt":"2016-09-08T14:28:45","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=10498"},"modified":"2020-07-24T14:49:19","modified_gmt":"2020-07-24T18:49:19","slug":"executing-batch-flows-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/","title":{"rendered":"Executing ETL &#038; Batch Flows"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat or .cmd, while Linux and Unix usually have .sh or no extension at all.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We could have a batch file with only a few commands, or one with many lines, some calling other programs (including other batch files). In <\/span><a href=\"http:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\">, a batch file will also run the blocks of a (<\/span><a href=\"http:\/\/www.iri.com\/solutions\/data-integration\/etl\"><span style=\"font-weight: 400;\">Voracity ETL<\/span><\/a><span style=\"font-weight: 400;\">) flow, like the one shown below. The steps for execution are the same for all batch files, and similar to those used to run a standalone CoSort or any other SortCL-based language <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/running-iri-jobs-in-the-iri-workbench\/\"><span style=\"font-weight: 400;\">job<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p>See <a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/running-iri-jobs-in-the-iri-workbench\/\">this article<\/a> for instructions specific to single job \/ task scripts created in IRI Workbench.<\/p>\n<h3><b>Flow into Your Batch File<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The final step in creating a Flow is to export it for execution. This process writes the steps necessary to execute each block of the Flow into a batch file. <\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Exporting-for-Execution.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10499\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Exporting-for-Execution.png\" alt=\"Exporting for execution\" width=\"600\" height=\"286\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Exporting-for-Execution.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/1-Exporting-for-Execution-300x143.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">If the batch file for your flow has not yet been created, then:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Right-click in the diagram for the flowlet<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>IRI Diagram Actions<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click<\/span><b> Export Flow Component<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>File name<\/b><span style=\"font-weight: 400;\"> field, type the name for the batch file<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the <\/span><b>Platform<\/b><span style=\"font-weight: 400;\"> from the drop-down. This selection determines whether a .bat or .sh file is created.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click <\/span><b>Finish.<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The batch file is created and placed in the project along with other files that are created as part of the flow.<\/span><b>\f<\/b><\/p>\n<h3><b>Command Line Options<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The .bat files run on Windows, and .sh files run on Linux and Unix. Your batch files ultimately run on the command line, within or outside the IRI Workbench, and on a local or remote (see Remote Execution below) computer. They can be moved to any compatible system as long as all the components needed for execution &#8212; including job scripts and executables &#8212; are there, too.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">These batch files can be a complete process or a component of a greater process. Execution can be accomplished by actually logging into the system independently, or from a shell user interface directly in Workbench to a command line prompt. These are available using <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/external-tools-for-iri-workbench\/\"><span style=\"font-weight: 400;\">ShelExec<\/span><\/a><span style=\"font-weight: 400;\">, Wicked Shell, or the <\/span><a href=\"http:\/\/help.eclipse.org\/kepler\/index.jsp?topic=%2Forg.eclipse.rse.doc.user%2Ftasks%2Ftruncmdsview.html\"><span style=\"font-weight: 400;\">Launch Shell<\/span><\/a><span style=\"font-weight: 400;\"> feature in the <\/span><b>Remote Systems<\/b><span style=\"font-weight: 400;\"> Explorer view.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Batch file executions can also be automated in the IRI Workbench <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/scheduling-jobs-in-iri-workbench\/\"><span style=\"font-weight: 400;\">task scheduler<\/span><\/a><span style=\"font-weight: 400;\">, or any external scheduler like cron, <\/span><a href=\"http:\/\/www.iri.com\/blog\/data-transformation2\/stonebranch-universal-controller-integration\/\"><span style=\"font-weight: 400;\">Stonebranch UAC<\/span><\/a><span style=\"font-weight: 400;\">, Autosys, or Grand Logic <\/span><a href=\"http:\/\/www.grandlogic.com\/content\/html_docs\/js_features.shtml#job_sched\"><span style=\"font-weight: 400;\">JobServer<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><b><br \/>\n<\/b><\/p>\n<h3><b>Local Execution Options<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">In the Workbench, batch files are considered a type of external tool. The menu for external tools is located on the main toolbar. Access it by clicking on the down arrow next to the white arrow in the green circle with the red toolbox.<\/span><\/p>\n<p><b>Option 1: Run As<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To use this option, you must first click on a batch file in the <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\"> or in the editor, then select <\/span><b>Run As<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>Batch Program. <\/b><span style=\"font-weight: 400;\">You can instead right-click to bring up a context menu where you can also select <\/span><b>Run As<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>Batch Program.<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Once the batch file is executed any output will be placed in any locations defined by the job and a definition of the job is recorded in <\/span><b>External Tools Configurations<\/b><span style=\"font-weight: 400;\">.<br \/>\n<\/span><b><br \/>\n<\/b><b>Option 2: <\/b><b>External Tools Configuration<\/b><\/p>\n<p><span style=\"font-weight: 400;\">You can also configure, run, and schedule batch files (including the ones that represent flows) \u00a0using the Eclipse <\/span><b>External Tools Configurations <\/b><span style=\"font-weight: 400;\">option. This is an opportunity to save specific runtime parameters for your batch files, and select previously defined batch files to run.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Note the <\/span><b>External Tools Configuration<\/b><span style=\"font-weight: 400;\"> option is different from the <\/span><b>Run Configurations<\/b><span style=\"font-weight: 400;\"> option available for parameterized <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/running-iri-jobs-in-the-iri-workbench\/\"><span style=\"font-weight: 400;\">individual job executions<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When you execute a batch file, the information to run the job is recorded in <\/span><b>External Tools Configurations<\/b><span style=\"font-weight: 400;\">. In that window, the panel on the left has a tree. Under the tree\u2019s <\/span><b>Program <\/b><span style=\"font-weight: 400;\">item, are the names used for running batch files and possibly for other utilities. The information necessary to execute the batch file is recorded in the right panel. Usually the only information needed is on the <\/span><b>Main <\/b><span style=\"font-weight: 400;\">tab. Click on a name in the tree, then click <\/span><b>Run<\/b><span style=\"font-weight: 400;\"> to execute it.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The items in the <\/span><b>Program <\/b><span style=\"font-weight: 400;\">list are also listed in the top portion of the menu that displays when you select the run menu for External Tools from the main menu bar. Each is preceded with the icon that is an arrow with a green circle and a red toolbox. Additionally, as a shortcut, you can click on a batch file in either the <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\"> or in the editor. Then on the menu bar, click on the circled arrow with the toolbox to execute the batch job.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">See <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/scheduling-jobs-in-iri-workbench\/\"><span style=\"font-weight: 400;\">this article<\/span><\/a><span style=\"font-weight: 400;\"> on using the built-in task scheduler to automate the execution of these jobs.<br \/>\n<\/span><b><br \/>\n<\/b><b>Example<\/b><b><br \/>\n<\/b><\/p>\n<p><span style=\"font-weight: 400;\">In the window shown below, the batch file called MonthEnd.bat is highlighted in the tree. In the panel on the right, the <\/span><b>Name<\/b><span style=\"font-weight: 400;\"> shows the name of the batch file by default, but you can change it to something more descriptive about the configuration.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the <\/span><b>Main <\/b><span style=\"font-weight: 400;\">tab, the <\/span><b>Location<\/b><span style=\"font-weight: 400;\"> field has the value ${workspace_loc:\/MonthEnd\/MonthEnd.bat} \u00a0to provide the absolute path and name for the batch file.The <\/span><b>Working Directory<\/b><span style=\"font-weight: 400;\"> ${workspace_loc:\/MonthEnd} has the absolute path to the batch file. In this case, it is to the path to the project directory MonthEnd<\/span><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10502\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\" alt=\"Create, manage, and run configurations\" width=\"600\" height=\"497\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations-300x249.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<h3><b>Remote Execution<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">You can also execute batch files on a remote system from within <\/span><b>IRI Workbench<\/b><span style=\"font-weight: 400;\"> using <\/span><b>Ssh Terminals<\/b><span style=\"font-weight: 400;\"> in the <\/span><b>Remote Systems<\/b><span style=\"font-weight: 400;\"> view. See <\/span><a href=\"http:\/\/www.iri.com\/blog\/iri\/iri-workbench\/creating-a-remote-connection-for-executing-remote-job-scripts\/\"><span style=\"font-weight: 400;\">this demonstration<\/span><\/a><span style=\"font-weight: 400;\"> on setting up a remote system connection, and remote project that appears in the local <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\"> view.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Create the batch script in a local project, and then copy it into a remote project folder. In this case, we built <\/span><i><span style=\"font-weight: 400;\">SortChiefs.sh<\/span><\/i><span style=\"font-weight: 400;\"> and copied it into the remote project folder called <\/span><i><span style=\"font-weight: 400;\">Force5Project1<\/span><\/i><span style=\"font-weight: 400;\">, which is a directory on the remote system named <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">. To run this batch script on <\/span><i><span style=\"font-weight: 400;\">force5 <\/span><\/i><span style=\"font-weight: 400;\">from the command line, we will use the <\/span><b>Ssh Terminals<\/b><span style=\"font-weight: 400;\"> option that was created for <\/span><i><span style=\"font-weight: 400;\">force5 <\/span><\/i><span style=\"font-weight: 400;\">when we established that connection.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Right-click on <\/span><b>Ssh Terminals<\/b><span style=\"font-weight: 400;\"> for <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">, then click <\/span><b>Launch Terminal<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A tab for <\/span><i><span style=\"font-weight: 400;\">force5 <\/span><\/i><span style=\"font-weight: 400;\">will appear in the <\/span><b>Terminals<\/b><span style=\"font-weight: 400;\"> view where you will be logged using the access details provided during the remote project setup. If you want, you can launch multiple <\/span><b>Ssh Terminals<\/b><span style=\"font-weight: 400;\"> to the same remote system, each with its own tab. They will be labelled <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">, f<\/span><i><span style=\"font-weight: 400;\">orce5 1<\/span><\/i><span style=\"font-weight: 400;\">,<\/span><i><span style=\"font-weight: 400;\"> force5 2<\/span><\/i><span style=\"font-weight: 400;\">, and so on for the system <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now that we are logged into <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">, we change to the directory where SortChiefs.sh resides. After running that batch script from the command line of an Ssh terminal for <\/span><i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">, any output written into that project directory will also appear in the corresponding project folder in the IRI Workbench <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\"> view.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the window shown below, the batch file SortChiefs.sh is displayed in the editor. Listed under the <\/span><b>Remote Systems<\/b><span style=\"font-weight: 400;\"> view are <\/span><b>Ssh Terminals<\/b> <i><span style=\"font-weight: 400;\">force5<\/span><\/i><span style=\"font-weight: 400;\">, <\/span><i><span style=\"font-weight: 400;\">force5 1<\/span><\/i><span style=\"font-weight: 400;\">, and <\/span><i><span style=\"font-weight: 400;\">force5 2<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the <\/span><b>Terminals<\/b><span style=\"font-weight: 400;\"> view are the tabs where we are logged into each terminal. The <\/span><i><span style=\"font-weight: 400;\">force5 2<\/span><\/i><span style=\"font-weight: 400;\"> tab shows the two commands we entered to run our batch job:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">cd RemoteProjects\/Force5Project1\r\n<\/span><span style=\"font-weight: 400;\">sh SortChiefs.sh<\/span><\/pre>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Terminals-view.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10503\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Terminals-view.png\" alt=\"Terminals view\" width=\"600\" height=\"396\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Terminals-view.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/3-Terminals-view-300x198.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">The two files <\/span><i><span style=\"font-weight: 400;\">chiefs.out<\/span><\/i><span style=\"font-weight: 400;\"> and <\/span><i><span style=\"font-weight: 400;\">SortChiefs.log<\/span><\/i><span style=\"font-weight: 400;\"> were created as a result of running the batch file, and are now in the <\/span><b>Project Explorer<\/b><span style=\"font-weight: 400;\"> in the remote project <\/span><i><span style=\"font-weight: 400;\">Force5Project1<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you need help creating or running batch flows in the IRI Workbench, contact <\/span><a href=\"mailto:voracity@iri.com\"><span style=\"font-weight: 400;\">voracity@iri.com<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat or .cmd, while Linux and Unix usually have .sh or no extension at all. We could have a batch file with<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\" title=\"Executing ETL &#038; Batch Flows\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":10502,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[776,91],"tags":[1171,1168,1169,44,100,1172,789,850,1160,160,1150,68,1170,80,161],"class_list":["post-10498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-etl","category-iri-workbench","tag-autosys","tag-batch-file","tag-batch-flow","tag-cosort","tag-etl","tag-grand-logic","tag-iri-voracity","tag-iri-workbench","tag-launch-shell","tag-linux","tag-shelexec","tag-sortcl","tag-stonebranch-uac","tag-unix","tag-windows"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Executing ETL &amp; Batch Flows - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Executing ETL &amp; Batch Flows\" \/>\n<meta property=\"og:description\" content=\"Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat or .cmd, while Linux and Unix usually have .sh or no extension at all. We could have a batch file withRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-08T14:28:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-24T18:49:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\" \/>\n\t<meta property=\"og:image:width\" content=\"624\" \/>\n\t<meta property=\"og:image:height\" content=\"517\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"Executing ETL &#038; Batch Flows\",\"datePublished\":\"2016-09-08T14:28:45+00:00\",\"dateModified\":\"2020-07-24T18:49:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\"},\"wordCount\":1234,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\",\"keywords\":[\"Autosys\",\"batch file\",\"batch flow\",\"CoSort\",\"ETL\",\"Grand Logic\",\"IRI Voracity\",\"IRI Workbench\",\"Launch Shell\",\"Linux\",\"ShelExec\",\"SortCL\",\"Stonebranch UAC\",\"Unix\",\"Windows\"],\"articleSection\":[\"ETL\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\",\"name\":\"Executing ETL & Batch Flows - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\",\"datePublished\":\"2016-09-08T14:28:45+00:00\",\"dateModified\":\"2020-07-24T18:49:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png\",\"width\":624,\"height\":517,\"caption\":\"Create, manage, and run configurations\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Executing ETL &#038; Batch Flows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Executing ETL & Batch Flows - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"Executing ETL & Batch Flows","og_description":"Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat or .cmd, while Linux and Unix usually have .sh or no extension at all. We could have a batch file withRead More","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2016-09-08T14:28:45+00:00","article_modified_time":"2020-07-24T18:49:19+00:00","og_image":[{"width":624,"height":517,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"Executing ETL &#038; Batch Flows","datePublished":"2016-09-08T14:28:45+00:00","dateModified":"2020-07-24T18:49:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/"},"wordCount":1234,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","keywords":["Autosys","batch file","batch flow","CoSort","ETL","Grand Logic","IRI Voracity","IRI Workbench","Launch Shell","Linux","ShelExec","SortCL","Stonebranch UAC","Unix","Windows"],"articleSection":["ETL","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/","name":"Executing ETL & Batch Flows - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","datePublished":"2016-09-08T14:28:45+00:00","dateModified":"2020-07-24T18:49:19+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","width":624,"height":517,"caption":"Create, manage, and run configurations"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/executing-batch-flows-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Executing ETL &#038; Batch Flows"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2016\/09\/2-Create-manage-and-run-configurations.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10498"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=10498"}],"version-history":[{"count":7,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10498\/revisions"}],"predecessor-version":[{"id":13955,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/10498\/revisions\/13955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/10502"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=10498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=10498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=10498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}