OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
docroot
/
help
/
help_etl
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
08/14/2022 11:08:45 AM
rwxr-xr-x
📄
AbouttheETLTab.html
5.88 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
AccessLog.html
5.21 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
AdministratorResponsibilities.html
3.92 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
CUBOT 9.0 ETL ADMIN GUIDE.html
1.04 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
CUBOTMenu.html
6.93 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
CUBOTataGlance.html
3.63 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
CopyrightandTrademarkInformation.html
4.11 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
CubotLog.html
5.23 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
ETLLog.html
9.25 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
ElementsofCUBOTScreens.html
2.38 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
ErrorLog.html
5.67 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
GettingStarted.html
21.97 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
HowToAddaLog.html
4.98 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowToCreateaDataTemplate.html
13.29 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowToDeleteaDataTemplate.html
3.99 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowToEditDetailsofaProcess.html
4.68 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowToEdittheDataTemplateDetails.html
5.66 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowToViewDetailsofaProcess.html
13.5 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowToViewDetailsofaWorkflowSched.html
12.36 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowToViewandExportData.html
3.39 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddColumnstoaDataTemplate.html
3.31 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaDatabase.html
13.37 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddaDirectory.html
15.34 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaMdbFile.html
3.48 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaNewMaskSourceTable.html
10.84 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoAddaNewProcess.html
4.37 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoAddaNewRepository.html
5.21 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoAddaNewStore.html
8.63 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoAddaNewWorkflow.html
8.74 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoAddaSalesforceStore.html
6.19 KB
08/14/2022 11:09:06 AM
rw-r--r--
📄
HowtoAddaTask.html
5.52 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddaXMLFile.html
3.63 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAddanETLTask.html
5.23 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoAddanExcelFile.html
3.48 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoAnalyzeaSQLQuery.html
5.27 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoAnalyzeaTable.html
5.91 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDefineaNewCommandTask.html
4.68 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDefineaNewSQLQuery.html
4.74 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDefineaNewTasktoaWorkflow.html
3.66 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaLog.html
4.18 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDeleteaProcess.html
3.98 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoDeleteaProcessSchedule.html
4.83 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaRepository.html
4.79 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoDeleteaStore.html
4.78 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaTask.html
4.18 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoDeleteaTask1.html
4.56 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaWorkflow.html
4.46 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoDeleteaWorkflowSchedule.html
4.82 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoDeleteaWorkflowTask.html
4.61 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoEditDetailsofaLog.html
3.45 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoEditDetailsofaWorkflow.html
4.14 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEditDetailsofaWorkflowSched.html
5.48 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoEditMaskDetails.html
4.67 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEditSearchDetails.html
6.58 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoEditStoreDetails.html
3.58 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoEdittheDetailsofaProcessSch.html
5.72 KB
08/14/2022 11:09:07 AM
rw-r--r--
📄
HowtoEdittheRecordsinaMasterTabl.html
10.43 KB
08/14/2022 11:08:47 AM
rw-r--r--
📄
HowtoEdittheRepositoryDetails.html
4.42 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoGrantAccessPermissions.html
6.52 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoImportaTable.html
4.08 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoInsertNewRecordstoaMasterTa.html
6.74 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
HowtoLinkaWorkflowtoAnotherWorkf.html
5.83 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoLogontoCUBOT.html
3.41 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
HowtoManagetheTasks.html
13.84 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoMoveaTask.html
3.54 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoMoveaTaskBetweenWorkflows.html
3.7 KB
08/14/2022 11:09:10 AM
rw-r--r--
📄
HowtoReorderaTask.html
3.52 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoReorderaWorkflowTask.html
3.57 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoScheduleaProcess.html
5.87 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoScheduleaWorkflow.html
5.64 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoSelectaDestinationTableScre.html
10.68 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoSetPrimaryKeyOptiontoaField.html
7.59 KB
08/14/2022 11:09:14 AM
rw-r--r--
📄
HowtoViewDatainaTable.html
9.4 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoViewDetailsofaTask.html
10.37 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoViewDetailsofaWorkflow.html
9.71 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
HowtoViewtheCheckList.html
4.51 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
HowtoWorkwiththeExtractScreen.html
9.41 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
HowtoWorkwiththeTransformationSc.html
10.84 KB
08/14/2022 11:09:12 AM
rw-r--r--
📄
TypesofCUBOTLogs.html
5.42 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
UserInformation.html
5.71 KB
08/14/2022 11:09:09 AM
rw-r--r--
📄
WhyyoushouldSignOutofCUBOT.html
3.1 KB
08/14/2022 11:08:46 AM
rw-r--r--
📄
WorkingwiththeADMINMODETab.html
2.73 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththeConfigureTab.html
3.39 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththeDBMANAGERTab.html
4.83 KB
08/14/2022 11:08:59 AM
rw-r--r--
📄
WorkingwiththeETLTab.html
8.08 KB
08/14/2022 11:09:11 AM
rw-r--r--
📄
WorkingwiththeLogsTab.html
5.94 KB
08/14/2022 11:09:12 AM
rw-r--r--
📄
WorkingwiththeProcessTab.html
7.88 KB
08/14/2022 11:09:08 AM
rw-r--r--
📄
WorkingwiththeWorkflowTab.html
4.47 KB
08/14/2022 11:09:07 AM
rw-r--r--
📁
css
-
08/14/2022 11:08:59 AM
rwxr-xr-x
📁
img
-
08/14/2022 11:09:07 AM
rwxr-xr-x
📁
js
-
08/14/2022 11:09:14 AM
rwxr-xr-x
📁
lib
-
08/14/2022 11:08:59 AM
rwxr-xr-x
📄
toc.html
44.18 KB
08/14/2022 11:08:45 AM
rw-r--r--
Editing: ETLLog.html
Close
<html> <head> <title>ETL Log</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="generator" content="HelpNDoc Standard Edition 3.6.0.345"> <link type="text/css" rel="stylesheet" media="all" href="css/reset.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/base.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/hnd.css" /> <!--[if lte IE 8]> <link type="text/css" rel="stylesheet" media="all" href="css/ielte8.css" /> <![endif]--> <style type="text/css"> #topic_header { background-color: #EFEFEF; } </style> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/hnd.js"></script> <script type="text/javascript"> if (top.frames.length == 0) { var sTopicUrl = top.location.href.substring(top.location.href.lastIndexOf("/") + 1, top.location.href.length); top.location.href = "CUBOT 9.0 ETL ADMIN GUIDE.html?" + sTopicUrl; } else if (top && top.FrameTOC && top.FrameTOC.SelectTocItem) { top.FrameTOC.SelectTocItem("ETLLog"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>ETL Log</h1> <div id="topic_breadcrumb"> <a href="WorkingwiththeLogsTab.html">Working with the Logs Tab</a> ›› <a href="TypesofCUBOTLogs.html">Types of CUBOT Logs</a> ›› </div> </div> <div id="topic_header_nav"> <a href="TypesofCUBOTLogs.html"><img src="img/arrow_up.png" alt="Parent"/></a> <a href="TypesofCUBOTLogs.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="CubotLog.html"><img src="img/arrow_right.png" alt="Next"/></a> </div> <div class="clear"></div> </div> <div id="topic_content"> <p class="rvps9"><span class="rvts14">ETL Log</span></p> <p class="rvps3"><span class="rvts7">The ETL Log screen provides details of the executed workflows. This includes the name and status of the workflow, start and end time, and the time taken to run the workflow. You can view the details of ETL log in the ETL Log screen. To reach this screen, move to the left pane of the Logs screen and click the </span><span class="rvts9">ETL Log </span><span class="rvts7">link. The ETL Log screen is displayed.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/ETL Log Screen.png"/></p> <p class="rvps6"><span class="rvts9">ETL Log Screen</span></p> <p class="rvps3"><span class="rvts7">The following table describes what is displayed when you click different elements in the ETL Log screen.</span></p> <p class="rvps43"><span class="rvts9">Elements in the ETL Log screen</span></p> <div class="rvps25"><table width="600" border="1" cellpadding="4" cellspacing="-1" style="border-width: 0px; border-collapse: collapse;"> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 165px;"><p class="rvps25"><span class="rvts30">Click</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 415px;"><p class="rvps25"><span class="rvts30">To</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps25"><img alt="" style="padding : 1px;" src="lib/Expand icon.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><p class="rvps25"><span class="rvts24">View the tasks in the corresponding workflow. See figure, </span><a class="rvts39" href="ETLLog.html#Tasks in a Workflow">Tasks in a Workflow</a><span class="rvts24">.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps25"><span class="rvts24">Link in the Workflow Name column</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><p class="rvps25"><span class="rvts24">Display the ETL log of the corresponding workflow. It is also used to search a string in the lines that are displayed. See figure, </span><a class="rvts39" href="ETLLog.html#Workflow ETL Log">Workflow ETL Log</a><span class="rvts24">. </span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps20"><img alt="" style="padding : 1px;" src="lib/next page icon.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><p class="rvps20"><span class="rvts24">View the next page.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps20"><img width="23" height="24" alt="" style="padding : 1px;" src="lib/previous page icon.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><p class="rvps20"><span class="rvts24">View the previous page. This icon is only visible from the second page onwards.</span></p> </td> </tr> </table> </div> <p class="rvps3"><span class="rvts7">The following figure shows the tasks in a workflow.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Tasks in a Workflow.png"/></p> <p class="rvps6"><a name="Tasks in a Workflow"></a> <span class="rvts9">Tasks in a Workflow</span><span class="rvts7"> </span></p> <p class="rvps26"><span class="rvts33">View ETL Log of a Workflow</span></p> <p class="rvps3"><span class="rvts7">To view the ETL log of a particular workflow, click on the link in the Workflow Name column in the ETL Log screen. For example, when you want to view the ETL Log for the workflow named WF_ PolicyData, move to the Workflow Name column in ETL Log screen. Click the </span><span class="rvts9">WF_ PolicyData</span><span class="rvts7"> link. A screen similar to the following figure is displayed.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/ETL Log for workflow screen.png"/></p> <p class="rvps6"><a name="Workflow ETL Log"></a> <span class="rvts9">Workflow ETL Log</span></p> <p class="rvps3"><span class="rvts7">The following table describes the different actions that you can perform in the Workflow ETL Log screen.</span></p> <p class="rvps43"><span class="rvts9">Actions in the Workflow ETL Log screen</span></p> <div class="rvps25"><table width="600" border="1" cellpadding="4" cellspacing="-1" style="border-width: 0px; border-collapse: collapse;"> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 165px;"><p class="rvps25"><span class="rvts30">To</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 415px;"><p class="rvps25"><span class="rvts30">Action</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps25"><span class="rvts6">Search n number of lines of the ETL log for a workflow</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><ol style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"> <li class="rvps3"><span class="rvts7"> In the </span><span class="rvts9">No of lines</span><span class="rvts7"> text box, type the number of lines that you want to search.</span></li> <li class="rvps3"><span class="rvts7">Click </span><span class="rvts9">Submit</span><span class="rvts7"> to search the string. The lines are displayed below.</span></li> </ol> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps25"><span class="rvts6">Search a string in the ETL log for a workflow</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><ol style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"> <li class="rvps3"><span class="rvts7"> In the </span><span class="rvts9">Search</span><span class="rvts7"> text box, type the characters that you want to search.</span></li> <li class="rvps3"><span class="rvts7">Click </span><span class="rvts9">Submit</span><span class="rvts7"> to search the string. The lines with the search string are highlighted.</span></li> </ol> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 165px;"><p class="rvps20"><img alt="" style="padding : 1px;" src="lib/close icon in ETL log.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 415px;"><p class="rvps20"><span class="rvts24">To close the ETL log for a workflow.</span></p> </td> </tr> </table> </div> </div> <div id="topic_footer"> <div id="topic_footer_content"> Copyright © 2013 Robust Designs India Private Ltd. All Rights Reserved.</div> </div> </body> </html>