Skip to content

Invoke-JdbcHandler

SYNOPSIS

Handles imports from JDBC sources.

SYNTAX

1
2
Invoke-JdbcHandler [-SourceDirectory] <String> [-ImportClientConfiguration] <PSObject>
 [-ConfigurationSourceSettings] <PSObject> [-ProgressAction <ActionPreference>] [<CommonParameters>]

DESCRIPTION

This function acts as a "controller" of the flow for imports from a JDCB source, for example a CSV file.

This function is responsible for importing the modules necessary for reading data from the source and applying the settings specified in the Easit GO ImportClient configuration and / or source configuration.

General flow:

  • Import JDBC dependency module
  • Convert ImportClient configuration (ConvertFrom-ReliqueJdbcCsvCsvDriver).
  • Read data from source
  • Update data with settings provided via combineSourceAttributes.
  • Return source data.

EXAMPLES

EXAMPLE 1

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
if ($importClientConfiguration.ConfigurationType -eq 'jdbcConfiguration') {
    $ijhParams = @{
        SourceDirectory = $srcDirectory
        ImportClientConfiguration = $importClientConfiguration
        ConfigurationSourceSettings = $source
    }
    try {
        $sourceObjects = Invoke-JdbcHandler @ijhParams
    } catch {
        Write-Error $_
        continue
    }
}

PARAMETERS

-ConfigurationSourceSettings

Source configuration settings.

1
2
3
4
5
6
7
8
9
Type: PSObject
Parameter Sets: (All)
Aliases:

Required: True
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ImportClientConfiguration

ImportClient configuration object (From Easit GO or custom).

1
2
3
4
5
6
7
8
9
Type: PSObject
Parameter Sets: (All)
Aliases:

Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ProgressAction

Determines how PowerShell responds to progress updates generated by a script, cmdlet, or provider, such as the progress bars generated by the Write-Progress cmdlet. The Write-Progress cmdlet creates progress bars that show a command's status.

The ProgressAction parameter takes one of the ActionPreference enumeration values: SilentlyContinue, Stop, Continue, Inquire, Ignore, Suspend, or Break.

1
2
3
4
5
6
7
8
9
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SourceDirectory

Path to directory where module for handling JDBC configuration exist.

1
2
3
4
5
6
7
8
9
Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

System.String

PSCustomObject

OUTPUTS

System.Collections.ArrayList

NOTES