https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/ Recent content in Pages on Syniti Documentation Hugo -- gohugo.io en-us https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Advanced_View_Builder_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Advanced_View_Builder_H/ Advanced View Builder H Advanced View Builder V Use this page to Build Advanced Views and Create Collect Target Views for dspConduct™. To access this page, select Collect > Tools > Advanced View Builder in Navigationpane. Field Description Build View Click to create views in the database listed in the Database for View field. Views have the same name as the tables provided in the database listed in the Database for Tables field. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Bulk_Table_Schedule_Update/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Bulk_Table_Schedule_Update/ Bulk Table Schedule Update Use this page to: Clear All Schedules Update All Schedules To access this page, select Collect > Tools > Bulk Table Schedule Updatein Navigationpane. Field Description Schedule Target Displays target database where the schedule entries are cleared or updated. Schedule Source Displays source database where the schedule entries are cleared or updated. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Column_Table_List_in_Source_Target/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Column_Table_List_in_Source_Target/ Column Table List in Source Target Use this page to view the Column Table List in Source Target report. To access this page: Select Collect > Reportsin the Navigationpane. Click Column Table List in Source Targeton the Reports page. Field Description COLUMN Displays the column Collect found in the source database that matches the data type conversion being accepted. This is the table name that will be in the target database. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Connection_Type_Data_Conversion_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Connection_Type_Data_Conversion_H/ Connection Type Data Conversion H Connection Type Data Conversion V Use this page to Set Up Connection Types. To access this page: Select Collect > Administrative > Connection Typesin Navigation pane. Click Sourcesfor SQL SERVER Target Connection Type. Click Data Type Conversions. Connection Type Data Conversion V Connection Type Data Conversion H Use this page to Set Up Connection Types. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Connection_Types_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Connection_Types_H/ Connection Types H Connection Types V Use this page to Set Up Connection Types. To access this page, select Collect > Administrative > Connection Typesin Navigationpane. Field Description TARGET CONNECTION TYPE Displays the database connection type for the target. OLE PROVIDER Displays name of OLE settings. ODBC DRIVER Displays name of driver used in the Windows ODBC setup for the DSN. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Copy_Targets/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Copy_Targets/ Copy Targets Use this page to Copy a Target. To access this page, select Collect > Tools > Copy Targetsin the Navigationpane. Field Description Target From Displays a target database where sources (including all tables, rules and indices) are currently configured. Target To Displays a target database where sources (including all tables, rules and indices) are to be copied. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Daily_Summary_Metrics/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Daily_Summary_Metrics/ Daily Summary Metrics Use this page to view the Daily Summary Metrics report. To access this page: Select Collect > Reportsin the Navigationpane. Click Daily Summary Metricson the Reports page. Field Description DAY Displays the date of the snapshot metrics, for example, 2014-05-26. EVENT Displays if the job was completed or failed. TOTAL DOWNLOADS Displays the total count of completed or failed records TOTAL RUN TIME (MINUTES) Displays the total duration (in minutes) to download the records. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Table_Columns_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Table_Columns_H/ Data Source Table Columns H Data Source Table Columns V Use this page to Modify Configuration of Data Source Table Columns. To access this page: Click Collect > Targetsin the Navigation pane. Click Sourcesfor a target. Click Schedule Groupsfor a source. Click Tablesfor a schedule group. Click Vertical Viewfor a table. Click General Informationtab. Click View Design. Click Column Countfor a data source table. Data Source Table Columns V Data Source Table Columns H https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Table_Create_Download_SQL_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Table_Create_Download_SQL_H/ Data Source Table Create Download SQL H Data Source Table Create Download SQL V Use this page to View Configuration of Data Source Table SQL Commands. To access this page: Click Collect > Targetson Navigationpane. Click Sourcesfor a target. Click Schedule Groupsfor a source. Click Tablesfor a schedule group. Click Vertical Viewfor a table. Click General Informationtab. Click View Design. ClickSQL Commandfor a data source table. Data Source Table Create Download SQL V Data Source Table Create Download SQL H https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Tables_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Data_Source_Tables_H/ Data Source Tables H Data Source Tables V Use this page to Modify Configuration of Data Source Tables. To access this page: Click Collect > Targetsin the Navigationpane. Click Sourcesfor a target. Click Schedule Groupsfor a source. Click Tablesfor a schedule group. Click Vertical Viewfor a table. Click General Informationtab. Click View Design. Field Description TABLE Displays table in source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/DBMoto_Table_Rules/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/DBMoto_Table_Rules/ DBMoto Table Rules Use this page to Manage DBMoto® Table Rules. To access this page, select Collect > Administrative > DBMoto Table Rulesin Navigationpane. Field Description TABLE Displays table in the source. COLUMN Displays column name to include in the rule. DB MOTO FUNCTION Displays function applied to the rule. ACTIVE If enabled, table is included in Build Package process when creating a DBMoto® package. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Detail_List_of_Metrics/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Detail_List_of_Metrics/ Detail List of Metrics Use this page to view the Detail List of Metrics report. To access this page: Select Collect > Reportsin the Navigationpane. Click Detail List of Metricson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Duration_Warning_List/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Duration_Warning_List/ Duration Warning List Use this page to view the Duration Warning List report. To access this page: Select Collect > Reportsin the Navigationpane. Click Duration Warning Liston the Reports page. Field Description DURATION TIME Displays the amount of time (in seconds) the table took to download from the source. TARGET Displays the database target where the tables are refreshed with source data. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Error_List_in_Metrics/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Error_List_in_Metrics/ Error List in Metrics Use this page to view the Error List in Metrics report. To access this page: Select Collect > Reportsin the Navigationpane. Click Error List in Metricson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Group_Import/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Group_Import/ Group Import Use this page to Import System Type Group Tables. To access this page: Click Collect > Targetson Navigationpane. Click Sourcesicon for a target. Select a source. Click Import Group Tableson the Page toolbar. Field Description System Type Group ID Displays a System Type group, a logical grouping of tables such as Customer or Vendor, to import as a source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Job_Detail_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Job_Detail_H/ Job Detail H Job Detail V Use this page to View Summary. To access this page: Select Collect > Summaryon Navigationpane. Click Records. Field Description MONITOR ID Displays the unique identifier for monitoring record. STATUS Displays current status of the monitored job. MESSAGE Displays message returned when the job completed. TARGET Displays target database (where tables are refreshed with source data) impacted by the job. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Job_Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Job_Summary/ Job Summary Use this page to View Summary. To access this page, select Collect > Summary on Navigationpane. Field Description STATUS Displays current status of the job. Records Click to open the Job Detailpage to view job records associated with the status. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Monitor_Downloads_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Monitor_Downloads_H/ Monitor (Downloads) H Monitor (Downloads) V Use this page to: Monitor table refresh activity View Summary To access this page: SelectCollect > Summary > Target Summaryin the Navigation pane. Click the Refreshing Tableslink for the table that is currently being refreshed. Field Description JOB ID Displays the identifier associated with the job that refreshed the tables. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Next_Schedule_Run_Times/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Next_Schedule_Run_Times/ Next Schedule Run Times Use this page to view the Next Schedule Run Times report. To access this page: Select Collect > Reportsin the Navigationpane. Click Next Schedule Run Timeson the Reports page. Field Description NEXT SCHEDULE RUN DATE Displays the next date and time when the refresh process is scheduled to run for the reported table. TARGET Displays the database target where the tables are refreshed with source data. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Reports/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Reports/ Reports Use this page to access installed Collect reports. To access this page, select Collect > Reportsin the Navigationpane. Field Description PRIORITY Displays the priority in which the Collect reports are displayed. Report Displays the reports available in Collect. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Retention_Expiration_Email/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Retention_Expiration_Email/ Retention Expiration Email Use this page to Update the Retention Expiration Email. NOTE: This Collect page is accessed via Common. To access this page in Common: Select Configuration > Modules > Parameters – Collect in the Navigation pane. Click the Workflow Settings tab. Click the Retention Warning Email icon. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/SAP_Text_List_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/SAP_Text_List_H/ SAP Text List H SAP Text List V Use this page to Manage the SAP Text List. To access this page, select Collect > Administrative > SAP Text Listin Navigationpane. Field Description TABLE Displays name of the SAP Text table being managed. TEXT OBJECT Displays the object (TDOBJECT) for the SAP Text table. If blank, all objects are downloaded. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Schedule_Groups/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Schedule_Groups/ Schedule Groups Use this page to Set up Schedule Groups. To access this page, select Collect > Administrative > Schedule Groupsin Navigationpane. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Scheduled_Used_Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Scheduled_Used_Summary/ Scheduled Used Summary Use this page to view the Scheduled Used Summary report. To access this page: Select Collect > Reportsin the Navigationpane. Click Scheduled Used Summaryon the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. SOURCE SCHEDULE Displays the source schedule set at the target source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Schedules_in_Sources_and_Tables/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Schedules_in_Sources_and_Tables/ Schedules in Sources and Tables Use this page to view the Schedules in Sources and Tables report. To access this page: Select Collect > Reportsin the Navigationpane. Click Schedules in Sources and Tableson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Source_Connection_Status/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Source_Connection_Status/ Source Connection Status Use this page to view the Source Connection Status report. To access this page: Select Collect > Reportsin the Navigationpane. Click Source Connection Statuson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. TEST CONNECTION STATUS Displays the current status of the last test connection. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Source_Connection_Types_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Source_Connection_Types_H/ Source Connection Types H Source Connection Types V Use this page to Set up Connection Types. To access this page: Select Collect > Administrative > Connection Typesin Navigationpane. Click Sourcesfor a Target Connection Type of SQLSERVER. Source Connection Types V Source Connection Types H Use this page to Set up Connection Types. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Indices_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Indices_H/ Table (Indices) H Table (Indices) V Use this page to Create Indices for Tables. To access this page: Select Tableson the Navigationpane. Click the Indicesicon for a table. Field Description Build Index Click to schedule the rebuild process for all indices in the Target Source table index. Only keys stored in the table are rebuilt. INDEX ID Displays name of index. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rfc_Options/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rfc_Options/ Table (Rfc Options) Use this page to Configure RFC Options. To access this page: Click Collect > Tablesin Navigationpane. Click Vertical View for a table where the Package Type is BOA RFC using Options. Click Actiontab. Click Options. Field Description PRIORITY Displays sort order of fields. Default value is 10. FIELD Displays name of field where values are being filtered. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rule_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rule_H/ Table (Rule) H Table (Rule) V Use this page to Register Rules to Tables. To access this page: Click Collect > Targetsin Navigationpane. Click Sourcesfor target. Click Tablesfor source. Click Rulesfor table. Table (Rule) V Table (Rule) H Use this page to Register Rules to Tables. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Download_Task_List/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Download_Task_List/ Table Download Task List Use this page to Monitor Table Download Process. To access this page: Click Collect > Tablesin the Navigation pane. Build the download package for the table by either clicking Build and Refreshor Build Packageon the Page toolbar. Click Vertical Viewfor the table. Click General Informationtab. Click View Job Tasks. Field Description JOB ID Displays the unique identifier associated with the job that ran the package. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Errors_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Errors_H/ Table Errors H Table Errors V (All Tabs) Use this page to view when an error occurred with table downloads. To access this page: Select Summary > Target Summaryin the Navigation pane. Click the ERROR TABLESlink. Field Description TABLE Displays table where error exists. PACKAGE TYPE Displays package type (to refresh target table with source data) for erroneous table. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Index_Column_List_in_Source_and_Target/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Index_Column_List_in_Source_and_Target/ Table Index Column List in Source and Target Use this page to view the Table Index Column List in Source and Target report. To access this page: Select Collect > Reportsin the Navigationpane. Click List Index Column List in Source and Targeton the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Index_List_in_Source_and_Target/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Index_List_in_Source_and_Target/ Table Index List in Source and Target Use this page to view the Table Index List in Source and Target report. To access this page: Select Collect > Reportsin the Navigationpane. Click List Index List in Source and Targeton the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_List_in_Source_and_Target/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_List_in_Source_and_Target/ Table List in Source and Target Use this page to view the Table List in Source and Target report. To access this page: Select Collect > Reportsin the Navigationpane. Click List in Source and Targeton the Reports page. Field Description TABLE Displays the database target where the tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rule_List_in_Source_and_Target/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Table_Rule_List_in_Source_and_Target/ Table Rule List in Source and Target Use this page to view the Table Rule List in Source and Target report. To access this page: Select Collect > Reportsin the Navigationpane. Click List Rule List in Source and Targeton the Reports page. Field Description TABLE Displays the table name in the source database and target database. FIELDNAME Displays the name of the field that is impacted by the action. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Tables_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Tables_H/ Tables H Tables V (All Tabs) Use this page to: Set up Schedule Groups Manually Register Tables to Source Schedule Table Refresh Set up Download with CranPort Package Set up Download with ManualCranPort Package Download sdb Tables in Collect Download dgSAP Tables in Collect NOTE:Bulk Execution has been enabled on this page. Refer to Use Bulk Execution for more information. NOTE: To receive a workflow email that a table download has failed in Collect, a user must be assigned to a security role that has the Collect WebApp group WorkFlowFailureAll or WorkFlowFaiureByTargetAccess assigned. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Connection_Status/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Connection_Status/ Target Connection Status Use this page to view the Target Connection Status report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Connection Statuson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. TEST CONNECTION STATUS Displays the current status of the last test connection. TEST CONNECTION ON Displays the last date and time of the test connection. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Daily_Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Daily_Summary/ Target Daily Summary This chart displays the duration of time in seconds it took to refresh all active tables from all registered data sources into a target database for each day. Hover a cursor over a data point and the date, target name and number of seconds display .On this chart, a user can view daily fluctuations in duration of table refreshes that may be caused by changes in system resources, tables being added or deleted from the refresh, or other factors https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Monthly_Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Monthly_Summary/ Target Monthly Summary This chart displays the duration of time in seconds it took to refresh all active tables from all registered data sources for a target database for each month. On this chart, a user can view monthly fluctuations in duration of table refreshes that may be caused by changes in system resources, tables being added or deleted from the refresh, or other factors Hover a cursor over a data point and the month, target name and number of seconds display. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Record_Counts/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Record_Counts/ Target Record Counts Use this page to view the Target Source Table Counts report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Table Countson the Reports page. Field Description TARGET Displays the database target where the tables are refreshed with source data. RECORD COUNT Displays the total number of records across all tables in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Daily_Metric_Chart/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Daily_Metric_Chart/ Target Source Daily Metric Chart This chart displays the number of records in the selected source that were refreshed each day. Refer to View Dashboard in Collect for general information about how data displays on dashboards. To access the chart in Collect: Select Targetsin the Navigationpane. OR Click Targetsin the Navigationpane and click Sourcesfor a target. Click the Metricsicon for a target or source. Click the Dailyicon to view the chart for the selected source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Group/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Group/ Target Source Group Use this page to Build and Refresh Tables for a Schedule Group. To access this page: Click Collect > Targetsin the Navigationpane. Click Sourcesfor a target. Click Schedule Groupsfor a Target Source. Field Description Build Package Click to build a package to download active tables in the schedule group from the source database. Refresh Click to manually extract a copy of data in the schedule group from source and load into the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Metric_Charts/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Metric_Charts/ Target Source Metrics Charts Use this page to view details related to the Target Source Daily Metric Chart, Target Source Weekly Metric Chart and Target Source Monthly Metric Chart. To access this page: Select Collect > Targetsin the Navigation pane. Click the Metricsicon for a target. OR Select Collect > Targetsin the Navigation pane. Click the Sourcesicon for a target. Click the Metricsicon for a source. Field Description TARGET Displays the database where tables are refreshed with source data. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Monthly_Metric_Chart/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Monthly_Metric_Chart/ Target Source Monthly Metric Chart This chart displays the number of records in the selected source that were refreshed during the month. Monthly metrics cover a calendar month. Refer to View Dashboard in Collect for general information about how data displays on dashboards. To access the chart in Collect: Select Targetsin the Navigationpane. OR Click Targetsin the Navigationpane and click Sourcesfor a target. Click the Metricsicon for a target or source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Record_Counts/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Record_Counts/ Target Source Record Counts Use this page to view the Target Source Record Counts report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Record Countson the Reports page. Field Description TARGET Displays the database target where the tables are refreshed with source data. SOURCE Displays thbe database where the data is refreshed from and stobred in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Summary_Metrics/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Summary_Metrics/ Target Source Summary Metrics Use this page to view details related to the Target Source Daily Metric Chart, Target Source Weekly Metric Chart and Target Source Monthly Metric Chart. To access this page: Select Collect > Targetsin the Navigation pane. Click the Metricsicon for a target. Click the Detailsicon. OR Select Collect > Targetsin the Navigation pane. Click the Sourcesicon for a target. Click the Metricsicon for a source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Column_Encryption/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Column_Encryption/ Target Source Table Column Encryption Use this page to Encrypt Columns. To access this page: Create encryption key in Common > Configuration > Modules > Keys. Refer to Create a Secure Key for more information. Return to Collect. Click Tablesin Navigation pane. Click Vertical Viewfor a table. Click Advanced Settingstab. Click Encrypted Columns. Field Description COLUMN Displays column within the table. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Counts/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Counts/ Target Source Table Counts Use this page to view the Target Source Table Counts report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Table Countson the Reports page. Field Description TARGET Displays the database target where the tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Download/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Download/ Target Source Table Download Use this page to view the Target Source Table Download report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Table Downloadon the Reports page. Field Description TARGET Displays the database target where the tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Errors/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Errors/ Target Source Table Errors Use this page to View Collect Reports. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Table Errorson the Reports page. Field Description TARGET Displays the database target where the tables are refreshed with source data. SOURCE Displays the database where the data is refreshed from and stored in the target. TABLE Displays the name of the table in the source database that caused the error. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Index_Columns/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Index_Columns/ Target Source Table Index Columns Use this page to Create Indices for Tables. To access this page: Select Tablesom the Navigationpane. Click the Indicesicon for a table. Click Vertical View. Click the Columnsicon. Field Description INDEX ID Displays name of index. COLUMN Displays column for table index. COLUMN ORDER Displays order column displays in the table index. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Job_Group/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Table_Job_Group/ Target Source Table Job Group Use this page to view the Target Source Table Job Group report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target Source Table Job Groupon the Reports page. Field Description SCHEDULE GROUP Displays the unique name of the schedule group. TARGET Displays the database target that contains the table in the schedule group. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Tables/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Tables/ Target Source Tables H Target Source Tables V (All Tabs) Use this page to Build and Refresh Tables for a Schedule Group. To access this page: Click Collect > Targetsin Navigationpane. Click Sourcesfor target. Click Tablesfor source. Click the Tablesicon for a schedule group. Target Source Tables V (All Tabs) Target Source Tables H This page contains the following tabs: General tab Advanced Settings tab General Information tab Action tab General tab Field Description Build Package Click to build a package to download active tables from the source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Weekly_Metric_Chart/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Source_Weekly_Metric_Chart/ Target Source Weekly Metric Chart This chart displays the number of records in the selected source that were refreshed during a week. Weekly metrics cover a calendar week (Sunday to Saturday). Refer to View Dashboard in Collect for general information about how data displays on dashboards. To access the chart in Collect: Select Targetsin the Navigationpane. OR Click Targetsin the Navigationpane and click Sourcesfor a target. Click the Metricsicon for a target or source. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Sources_H_Collect/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Sources_H_Collect/ Target Sources H Target Sources V (All Tabs) Use this page to: Register Sources to Target Configure Source for SAP Data Services Schedule Source Refresh Create DBMoto®Source Connections Download sdb Tables in Collect Download dgSAP Tables in Collect To access this page: Click Collect > Targetsin the Navigationpane. Click the Sourcesicon for a Target. Target Sources V (All Tabs) Target Sources H Use this page to: https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Sources_Data_Services_Connection/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Sources_Data_Services_Connection/ Target Sources – DataServices Connection Use this page to configure sources for SAP Data Services. To access this page: Click Collect > Targetsin the Navigationpane. Click the Sourcesicon for a Target. Click Vertical Viewfor a Source. Click the Advanced Settingstab. Click Connection Settings. Field available depends on the Data Services Connection Type selected on the VerticalView of the Target Sourcespage: ASE15 DB2 UDBv9 DB2 UDBv8 Informix v10 Informix v11 MySQL v5. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target-Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target-Summary/ Target Summary Use this page to view details about target table downloads and when monitoring the table download process. To access this page, select Collect > Summary > Target Summary in the Navigation pane. Field Description TARGET Displays database target where tables are refreshed with source data. Click the target name link to open the Targets page with the selected target displayed. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Table_Status/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Table_Status/ Target Table Status This chart displays the number of active tables by refresh status for each target. Targets are destination databases (registered as data sources in the platform) where tables are refreshed with source data using Collect. Source data can also be refreshed into a source database (.sdb), so an sdb displays as a target in the x axis on this chart as well.Status includes: Error tables: Tables that failed to refresh. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_User_Access/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_User_Access/ Target User Access Use this page to view the Target User Access report. To access this page: Select Collect > Reportsin the Navigationpane. Click Target User Accesson the Reports page. Field Description TARGET Displays the database target where tables are refreshed with source data. NAME Displays the name of the user who has access to the target. E MAIL ADDRESS Displays the email address of the user who has access to the target. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Weekly_Summary/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Target_Weekly_Summary/ Target Weekly Summary This chart displays the duration of time in seconds it took to refresh all active tables from all registered data sources for a target database for each week. Hover a cursor over a data point and the week, target name and number of seconds display. On this chart, a user can view weekly fluctuations in duration of table refreshes that may be caused by changes in system resources, tables being added or deleted from the refresh, or other factors https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Targets_H_Collect/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Targets_H_Collect/ Targets H Targets V Use this page to Register Targets. To access this page, click Collect > Targetsin Navigationpane. Targets V Targets H This page has two tabs: General Data Protection General tab Use this tab to Register Targets. Field Description Target Displays database where tables are refreshed with source data. Connection Type Displays valid database connection type from source to target. Connection Types are configured under Configuration > Connection Types. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/View_Build_Skip_SPRAS_Table_List/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/View_Build_Skip_SPRAS_Table_List/ View Build Skip SPRAS Table List Use this page to Manage the View Build Skip SPRAS Table List. To access this page, select Collect > Administrative > View Build Skip SPRAS Table Listin Navigationpane. Field Description TABLE NAME Displays table to include on the SPRAS filters in Build View process. DSP SUPPLIED If enabled, this content is delivered content provided by BackOffice. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Download_Failures_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Download_Failures_H/ Workflow Download Failures H Workflow Download Failures V Use this page to View Workflow Download Failures. To access this page, select Collect > Administrative > Workflow Download Failuresin the Navigationpane. Field Description TARGET Displays target database where the download failure occurred. SOURCE Displays source database where the download failure occurred. TABLE Displays table name where the download failure occurred. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Summary_History_H/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Summary_History_H/ Workflow Summary History H Workflow Summary History V Use this page to review who is receiving workflow emails. To access this page, select Collect > Administrative > Workflow Summary Historyin the Navigationpane. Field Description USER NAME Displays user who received the summary workflow email. WORKFLOWED BY Displays name of job that ran the workflow. WORKFLOWED ON Displays date and time when the summary workflow email was sent. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Summary_User_Settings/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Page_Desc/Workflow_Summary_User_Settings/ Workflow Summary User Settings Use this page to Configure Workflow Summary User Settings. To access this page, select Collect > Administrative > Workflow Summary User Settingsin the Navigationpane.