Parameterise Connections

In this webinar, we show you how to add an Expression to a ConnectionString using the ConnectionExpression ExtensionPoint. We then parameterise ConnectionString using a ProjectParameter ExtensionPoint and demonstrate this using a sources staging with the dimensional data warehouse BimlFlex pattern.

ConnectionExpression

Add a ConnectionExpression ExtensionPoint and configure it as follows.

<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ConnectionExpression" target="BimlCatalog" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
<Expressions>
    <Expression ExternalProperty="ConnectionString">"Data Source=" + @[$Project::ServerName] + ";Initial Catalog=BimlCatalog;Integrated Security=True;"</Expression>
</Expressions>

ProjectParameter

Add a ProjectParameter ExtensionPoint and configure it as follows.

<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ProjectParameter" target="@@global" #>
<Parameter Name="ServerName" DataType="String" IsRequired="true">localhost</Parameter>

That's is how easy it is to configure and parameterise your connections in BimlFlex

Watch the Recording