Versions Compared

Old Version 19

changes.mady.by.user Former user

Saved on

compared with

New Version 20

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Active Directory Integrated Authentication option is not available in the GUI

After announcing the release of DaticalDB/Liquibase Enterprise 7.9, we discovered that GUI was missing the option to set the authentication type to Active Directory Integrated for Azure SQL Databases. Underlying functionality that relies on Active Directory Integrated authentication was confirmed to work as expected and this issue is limited to the GUI.

The following workaround can be used if you wish to use the 7.9 release to manage Azure SQL Database resources:

  1. Configure the new DbDef for Azure SQL Database selecting Active Directory Password Authentication as described here: Creating Connections in Datical DB and Azure SQL Database

  2. After saving the DbDef, open the datical.project file in the root directory of project

  3. Update the authentication attribute for the DbDef as shown: authentication="activeDirectoryIntegrated"

The issue will be addressed in our next releaseis fixed in 7.10 (and higher).

Customer Notices for Upgrades

...

Liquibase Enterprise & Business Clients (Datical DB)

Item

Path

File

Software

COMMON/Datical_DB_Software/Datical_DB_7.9.6897

Choose the Linux or Windows installation file for your system. 

Liquibase Enterprise Documentation

COMMON/Datical_Documentation/Datical_DB_Documentation

datical_db_docs_v7.9.pdf

Composite Installation Repository

COMMON/Datical_DB_Software/Datical_DB_7.9.6897

DaticalDbCompositeRepo-7.9.6897.zip

Liquibase Deployment Monitoring Console (DMC)

...

Info

Liquibase Enterprise & Business Clients (Datical DB) and DMC Compatability

Each DMC release only works with certain releases of Liquibase Enterprise & Business Clients (Datical DB).  Consult the Datical DB and Deployment Monitoring Console Compatibility Matrix to ensure compatibility.

Item

Path

File

Software

COMMON/Datical_DMC_Software/Datical_DMC_7.7.197

datical-service-unix-7_7_197-master.sh

DMC Documentation

Online @ dmc.datical.com

<N/A>

Deployment Monitoring Console Update Instructions

...

The NLS_LANG environment variable is used by SQL*Plus & Oracle databases to ensure that script contents are correctly interpreted during execution and that data values are stored appropriately in the database. The NLS_LANG environment variable can now be set on a project by project basis so that users no longer have to set those environment variables outside of their Liquibase Enterprise operations. For more information on setting this project property. For more information see Encoding and Characters in Script Files.

New Change Set Wizard Options for Business & Enterprise Users

We have moved the options for adding SQL scripts to the Changelog to the top of the list of Change Set Wizard options for easier access. We have also added three options for SQL Scripts in the Change Set Wizard.

Option Name

When to Use It

Execute a DML Script with sqlplus for Oracle Databases

This option indicates that the script added to the changelog should be considered for the Oracle DML Forecast feature. The DML Forecast feature will execute the script using sqlpluswithout committing the changes made by it. This can be used prior to deployment of the script to understand the scripts impact. This feature only applies to the Forecast operation for Oracle Databases.

Execute with edbplus for EnterpriseDB Databases

This option should be used to execute SQL scripts with the edbplus client against EnterpriseDB databases

Execute a SQL script file using JDBC

This was formerly the “Custom SQL (External File)” option in the Changeset Wizard. This option indicates that the script should be executed using a JDBC connection instead of an external client like sqlplus or sqlcmd. It’s been renamed to better communicate its purpose.

Recent Notable Changes

(Enterprise & Business 7.6) DATA_DML Package Method Creates Changesets With Oracle SQL Parser Disabled by Default

...

Liquibase Business & Enterprise Issues

Issue ID

Description

DAT-5776

GUI: "Execute with SQLPlus" with Forecast DML doesn't forecast scripts in Resources/sql

DAT-5502

Create "Execute with EDB*Plus" Option in Change Set Wizard

DAT-5340

GUI: ChangelogSync no longer refreshes dbDef status

DAT-5299

Datical install shows application requires a Java Runtime Environment 1.7.0

DAT-5228

UTF-8-BOM file results in Packager error "Unable to detect character encoding for script"

DAT-5178

Ability to specify commit label format eg. WI 999999 instead of [999999]

DAT-5160

Enable setting/resetting NLS_LANG environment variable for each deployment

DAT-4809

Warning message says resync (should be "force sync" button and "forceSync" command)

DAT-4606

Strip out or ignore non-recognized characters (\xa0) from scripts

Deployment Monitoring Console (DMC) Issues

...

Known Issues with Oracle Accelerator

Issue ID

Description

DAT-4808

Packaging with manifest is failing with timeout if oracle accelerator is enabled

DAT-4375

GUI :: Datical Accelerator connection issue