v4.5.1

Features

• Ability to configure Trust Server Certificate. Note that enabling this option bypasses certificate validation and reduces TLS security (MITM risk), so it should only be used when necessary (for example in development or with self-signed certificates) and is not generally recommended for production use unless the implications are fully understood.

Changes:

• 4f068c8 Merge branch 'release/4.5.1'
• c444c76 feat: Ability to configure trust server certificate (#138)
• 1d0a368 Merge branch 'master' into develop
• dfafd0c Merge branch 'release/4.5.0' into develop
• d09486e Merge pull request #137 from CluedIn-io/master
• 54007e7 Merge pull request #136 from CluedIn-io/release/4.1.2

This list of changes was auto generated.

v4.5.0

Features

• Update platform dependency to 4.5.0

Fixes

Changes:

• 7a72c3f Merge branch 'release/4.5.0'
• d2d1cb3 Merge remote-tracking branch 'origin/master' into release/4.5.0
• d03cd97 chore: Update package props
• 1dc86a7 chore: Update packageprops
• bf0f8e2 chore: Add release notes
• cf52606 chore: Update platform dependency to 4.5.0 (#135)

This list of changes was auto generated.

v4.1.2

Features

• Validate that configure sql schema exists in verify connection

Fixes

• Fallback to default schema if empty string is specified
• Fix issue where entityreferences properties were not serialized correctly

Changes:

• 4466a0d Merge branch 'release/4.1.2'
• ae01fc9 Merge remote-tracking branch 'origin/master' into release/4.1.2
• 4d485c0 chore: Add release notes
• 9be3b55 fix: Convert PersonReference typed properties (#132)
• 4903b8f chore: Turn off connection encryption requirement (#133)
• fbeb565 chore: Improve VerifyConnection error messages (#131)
• 3756405 fix: Validate schema correctly, and fallback to default if empty string is specified (#130)
• 170107f Merge pull request #129 from CluedIn-io/chore/merge-release-4.1.1-to-develop
• 8b8b104 Merge branch 'release/4.1.1' into chore/merge-release-4.1.1-to-develop
• 8a24ea8 fix: Handle vocabulary property names being sanitized to the same names (#126)

See More

• e378761 Merge remote-tracking branch 'origin/release/4.1.1' into develop

This list of changes was auto generated.

v4.1.1

Features

• Allow user to optionally configure connection pool size.

Fixes

• Fix issue where entity type properties were not serialized correctly

Changes:

• e30ae84 Merge branch 'release/4.1.1'
• c57b861 fix: Add case for manually serializing entity type values (#127)
• 072cf42 fix: Handle vocabulary property names being sanitized to the same names (#128)
• 87811d4 chore: Add 4.1.1 release notes (#125)
• c66c61b feat: Make Connection pool size configurable (#124)
• 0562605 Merge pull request #123 from CluedIn-io/master

This list of changes was auto generated.

v4.1.0

Chores

• Execute all upsert of entity in a single query, for improved performance

Fixes

• Set max of 101 characters for container name, to avoid auxiliary table names being too long.
• Format all date and datetime properties to ISO8601 format.

Changes:

• 86dac83 Merge branch 'release/4.1.0'
• 8a49af4 chore: Add 4.1.0 release notes (#122)
• 6a4ea2b chore: Update README.md (#120)
• e717510 chore: Bump next GitVersion version (#117)
• 8694d3d fix: Specifically format DateTime and DateTimeOffset properties (#115)
• 0cf7e79 Merge pull request #114 from CluedIn-io/master
• 19c0eed chore: Merge release to develop (#111)
• 7a9a7c5 fix: Set max of 101 characters for main table name, to leave enough space for suffixes (#108)
• 07cc892 chore: Refactor store queries, to be executed in single command (#106)
• a70fc46 chore: Merge release to develop (#107)

This list of changes was auto generated.

v4.0.0

Features

• React to new setting in platform, ditating whether to stream edge properties or not.

Chores

• Updated to .NET6
• Disable MARS (multiple active result sets).
  This is to mirror change in platform, and to improve performance.

Fixes

• Prepend tablename with underscore, if it starts with a digit, since table names cannot start with digits in mssql.
• Cap length column names, and append hash value of name, to ensure uniqueness

Changes:

• b987ded Merge branch 'release/4.0.0'
• ecc7902 Merge remote-tracking branch 'origin/master' into release/4.0.0
• 75bb604 chore: Update references (#113)
• dc69866 chore: Update the readme file (#112)
• ba46fd7 chore: Add index for EntityId in edge properties tables (#110)
• 69352e0 fix: Set max of 101 characters for main table name, to leave enough space for suffixes (#109)
• 11e6946 feat: Use option for streaming edge properties (#103)
• 0cd225b fix: Cap length of column name (#104)
• d40aba1 chore: Add 4.0.0 release notes (#105)
• da2c666 fix: Prepend table names starting with digit (#102)

See More

• 207f497 fix: Explicitly dispose readers (#101)
• 58304fe chore: Disable multiple active result sets in connection string (#100)
• b7f2cff Merge branch 'support/3.7' into develop
• 3113473 feat: Update to .NET 6 (#98)
• 28ffd2e chore: Clean up build
• 7e0cedd chore: Bump version to next major
• f4bae2b chore: Update platform dependencies
• 55c0776 chore: Update to .NET 6
• 8326222 Merge branch 'master' into develop
• 26570e4 Merge branch 'release/3.7.0' into develop

This list of changes was auto generated.

v3.7.1

Features

• Introduce new column on code table IsDataPartOriginEntityCode

  IsDataPartOriginEntityCode indicates whether the code is the origin entity code in any dataparts, of the entity.
  No action is required to upgrade to this version, but certain actions can be taken to populate the column with values faster then it otherwise would.
  See: UpgradeNotes/3.7.1/3.7.1-upgrade-notes.md

Changes:

• 0dc1e77 Merge branch 'support/3.7'
• 27c7aad feat: Add IsDataPartOriginEntityCode column on code table (#99)

This list of changes was auto generated.

Release

3.7.0 introduces a new schema, that will support more data to be exported, and make it easier to run quries related to edges.

Features

• Introduce new schema

  • Main table now always contains persist version.
  • Code table is unchanged.
  • Edge table has been replaced by two tables, one for outgoing edges, and one for incoming edges.
    Edge tables now contains Id of edge, id of entity it belongs to, edge type and either ToCode (for outgoing edges) or FromCode (for incoming edges)
  • Edge properties tables have been introduced, which will contain the properties on outgoing and incoming edges respectivly.
    The edge properties tables will the id of the edge they belong to, the name of the key, and the value of the property.

• Export will use custom table types
  All export of multirow data (code, edge and edge properties) will make use of custom table typed parameters.
  This is to ensure that an arbitrary amount of rows can be inserted, instead of being limited by the maximum about of parameters supported by sql (2100).

Upgrade story

In order to upgrade to this version of the connector, if you already have a running stream using an earlier verion,
do the following for all streams using the connector:

• Disable the stream
• Upgrade the connector (ie. the nuget package)
• Reprocess the stream
• Reenable the stream

This will result in the existing tables being arhived, and new tables being created.
These tables will be empty, so everything will need to be exported anew, to populate the tables again.
If you have not reprocessed the stream, an error will be logged, providing instructions to do the upgrade.

For more detailed upgrade notes, including screenshots, see 3.7.0-upgrade-notes.md

Changes:

• b4aed84 Merge branch 'release/3.7.0'
• ed9d0fe Merge branch 'develop' into release/3.7.0
• c08d0bd Merge branch 'master' into develop
• a39c53e chore: Remove dependency on connector common (#97)
• 4842121 chore: Add entity id to edge properties table (#96)
• a882cb6 fix: Set correct column types in event mode (#95)
• d324dc3 chore: Add upgrade notes for release 3.7.0 (#94)
• a6167fb Merge pull request #93 from CluedIn-io/release/3.7.0
• 96f3ad3 Merge pull request #92 from CluedIn-io/chore/merge-develop-to-release370
• a7fc334 Merge branch 'develop' into chore/merge-develop-to-release370

See More

• d46ab71 chore: Remove wrong reading of row (#89)
• 623684d chore: Use simpler command for syncing edges, when none is present (#88)
• 228b097 fix: Filter out default columns from properties (#87)
• 82ff91e Merge pull request #90 from CluedIn-io/chore/revert-reverts
• 26b8296 Revert "Revert "fix: Rework VerifyExistingContainer, to log exception if table is incompatible (#82)""
• e7d1e6a Revert "Revert "feat: Throw exception if old table exists (#78)""
• 6783708 Revert "feat: Throw exception if old table exists (#78)"
• 0991c61 Revert "fix: Rework VerifyExistingContainer, to log exception if table is incompatible (#82)"
• 18a67cc chore: Add release notes for 3.7.0 (#85)
• 1a24b8f fix: Rework VerifyExistingContainer, to log exception if table is incompatible (#82)
• 87299cf chore: Change EntityType column type to NVARCHAR(1024) (#84)
• 2da02ca fix: Add index on entity id in edge tables (#83)
• aa052a8 feat: Throw exception if old table exists (#81)
• c657c82 chore: Simplify passing of timestamp (#80)
• de16b52 chore: Simplify passing of timestamp (#79)
• 019b0a5 feat: Throw exception if old table exists (#78)
• 009b4a4 feat: Implement IConnectorV2 (#77)

This list of changes was auto generated.

Release

Features

• Supports CluedIn 3.5.3

Fixes

• Fixes unnecessary SQL permission grants causing create container to fail with a restricted write user

Changes:

• e1371f1 Merge branch 'release/3.6.0'
• c34677b fix: Remove grants execution on created type
• e911690 chore: Grant reference and view permissions on CodeTableType (#75)
• 7db3131 Merge branch 'master' into develop
• 46c7f2d Merge pull request #74 from CluedIn-io/release/3.5.3

This list of changes was auto generated.

Release

Features

• Supports CluedIn 3.5.3

Changes:

• f23b717 Merge branch 'release/3.5.3'
• d6a71bf chore: Update Common connector reference to 3.5.3 (#73)
• e45c02e Merge branch 'master' into develop
• d1ea009 Merge pull request #72 from CluedIn-io/release/3.4.0

This list of changes was auto generated.