Connection Extension Points
The Connection category has the following available Extension Points defined.
Connection Expression
Configure Expressions for a Connection. This only applies to SSIS deployments.
Parameters
Name | Type | Description |
|---|---|---|
| connection | BimlFlexModelWrapper.ConnectionsWrapper | Contains all information related to the connection to which the connection expression will be added. |
Template
<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ConnectionExpression" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
<!-- The below example is configuring an expression to an ODBC connection. Note that we are referencing Project Parameters that also need to be configured.-->
<Expressions>
<Expression ExternalProperty="ConnectionString">"Dsn=SRC_ODBC;Uid=" + @[$Project::UserName] + ";Pwd=" + @[$Project::UserPassword] + ";"</Expression>
</Expressions>
Connection Override
Configure a custom override for a Connection. This only applies to SSIS deployments. Using this Extension Point, a Connection can be (re)configured by using any BimlScript compatible code.
Parameters
Name | Type | Description |
|---|---|---|
| connection | BimlFlexModelWrapper.ConnectionsWrapper | Contains all information related to the connection to which the connection expression will be added |
Template
<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ConnectionOverride" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
<!-- The below example is configuring an ODATA connection. -->
<CustomSsisConnection
Name="Northwind"
CreationName="ODATA"
ObjectData="<ODataConnectionManager UserName="" Url="https://services.odata.org/V3/Northwind/Northwind.svc" ConnectionString="Service Document Url=https://services.odata.org/V3/Northwind/Northwind.svc;" MicrosoftOnlineServicesAuth="False" AuthType="WindowsAuthentication" />" />
Database Post Deployment
Add Post Deployment Script to SSDT Project.
Parameters
Name | Type | Description |
|---|---|---|
| connection | BimlFlexModelWrapper.ConnectionsWrapper | Contains all information related to the connection to which the connection expression will be added |
Template
<#@ extension bundle="BimlFlex.bimlb" extensionpoint="DatabasePostDeployment" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
SET NOCOUNT ON;
Database Pre Deployment
Add Pre Deployment Script to SSDT Project.
Parameters
Name | Type | Description |
|---|---|---|
| connection | BimlFlexModelWrapper.ConnectionsWrapper | Contains all information related to the connection to which the connection expression will be added |
Template
<#@ extension bundle="BimlFlex.bimlb" extensionpoint="DatabasePreDeployment" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
SET NOCOUNT ON;
Database Properties
Add Database Properties to SSDT Project.
Parameters
Name | Type | Description |
|---|---|---|
| connection | BimlFlexModelWrapper.ConnectionsWrapper | Contains all information related to the connection to which the connection expression will be added |
Template
<#@ extension bundle="BimlFlex.bimlb" extensionpoint="DatabaseProperties" #>
<#@ property name="connection" type="BimlFlexModelWrapper.ConnectionsWrapper" #>
<ModelCollation>1033,CS</ModelCollation>
<AnsiWarnings>False</AnsiWarnings>
<AnsiPadding>False</AnsiPadding>