User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

MDM 14.3.0 Upgrade Notes

MS SQL Server driver change

Applies only to MS SQL database users.

We upgraded the Microsoft JDBC Driver for SQL Server MS SQL to version 10.2 (for details, see MS SQL Server Driver 10.2 Release Notes). Therefore, in case you use an MS SQL database and do not use encryption or certificates, you need to update the value of the properties that contain the URL to the database.

Depending on the configuration of your project, this property is defined either in the application.properties file or runtimeConfig file.

  • application.properties

  • mdm.runtimeConfig

If the datasource connection is defined in the application.properties file, the property name is ataccama.one.mdm.datasource.<data_source_name>.url. Make sure to change the property value as needed:

application.properties example (14.3.0 and later)
ataccama.one.mdm.datasource.<data_source_name>.url=jdbc:sqlserver://<host>:<port>;databaseName=<database_name>;encrypt=true;trustServerCertificate=true

If the datasource connection is defined in the runtimeConfig file, the definition looks as follows:

mdm.runtimeConfig example (before 14.3.0)
<dataSource driverclassName=.microsoft.sqlserver.jdbc. name="<data_source_name>" user="<user_name>" password="<password>" url="jdbc:sqlserver://<host>:<port>;databaseName=<database_name>/>

You need to change the value as needed:

runtimeConfig.xml example (14.3.0 and later)
<dataSource driverclassName=.microsoft.sqlserver.jdbc. name="<data_source_name>" user="<user_name>" password="<password>" url="jdbc:sqlserver://<host>:<port>;databaseName=<database_name>;encrypt=true;trustServerCertificate=true"/>

Configuration Changelog

This section provides the information about the changes in the configuration files that need to be taken into account when upgrading the solution. In certain cases, the newly introduced default is used or some configuration is required.

The following table lists the configuration files that were added, changed, or removed.

Added files Changed files Removed files

/

  • MDM Server application.properties

  • xxx.runtimeConfig

  • xxx.serverConfig

Files generated by MDM model project are not listed here.

/

The following table lists the changes in the files: added, changed, and removed properties.

Configuration file Added properties Changed properties Removed properties

MDM Server application.properties

Task Configuration (for details, see MDM Server Application Properties, section Task configuration):

  • ataccama.one.mdm.task.automation.enabled - The default value is true.

  • ataccama.one.mdm.task.automation.datasource.name - The default value is eh_db.

  • ataccama.one.mdm.task.automation.datasource.prefix - The default value is tasks_.

  • ataccama.one.mdm.datasource.<data_source_name>.url - If you use MS SQL database, change the value to jdbc:sqlserver://<host>:<port>;databaseName=<database_name>;encrypt=true;trustServerCertificate=true, for more information, see MS SQL Server driver change.

/

xxx.runtimeConfig

/

  • dataSource …​ url="jdbc:sqlserver://<host>:<port>;databaseName=<database_name> - If you use MS SQL database, change the url value to jdbc:sqlserver://<host>:<port>;databaseName=<database_name>;encrypt=true;trustServerCertificate=true, for more information, see MS SQL Server driver change.

/

xxx.serverConfig

/

The recommended configuration was updated to make the solution more secure.
  • Required Role - Used to limit access to the old Admin Center (web application for MDM server). To grant access to admin users, set it to MDM_admin.

    example.serverConfig
    <component listeners="all" disabled="false" cacheTemplate="true" className=.ataccama.dqc.web.console. requiredRole="MDM_admin">
              <customMenuCategories/>
              <customMenuItems/>
    </component>

/

Was this page useful?