Staging Parameters for Supported Adapters

The following tables show the staging parameters for each adapter that SAS IT Resource Management supports. These staging parameters are available from the Adapter Setup wizard. They are also available from the Staging Parameters tab of the Properties dialog box for an adapter or staging transformation.

Amazon CloudWatch for Staging and Duplicate-Data Checking Parameters

ASG TMONC2CIC Staging and Duplicate-Data Checking Parameters

ASG TMONDB2 Staging and Duplicate-Data Checking Parameters for V4 and Earlier Versions

ASG TMONDB2 V5 Staging and Duplicate-Data Checking Parameters for V5 and Higher Versions

BMC Mainview IMS Staging and Duplicate-Data Checking Parameters

BMC Perf Mgr Staging and Duplicate-Data Checking Parameters

CA TMS Staging and Duplicate-Data Checking Parameters

CSV Staging and Duplicate-Data Checking Parameters

DT Perf Sentry Staging and Duplicate-Data Checking Parameters

DT Perf Sentry with MXG Staging and Duplicate-Data Checking Parameters

Ganglia Staging and Duplicate-Data Checking Parameters

HP Perf Agent Staging and Duplicate-Data Checking Parameters

HP Reporter Staging and Duplicate-Data Checking Parameters

IBM DCOLLECT Staging and Duplicate-Data Checking Parameters

IBM EREP Staging and Duplicate-Data Checking Parameters

IBM SMF Staging and Duplicate-Data Checking Parameters

IBM TPF Staging and Duplicate-Data Checking Parameters

IBM VMMON Staging and Duplicate-Data Checking Parameters

MS SCOM Staging and Duplicate-Data Checking Parameters

RRDtool Staging and Duplicate-Data Checking Parameters

SAP ERP Staging and Duplicate-Data Checking Parameters

SAR Staging and Duplicate-Data Checking Parameters

SAS Environment Manager (SAS EV) Staging and Duplicate-Data Checking Parameters

SNMP Staging and Duplicate-Data Checking Parameters

VMware Data Acquisition Parameters

VMware vCenter Staging and Duplicate-Data Checking Parameters

Web Log Staging and Duplicate-Data Checking Parameters

Amazon CloudWatch for Staging and Duplicate-Data Checking Parameters

Staging Parameters for the Amazon CloudWatch Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input directory	any valid directory or folder	none

Duplicate-Data Checking Parameters for the Amazon CloudWatch Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
KEEP	any integer	26
REPORT	Yes No	Yes

ASG TMONC2CIC Staging and Duplicate-Data Checking Parameters

Staging Parameters for the ASG TMONC2CIC Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file	any valid file	none
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the ASG TMONC2CIC Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

ASG TMONDB2 Staging and Duplicate-Data Checking Parameters for V4 and Earlier Versions

Staging Parameters for the ASG TMONDB2 Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file	any valid file
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the ASG TMONDB2 Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

ASG TMONDB2 V5 Staging and Duplicate-Data Checking Parameters for V5 and Higher Versions

Staging Parameters for the ASG TMONDB2 V5 Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file	any valid file
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the ASG TMONDB2 V5 Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

BMC Mainview IMS Staging and Duplicate-Data Checking Parameters

Staging Parameters for the BMC Mainview IMS Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the BMC Mainview IMS Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

BMC Perf Mgr Staging and Duplicate-Data Checking Parameters

Staging Parameters for the BMC Perf Mgr Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file	any valid file
Allow duplicate ID variables	Yes No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the BMC Perf Mgr Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	00:18
KEEP	any integer	52
REPORT	Yes No	Yes

CA TMS Staging and Duplicate-Data Checking Parameters

Staging Parameters for the CA TMS Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VB and LRECL=16384
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the CA TMS Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	25:00
KEEP	any integer	26
REPORT	Yes No	Yes

CSV Staging and Duplicate-Data Checking Parameters

Staging Parameters for the CSV Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory		The CSV adapter does not support non-ASCII characters in the heading columns. For more information, see Accessing CSV Files That Contain Data Encoded in UTF-8.
Type of delimiter	list of delimiter characters delimiter string	list of delimiter characters
Delimiter characters	any characters	,
Delimiter string	any characters
Is the delimiter string case sensitive?		Yes	Only available if Type of delimiter is Delimiter string.
Is there a header row?		Yes
What row is the header on?		1
What row does the data start on?	any integer	any integer
How many rows of data should be used as guessing rows?		20
Future data		Discard

Duplicate-Data Checking Parameters for the CSV Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
IDVAR	SAS variable	FILENAME
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:15
KEEP	any integer	52
REPORT	Yes No	Yes

DT Perf Sentry Staging and Duplicate-Data Checking Parameters

Staging Parameters for the DT Perf Sentry Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
Delimiter in raw data	Comma Tab	Comma
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the DT Perf Sentry Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:18
KEEP	any integer	52
REPORT	Yes No	Yes

DT Perf Sentry with MXG Staging and Duplicate-Data Checking Parameters

Staging Parameters for the DT Perf Sentry with MXG Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=V and LRECL=32756
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the DT Perf Sentry with MXG Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

Ganglia Staging and Duplicate-Data Checking Parameters

Staging Parameters for the Ganglia Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
RSH/SSH host command
rrdtool executable
rrdtool fetch -start option		e-2days
rrdtool fetch -end option	time
Consolidation Function (CF)	any consolidation function	AVERAGE
Normalize datetime	Yes No	Yes
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the Ganglia Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
IDVAR	SAS variable	FILENAME
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:15
KEEP	any integer	52
REPORT	Yes No	Yes

HP Perf Agent Staging and Duplicate-Data Checking Parameters

Staging Parameters for the HP Perf Agent Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the HP Perf Agent Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:05
KEEP	any integer	52
REPORT	Yes No	Yes

HP Reporter Staging and Duplicate-Data Checking Parameters

Staging Parameters for the HP Reporter Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref
Future data	Accept Discard Terminate	Discard
Default duration	0 or greater	0

Duplicate-Data Checking Parameters for the HP Reporter Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:05
KEEP	any integer	260
REPORT	Yes No	Yes

IBM DCOLLECT Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM DCOLLECT Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VB and LRECL=16384
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the IBM DCOLLECT Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	26:00
KEEP	any integer	26
REPORT	Yes No	Yes

IBM EREP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM EREP Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VB and LRECL=16384
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the IBM EREP Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	26:00
KEEP	any integer	26
REPORT	Yes No	Yes

IBM SMF Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM SMF Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File or directory (default)	Raw data input file or directory	any valid file or directory
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate			Discard
JES	JES2 JES3			JES2
Presummarization duration	any integer greater than or equal to 1 and less than or equal to 2,147,483,647			0
Use intermediate staging view	any valid staged table name

Duplicate-Data Checking Parameters for the IBM SMF Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	00:29
KEEP	any integer	52
REPORT	Yes No	Yes

IBM TPF Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM TPF Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=S370VBS and LRECL=32760
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the IBM TPF Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:00
KEEP	any integer	26
REPORT	Yes No	Yes

IBM VMMON Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM VMMON Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input type	File (default)	Raw data input file	any valid file
	FTP	Host	any valid host
		Port	any valid port	21
		User	any valid user
		Password	any valid password
		External file name	any valid file
		Tape	Yes No	No
		RCMD	any valid site	SITE RDW
		Debug	Yes No	No
Input File Parameters	values for RECFM and LRECL parameters	RECFM=F and LRECL=4096
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the IBM VMMON Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	26:00
KEEP	any integer	26
REPORT	Yes No	Yes

MS SCOM Staging and Duplicate-Data Checking Parameters

Staging Parameters for the MS SCOM Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the MS SCOM Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:05
KEEP	any integer	52
REPORT	Yes No	Yes

RRDtool Staging and Duplicate-Data Checking Parameters

Staging Parameters for the RRDtool Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
RSH/SSH host command
rrdtool executable
rrdtool fetch -start option		e-2days
rrdtool fetch -end option	time
Consolidation Function (CF)	any consolidation function	AVERAGE
Class columns	any class columns	filename datetime
Normalize datetime	Yes No	Yes
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the RRDtool Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
IDVAR	SAS variable	FILENAME
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:15
KEEP	any integer	52
REPORT	Yes No	Yes

SAP ERP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SAP ERP Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref
Future data	Accept Discard Terminate	Discard
Presummarization duration	any integer greater than or equal to 1 and less than or equal to 2,147,483,647	3600

Duplicate-Data Checking Parameters for the SAP ERP Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	00:20
KEEP	any integer	250
REPORT	Yes No	Yes

SAR Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SAR Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file or directory	any valid file or directory
Number of processors to use	any positive number	0, which means that all available processors are used	If 1, then MPConnect is not used and the staging code is run on a single processor.
Minimum number of files to read on each processor	any positive number	50
Temporary work space library	WORK library Staging library Other library
Library for temporary work space	any valid library
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the SAR Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:15
KEEP	any integer	52
REPORT	Yes No	Yes

SAS Environment Manager (SAS EV) Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SAS Environment Manager (SAS EV) Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref of APM and ACM data sources
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the SAS Environment Manager (SAS EV) Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	0:29
KEEP	any integer	52
REPORT	Yes No	Yes

SNMP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SNMP Adapter
Parameters Supported for This Adapter	Values	Suboptions	Values for Suboptions	Default Values
Choose raw data input directory	any valid directory
RSH/SSH host command	any valid command
Use snmpwalk to gather character data	Yes	snmpwalk executable	any valid executable
		HostFile for snmpwalk	any valid file
		Community value for snmpwalk	any valid community name
	No (default)
Choose access command	HP NNM/Netview (default)	snmpColDUmp	any valid executable
	RRDtool	RRDtool executable	any valid executable
	RRDtool	Number of days to load	a number from 1 to 365	2
Future data	Accept Discard Terminate			Discard

Duplicate-Data Checking Parameters for the SNMP Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	01:03
KEEP	any integer	52
REPORT	Yes No	Yes

VMware Data Acquisition Parameters

Staging Parameters for the VMware Data Acquisition Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref
Age limit for data acquisition table (in days)	a positive integer	7

Note: The VMware Data Acquisition adapter does not support duplicate-data checking parameters.

VMware vCenter Staging and Duplicate-Data Checking Parameters

Staging Parameters for the VMware vCenter Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input library: Library and Libref	any valid library and libref
Future data	Accept Discard Terminate	Discard

Duplicate-Data Checking Parameters for the VMware vCenter Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	00:18
KEEP	any integer	1
REPORT	Yes No	Yes

Web Log Staging and Duplicate-Data Checking Parameters

Staging Parameters for the Web Log Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Raw data input file	any valid file
Delimiter in raw data	Space Comma Tab	Space
Future data	Accept Discard Terminate	Discard
Machine	any valid machine name
Site name	any valid site name
Presummarization duration	any integer greater than or equal to 1 and less than or equal to 2,147,483,647	3600

Duplicate-Data Checking Parameters for the Web Log Adapter
Parameters Supported for This Adapter	Values	Default Value	Notes
Enable duplicate checking	Yes No	Yes
Duplicate checking options	Discard Force Terminate	Discard
INT	time in the format hh:mm, where hh represents hours and mm represents minutes	08:00
KEEP	any integer	250
REPORT	Yes No	Yes

Copyright © SAS Institute Inc. All rights reserved.