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: HowToCreateaDataTemplate.html
Close
<html> <head> <title>How To Create a Data Template</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("HowToCreateaDataTemplate"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>How To Create a Data Template</h1> <div id="topic_breadcrumb"> <a href="WorkingwiththeDBMANAGERTab.html">Working with the DBMANAGER Tab</a> ›› </div> </div> <div id="topic_header_nav"> <a href="WorkingwiththeDBMANAGERTab.html"><img src="img/arrow_up.png" alt="Parent"/></a> <a href="WorkingwiththeDBMANAGERTab.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="HowToEdittheDataTemplateDetails.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">How To Create a Data Template</span></p> <p class="rvps3"><span class="rvts7">Some users may need to manually update records in a selected table. A data template is used for the same. A data template is a set of rules and actions. You can map multiple templates to a single set of data. </span></p> <p class="rvps3"><span class="rvts7">To create a data template, do the following:</span></p> <p class="rvps13"><span class="rvts7">1. In the ETL menu, click </span><span class="rvts9">DBMANGER</span><span class="rvts7">. The DBMANAGER screen is displayed.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Configure DBMANAGER scren.png"/></p> <p class="rvps6"><span class="rvts9">DBMANAGER Screen</span></p> <p class="rvps13"><span class="rvts7">2. Click </span><span class="rvts9">Add New Task</span><span class="rvts7">.</span></p> <p class="rvps13"><span class="rvts7">3. From the </span><span class="rvts9">Tables In Database</span><span class="rvts7"> drop-down list, select a table.</span></p> <p class="rvps13"><span class="rvts7">4. Click </span><span class="rvts9">Configure</span><span class="rvts7">. The Configuration for table: <table name> is displayed.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Configuration for table.png"/></p> <p class="rvps6"><a name="Configuration for table: <table name> Screen"></a> <span class="rvts9">Configuration for table: <table name> Screen</span></p> <p class="rvps13"><span class="rvts7">5. In the </span><span class="rvts9">Data Template</span><span class="rvts7"> text box, type name of the data template.</span></p> <p class="rvps13"><span class="rvts7">6. Select the check box beside </span><span class="rvts9">Operation Allowed</span><span class="rvts7"> to select the type of operation. </span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Select </span><span class="rvts9">Insert Operation</span><span class="rvts7"> check box to allow the user to add an item.</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Select</span><span class="rvts9"> Update Operation</span><span class="rvts7"> check box to allow the user to modify an item.</span></li> </ul></ul></ul> <p class="rvps12"><span class="rvts7"> </span><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts17"> </span><span class="rvts7">Only when you select the </span><span class="rvts9">Insert Operation</span><span class="rvts7"> check box, the </span><span class="rvts9">Insert</span><span class="rvts7"> link is displayed on the left pane of the DBMANGER screen.</span></p> <p class="rvps12"><span class="rvts7"> </span><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts17"> </span><span class="rvts7">Only when you select the </span><span class="rvts9">Update Operation</span><span class="rvts7"> check box, the </span><span class="rvts9">Update</span><span class="rvts7"> link is displayed on the left pane of the DBMANGER screen.</span></p> <p class="rvps13"><span class="rvts7">7. Select the check box next to the column name that you want to select.</span></p> <p class="rvps13"><span class="rvts7">8. You can now:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps44" style="margin-left: 0; text-indent: 0px"><span class="rvts7">Select the radio button beside </span><span class="rvts9">Update all join tables</span><span class="rvts7"> to update the tables that are joined to the selected table.</span></li> </ul></ul></ul> <p class="rvps45"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps44" style="margin-left: 0; text-indent: 0px"><span class="rvts7">Select the radio button beside </span><span class="rvts9">Do not modify join tables</span><span class="rvts7"> to restrict any updates in the table joins.</span></li> </ul></ul></ul> <p class="rvps13"><span class="rvts7">9. You can now:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Next</span><span class="rvts7">. The Configuration for data Template: <data template name> screen is displayed.</span></li> </ul></ul></ul> <p class="rvps30"><span class="rvts7"> For more details, see </span><a class="rvts11" href="HowToCreateaDataTemplate.html#Configure a Data Template">Configure a Data Template</a><span class="rvts7">.</span></p> <p class="rvps31"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Cancel</span><span class="rvts7"> to undo the changes made</span></li> </ul></ul></ul> <p class="rvps26"><a name="Configure a Data Template"></a> <span class="rvts33">Configure a Data Template</span></p> <p class="rvps3"><span class="rvts7">You can configure a data template in the Configuration for data Template: <data template name> screen. In the Configuration for data Template: <data template name> screen, you can select the columns that you need to manage in the data template. To reach this screen, click </span><span class="rvts9">Next</span><span class="rvts7"> in the Configuration for table: <table name>. The Configuration for data Template: <data template name> screen is displayed.</span></p> <p class="rvps15"><img alt="" style="padding : 1px;" src="lib/Configuration for data template data templa.png"/></p> <p class="rvps16"><span class="rvts23">Configuration for data template: <data template name> Screen</span></p> <p class="rvps3"><span class="rvts7"> In the Configuration for data template: <data template name> screen, do the following:</span></p> <p class="rvps13"><span class="rvts7">1. Select the </span><span class="rvts9">Search</span><span class="rvts7"> check box in the row of the Column Name that you want to manage in the</span></p> <p class="rvps13"><span class="rvts7"> data template.</span></p> <p class="rvps13"><span class="rvts7">2. From the </span><span class="rvts9">Search Type</span><span class="rvts7"> drop-down list, select the type of the search. The options available are:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts9">Text box</span><span class="rvts7">: To use a text box to type the data values.</span><span class="rvts9"> </span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts9">Combo box</span><span class="rvts7">: To use a combo box to select from the list of data values. </span></li> </ul></ul></ul> <p class="rvps13"><span class="rvts7">3. From the </span><span class="rvts9">Operator</span><span class="rvts7"> drop-down list, select the type of the operator.</span></p> <p class="rvps13"><span class="rvts7">4. In the </span><span class="rvts9">Display as</span><span class="rvts7"> text box, type the value that is to be displayed.</span></p> <p class="rvps13"><span class="rvts7">5. You can now:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Apply</span><span class="rvts7">. The created data template is added in the left pane of the DBMANAGER screen.</span></li> </ul></ul></ul> <p class="rvps31"><span class="rvts7">The Search screen for DBMANGER is displayed.</span></p> <p class="rvps31"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Cancel</span><span class="rvts7"> to undo the changes made.</span></li> </ul></ul></ul> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/update screen for records.png"/></p> <p class="rvps6"><span class="rvts9">Search Screen for DBMANAGER</span></p> <p class="rvps3"><span class="rvts7">In the Search screen for DBMANGER,</span></p> <p class="rvps13"><span class="rvts7">6. Select the check box beside the column name that needs to be displayed in the Result screen</span></p> <p class="rvps13"><span class="rvts7"> for DBMANAGER.</span></p> <p class="rvps13"><span class="rvts7">7. In the Search section, fill the details for the search criteria. The items in the Search section</span></p> <p class="rvps13"><span class="rvts7"> depends on the selected columns in the Configuration for data template: <data template name> screen.</span></p> <p class="rvps13"><span class="rvts7">8. You can now:</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Result</span><span class="rvts7">. The Result screen for DBMANGER is displayed.</span></li> </ul></ul></ul> <p class="rvps31"><span class="rvts7">Or</span></p> <ul style="text-indent: 0px; margin-left: 24px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"><ul style="text-indent: 0px; margin-left: 48px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">Click </span><span class="rvts9">Cancel</span><span class="rvts7"> to undo the changes made.</span></li> </ul></ul></ul> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Result Screen for DBMANAGER.png"/></p> <p class="rvps6"><span class="rvts9">Result Screen</span><span class="rvts7"> </span><span class="rvts9">for DBMANAGER</span></p> </div> <div id="topic_footer"> <div id="topic_footer_content"> Copyright © 2013 Robust Designs India Private Ltd. All Rights Reserved.</div> </div> </body> </html>