BimlStudio 2019 R1 Release Notes
Significant changes between BimlStudio 2018 R3 and BimlStudio 2019 R1
SSIS
- Removed NoXML validation for
SQL Server
index nodes as they can now have XML datatypes. - Fixed bug where
Annotations
created onOutputBuffer
columns were not being persisted. - Fixed bug where
Container
propertyTransactionOption
was being evaluated as an object rather than anint32
. - Fixed typo in
MergeJoin
error message. - Added fix to correctly emit
BlobColumns
inBufferWrapper.cs
for ScriptProjects. - Added SqlServer 2019 support.
- Added SSIS 2019 support.
- Removed
Codepage
property from FlatFileFormat Columns, as the codepage gets set on theFlatFileFormat
and is not configurable at the column level. - Fixed bug in
GetQuerySchema()
, where column nodes were not correctly readingComputedText
andIsNullable
properties.
BimlStudio Improvements
- Removed the live assets checkbox from the logical view as it was confusing and no longer valuable for modern users of BimlStudio.
- The validator is now suspended during background compilation to improve performance and prevent the temporary appearance of spurious errors.
Azure Data Factory
- Fixed the way that
TabularTranslator
is emitted in Copy activities. - Added support for
AzureDataExplorer
linked services, datasets, copy sources and copy sinks. - Added support for
SapOpenHub
linked services, datasets, and copy sources. - Added support for
REST
linked services, datasets, and copy sources. - Added support for
AzureFunction
linked services and activities. - Added support for
Delete
activities. - Added support for
DynamicsAx
linked services, datasets, and copy sources. - Added support for
CosmosDbMongoDb
linked services, datasets, copy sources and copy sinks. - Added support for
OracleServiceCloud
linked services, datasets, and copy sources. - Added support for
Office365
linked services, datasets, and copy sources. - Added support for
GoogleAdWords
linked services, datasets, and copy sources. - Changed name
AzureDataLakeStore
linked services, datasets, copy sources and copy sinks toAzureDataLakeStoreGen1
- Added support for
AzureDataLakeStoreGen2
linked services, datasets, copy sources and copy sinks. - Fixed typo in the error message of
AzureDataLakeStoreGen1LinkedService
when noServicePrincipalKey
orServicePrincipalKeyKVS
are set. - Added
Pipeline
property to theTrigger
base class. As Some triggers only allow one, rather than a collection of pipelines. - Added
EventBasedTrigger
support. - Added
EncryptedCredential
property to all linked services. - Added support for
SetVariable
activity. - Added support for
AppendVariable
activity. - Added ability to emit json with nested arrays.
- Universally renamed
KeyVaultSecret
properties toKVS
in order to aid with brevity and avoid naming collisions (e.g.ServicePrincipalKeyKVS
is much more favorable toServicePrincipalKeyKeyVaultSecret
- Added support for
DatabricksJar
activity. - Added support for
DatabricksPython
activity. - Placed a 40 activity limit on pipeline nodes.
- Changed
SqlServerLinkedServiceBase
linked serviceStoredProcedureName
property to an attribute from a child. - Changed all AuthenticationType enums to use the suffix AuthenticationType, as some were AuthType and some were AuthenticationMode.
- Changed port property from int to string for
AmazonRedshiftLinkedService
andSparkLinkedService
nodes. - Renamed
MachineLearningLinkedService
toAzureMachineLearningLinkedService
. - Added a KeyVaultSecret reference to all Connection String linked services to aid with sensitive properties like
Password
orAccessKey
. - Added
ModifiedDatetimeStart
andModifiedDatetimeEnd
properties toAmazons3
,FileShare
andAzureBlob
Dataset nodes. - Added
NewClusterSparkEnvVars
,NewClusterDriverNodeType
,NewClusterInitScripts
,NewClusterEnableElasticDisk
andNewClusterCustomTags
properties toAzureDatabricks
Linked Services. - Added
ScriptActions
,ZookeeperNodeSize
,DataNodeSize
, andHeadNodeSize
properties toHdInsightOnDemand
Linked Services. - Added
DependsOn
collection toTumblingWindow
Triggers. - Added custom validation to prevent both
SecretAccess
andSecretAccessKVS
from being configured at the same time forAmazonS3
Linked Services. - Added custom validation to ensure that
RedirectRowSettings
are configured whenEnableSkipIncompatibleRow
is configured in Copy Activities. - In some dataset types, we made the
FolderPath
property optional. - Changed pipeline parameter datatype enum to match ADF rather than using
Db.Type
. - Added pipeline
Variables
property, and linked them to theSetVariable
andAppendVariable
activities. - Fixed a bug where nested arrays were not emitting correctly.
- Added support for
Webhook
activities. - Added support for
Validation
activities.
Bimlc.exe
- Fixed issue where
bimlc.resp
files were getting generated with the wrong flag syntax forBuildDocumentation
setting. - Improved messaging in help message around versioning.
SSAS Tabular
- Made
DataCategory
into an extensible string field. - Made
type
property required.
BimlFlex Projects
- Prevent filtering out preview nodes for diagram menu options
- Complete overhaul of Schema Graphs.
- Deprecated the Upgrade utility for upgrading BimlFlex bundles. That functionality is now handled through the installer.
Installer
- Added the ability to create and validate license keys directly in the installer.
- Improved handling of unavailable features. Users can now force install features that were previously unavailble due to their environment right clicking on the feature and selecting the 'force install' option.
- We now support headless installations, configurable through the command line.
- Added a comprehensive breakdown of product features by screen.
- Added richer logging capabilities to aid in diagnosing any installation issues.
- Added the capability to manage your BimlFlex environment, whether that is upgrading your bunlde, your BimlFlex database, or the BimlCatalog database.