Release Notes

There have been significant changes implemented into BimlStudio 2022 R1 since the last major release, with a heavy focus on parity with Azure Data Factory.

BimlStudio Improvements

bimlc.exe

  • Added support for improved and more robust product key caching.
  • Alternate spelling of licenseKey (licenceKey) is now accepted as a command line argument.

BimlFlex Projects

  • Fixed bug where duplicating an Extension Point in BimlStudio created the duplicate in the wrong folder.
  • Added the ability to connect to Azure SQL BimlFlex databases. Password, MFA, and Integrated connections now supported.
  • Added the ability to deploy dacpacs directly to Azure SQL databases.

Azure Data Factory

  • Added support for CustomEvents triggers.
  • Added AzureCloudType enum attribute to all Azure-based LinkedService nodes.
  • Fixed bug where missing icons caused the app to crash for various LinkedServices.
  • Added EmitAsStringLiteral property to AstAdfDataflowParameterReferenceNodes. This meta property is used to determine how values should be emitted.
  • Added extended support for Dynamic Content so that parameters can be passed in to an ADF Pipeline or Mapping Data Flow and then evaluated at run time.
  • Added connector support for:
    • AmazonS3Compatible as LinkedService, Dataset, Source
    • AzureDatabricksDeltaLake as LinkedService, Dataset, Source, Sink
    • MongoDbAtlas as LinkedService, Dataset, Source
    • OracleCloudStorage as LinkedService, Dataset, Source
    • AzureFileStorage as Sink

 

  • Added the following properties to MachineLearningExecutePipeline activities:
Name Property Type Data Type Description
MlPipelineEndpointId Attribute String The ID of the published ML pipeline endpoint.
Version Attribute String The version of the endpoint.

   

  • Added the following property to Custom activities:
Name Property Type Data Type Description
AutoUserSpecification Attribute String Elevation level and scope for the user, default is nonadmin task.

   

  • Added the following properties to SapOpenHub LinkedServices:
Name Property Type Data Type Description
SystemId Attribute String SystemID of the SAP system where the table is located.
MessageServer Attribute String The hostname of the SAP Message Server.
MessageServerService Attribute String The service name or port number of the Message Server.
LogonGroup Attribute String The Logon Group name for the SAP System.

Mapping Data Flow Support

  • Added the following Inline Dataset Source support:
    • Avro
    • Azure MySQL
    • Azure PostgreSQL
    • Azure SQL
    • Azure SQL MI
    • Delimited
    • Delta
    • Excel
    • JSON
    • Orc
    • Snowflake
    • SQL Server
    • Synapse
    • XML

 

  • Added the following Inline Dataset Sink support:
    • Avro
    • Azure MySQL
    • Azure PostgreSQL
    • Azure SQL
    • Azure SQL MI
    • Delimited
    • Delta
    • JSON
    • Orc
    • Snowflake
    • SQL Server
    • Synapse

 

  • Added support for the following properties for Dataflow Lookup Transformations:
Name Property Type Data Type Description
MatchMultipleRows Attribute Bool This specifies whether to return all matched rows on a lookup.
BroadcastAction Attribute BroadcastActionEnum This specifies how to handle broadcasting. When using Fixed, make sure you specify if you want the input or lookup stream to be broadcast.
MatchOn Attribute String Specifies matching behavior in the lookup stream. Only valid when MatchMultipleRows is set to false.
SortConditions Child Collection of SortColumnNodes This is a collection of conditions that will be used for sorting.

 

  • Added the following properties to ExecuteDataflow activities:
Name Property Type Data Type Description
ContinueOnError Attribute Bool Continue on error setting used for data flow execution. Enables processing to continue if a sink fails.
RunConcurrently Attribute Bool Concurrent run setting used for data flow execution. Allows sinks with the same save order to be processed concurrently.
TraceLevel Attribute TraceLevelEnum Trace level setting used for data flow monitoring output. Supported values are: coarse, fine, and none.

 

  • Added LogicalDisplayFolder property to dataflow nodes.
  • Added the following to the FormatSettings property of Dataflow source nodes:
    • TarGZipSettings
    • TarSettings
    • XmlSettings

AzureCosmosDB

  • Added the following properties to AzureCosmosDb source nodes:
Name Property Type Data Type Description
DetectDateTime Attribute Bool Whether detect primitive values as datetime values.
PageSize Attribute Int Specifies the allowed page size.

   

  • Added the following properties to AzureCosmosDb LinkedServices:
Name Property Type Data Type Description
Tenant Attribute String Tenant associated with service principal account.
ServicePrincipalCredentialType Attribute CredentialTypeEnum Specifies what type of service principal credential will be used for authentication.
ServicePrincipalId Attribute String Specifies the service principal ID to be used during authentication.
ServicePrincipalCredential Attribute String Specifies the service principal credential to be used during authentication. (Also supports ServicePrincipalCredentialKVS).
  • Removed the following properties from AzureCosmosDb source nodes:
    • NestingSeparator
    • WriteBehavior