Parameter Editor

Parameters in BimlFlex are used to managed load windows. For 'high water mark' delta loading and similar simple parameters such as filters, adding a parameter to the design will include all required logic to the generated data logistics processes.

Tip

For detailed information on how to and configure the parameter concept in BimlFlex please refer to our parameter concept overview guide.

Parameters can also be used in Extension Points, if additional and more complex parameters that require custom logic are required.

Parameters are created and edited using the Parameter Editor in the BimlFlex Application.

Tip

The Varigence YouTube channel contains various introduction videos about using BimlFlex and BimlStudio. This video provides an example of how to apply load parameters.

Overview

The following sections describe the User Interface elements of the Parameter Editor and how they are used to author and manage BimlFlex parameters.

Parameters in BimlFlex are displayed in the Treeview. Selecting any parameter will open the editor.

Note

Detailed descriptions of all Parameter Editor fields and options are available in the Reference Documentation.

Action Buttons

Icon	Action	Description
	Save	This will save the currently set of staged changes. The Save button is will only enable if the Parameter has changes staged and there are no major validation issues with the current Parameter properties.
	Discard	This will Discard any unsaved changes and revert to last saved form.
	Archive	This will hard delete the selected Parameter. This will result in the physical removal of the selected record from the BimlFlex Database. The data will no longer be accessible by the BimlFlex Applicationand will require a Database Administrator to restore, if possible. Clicking Archive creates an Archive Parameter Dialog.
	Duplicate	This will create a duplicate of the selected Parameter. A Duplicate Parameter Dialog will appear asking for a Parameter Name and a new Parameter will be created using all of the selected Parameter's current properties.
	Deleted	This will soft delete the currently selected Parameter. This will remove the Parameter and all associated entities from processing and validation.

Additional Dialogs

Archive Parameter Dialog

Confirmation box warning against the dangers of archiving. You are required to confirm by both the check box and the Ok button.

Warning

Archiving is a permanent removal of the selected entity from its associated table in the BimlFlex Database. The best practice is to first use the Deleted flag (soft delete) as an indication that the connection may need to be removed.

Duplicate Parameter Dialog

This will create a copy of the selected Parameter and properties.

Allowed Values

Data Types

Data Types are the allowed values that can be used to specify Columns in BimlFlex.

Data Type	Description
AnsiString	ANSI string.
AnsiStringFixedLength	Fixed length ANSI string.
Binary	Binary data column.
Boolean	Boolean, Bit or True/False.
Byte	Unsigned tiny integer.
Currency	Money or currency.
Date	Date only.
DateTime	Date and time.
DateTime2	Variable precision date and time. Increased precision over DateTime.
DateTimeOffset	Data and time with time zone offset.
Decimal	Fixed precision and scale numbers.
Double	Float or Double.
Guid	Unique identifier or GUID.
Int16	Small integer.
Int32	Integer.
Int64	Big integer.
Object	Object. Used for complex data types.
SByte	Tiny integer.
Single	Real or Single.
String	Unicode String.
StringFixedLength	Fixed Length Unicode String.
Time	Time only.
UInt16	Unsigned small integer.
UInt32	Unsigned integer.
UInt64	Unsigned big integer.
VarNumeric	Variable numeric
Xml	XML formatted data.
HierarchyId	SQL Server HierarchyId data type.
Geometry	SQL Server geometry data type.
Geography	SQL Server geography data type.
SmallMoney	Small money.
Variant	Variant. Non explicit data type.

Note

For information on how these map to SQL Server, Synapse and Snowflake data types see associated link below.
BimlFlex Documentation: BimlFlex Data Type Conversions.