Description

The MSSQLPartitionReceiver creates one or more InFile descriptions and one or more InFiles containing the generated data. 


This Receiver is meant to be used in Scenarios that are run by the GenRocket G-Partition engine to generate huge amounts of data; thus, this parameter will automatically be set by the G-Partition engine. 

Note: To learn more about the GenRocket G-Partition engine, click here. 


Receiver Parameters

The following parameters can be defined for the MSSQLPartitionReceiver. Items with an asterisk (*) are required: 

  • outputPath* -Defines the path where the InFile descriptions and data files will be created. 
  • outputSubDir - Defines an optional sub-directory under the outputPath where generated data will be stored. 
  • resourcePath* - Defines the path where the resource file for JDBC connection properties exists. 
  • resourceSubDir - Defines an optional sub-directory under the resourcePath where the resource file for JDBC connection properties exists.
  • resourceName* - Defines the name of the resource that contains the database connection information on a user's local machine. 
  • tableName* - Defines the name of the database table that will be loaded via one or more InFiles.
  • fieldTerminator* - Determines how each data field within the InFile data will be delimited (Tab or Comma).
  • lineTerminator* -Defines how each data row within the InFile data file will be terminated. 
  • filesPerDirectory* - Defines the number of files that will be created in each directory.
  • recordsPerFile* - Defines the number of records that will be stored in each file.
  • executeinFile* - Defines whether each InFile should be executed after all InFiles have been generated.
  • serverNumber* - Defines the server instance number where the Receiver will be running and helps the Receiver determine the output directory structure where it will deposit the generated data files. This Receiver is meant to be used in Scenarios that are run by the GenRocket G-Partition engine to generate huge amounts of data; thus, this parameter will automatically be set by the G-Partition engine.
  • instanceNumber* - Defines the runtime instance number on a given server instance where the Receiver will be running and helps the Receiver determine the output directory structure where it will deposit the generated data files. This Receiver is meant to be used in Scenarios that are run by the GenRocket GPartition engine to generate huge amounts of data; thus, this parameter will automatically be set by the G-Partition engine.
  • keepIdentity* - To control the values generated for identity columns in the database table. If set to true, during the migration of data from the source to the destination table, it will retain the source values in the destination table, else it will generate as per the identity column format. 


Receiver Attribute Property Keys

The Receiver defines two property keys that can be modified on any of its associated Domain Attributes:

  • columnName - Specifies the table column name as it is in the actual database (e.g., first_name, last_name).
  • include - Determines if the Attribute will be included in the InFile data dump.