Follow

Using Synapse Serverless as a datasource in TimeXtender

When connecting to Synapse Serverless as an ODX data source using CDS SQL Server provider, the Synch and Transfer tasks, Preview and transfer to MDW work as expected.

This article describes an issue when using a Business Unit data source.

Symptoms

You are attempting to connect to Synapse Serverless as a Business Unit data source using a SQL Server provider. When synchronizing, you receive the following error:

FUNCTION 'OBJECT_SCHEMA_NAME' is not supported. 
Module: .Net SqlClient Data Provider 
System.Data.SqlClient.SqlException 

Also, if the source view is modified (e.g. exclude some fields), the existing table in the Business Unit is not updated properly.

Cause

The problem is due to extracting Synonyms.  By default, it is turned ON in data source settings.

Resolution

Go to SQL Server data source settings

Click on "Data Extraction Settings"

Uncheck "Extract synonyms".

Sync and Preview should now work without error. 

Also, if you remove some fields from the source view, it will reflect those changes in your data source and staging table as well.

Additional Information

Another workaround is to use  ADO.Net SqlClient provider for your data source.  You may see a minor error when previewing rows in Data Selection, but transfer to stage (Deploy and Execute) works OK.

Also, if you remove some fields from the source view, the next "Synchronize Data Source" will reflect those changes in your data source and staging table as well.

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.