ISharedParams.EtlTemplates

The EtlTemplates property returns collection of custom templates of sources or consumers.

Example

Executing the example requires a unit with the USERCLASSFORETL identifier containing the USER_PROVIDER class to implement required interfaces.

Add links to the Dt, MathFin system assemblies.

Class USER_PROVIDER: Object, IDtRecordsetProvider

    Public Function Fetch: Array Of Variant;
        Var
            ResArray: Array[0..1, 0..10] Of Variant;
            i, j: integer;
        Begin
            For j := 0 To 10 Do
                For i := 0 To 1 Do
                    If i = 0 Then
                        ResArray[i, j] := "Code-" + j.ToString;
                    Else
                        ResArray[i, j] := Math.RandBetween(0, 100);
                    End If;
                End For;
            End For;
            Return ResArray;
    End Function Fetch;

End Class USER_PROVIDER;

Sub UserProc;
Var
    MB: IMetabase;
    Params: ISharedParams;
    Templates: IEtlTemplates;
    Template: IEtlTemplate;
    xmlEl: IXmlDomElement;
    xmlDom: IXmlDomDocument;
    Node: IXmlDomNode;
Begin
    MB := MetabaseClass.Active;
    Params := MB.SpecialObject(MetabaseSpecialObject.SharedParams).Edit As ISharedParams;
    Templates := params.EtlTemplates(ETLTemplateType.Provider);
    Template := Templates.Add;
    xmlDom := New FreeThreadedDOMDocument60.Create;
    xmlEl := xmlDom.createElement("firstTemplate");
    xmlEl.setAttribute("server", "PPServer");
    xmlEl.setAttribute("database", "databse");
    xmlDom.appendChild(xmlEl);
    Node := xmlDom.createNode("Element", "Table", "");
    xmlEl.appendChild(Node);
    Node.text := "T_SEP";
    Template.Module := mb.ItemById("USERSCLASSFORETL");
    Template.Class_ := "User_Provider";
    Template.Id := "TemplId";
    Template.Name := "TemplName";
    Debug.WriteLine("The ETL object template type - " + Template.Type.ToString);
    (Params As IMetabaseObject).Save;
End Sub UserProc;

After executing the example on the ETL task opening new custom template of data source will be available.

ISharedParams.EtlTemplates

Syntax

Parameters

Description

Example