Release Notes

Back Next

Microsoft Azure Synapse Analytics Database Ingestion

Known issues

The following table describes known issues:

Issue	Description
DBMI-19405	Tests of a Microsoft Azure Synapse Analytics Database Ingestion connection for an application ingestion and replication task or database ingestion and replication task fail with the following error if the user name specified in the connection properties includes a special character such as @ and the target database uses AAD authentication: Cannot instantiate datasource because of error: Failed to initialize pool: Cannot open server 'noconline.onmicrosoft.com' requested by the login. The login failed. ClientConnectionId: <identifier> This problem occurs because the Synapse Analytics connector package is missing some .jar files that are required to connect to the target database in this situation. Workaround: Copy the following jars to the connector package: activation-1.1 adal4j-1.4.0 jcip-annotations-1.0-1 json-smart-1.3.1 mail-1.4.7 nimbus-jose-jwt-9.40 oauth2-oidc-sdk-5.24.1 The package location is: package-AzureDWGen2MI.xxx\package\dw\thirdparty\informatica.azuredwgen2mi (August 2024)

Issue

Description

DBMI-19405

Tests of a Microsoft Azure Synapse Analytics Database Ingestion connection for an application ingestion and replication task or database ingestion and replication task fail with the following error if the user name specified in the connection properties includes a special character such as @ and the target database uses AAD authentication:

Cannot instantiate datasource because of error: Failed to initialize pool: Cannot open server 'noconline.onmicrosoft.com' requested by the login. The login failed. ClientConnectionId: <identifier>

This problem occurs because the Synapse Analytics connector package is missing some .jar files that are required to connect to the target database in this situation.

Workaround: Copy the following jars to the connector package:

activation-1.1

adal4j-1.4.0

jcip-annotations-1.0-1

json-smart-1.3.1

mail-1.4.7

nimbus-jose-jwt-9.40

oauth2-oidc-sdk-5.24.1

The package location is:

package-AzureDWGen2MI.xxx\package\dw\thirdparty\informatica.azuredwgen2mi

(August 2024)

Connector and connectivity issues