microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets

DataSourceName Parameter is not working while configuring CDM util Function App

Open
#255 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Jupyter Notebook
Stars
494
Forks
296
Avg merge
1d 10h
Merged PRs (30d)
5

Description

I was able to setup CDM util Function App and blob storage event is also being triggered when a table is activated in D365.
In Application settings I am using SynapseExternalTable as DDL Type. SQLEndPoint setting is also working fine.

Problem arises at configuring DataSourceName. DataSourceName doesn't seems to be working. Synapse External Tables created are using default External Data source name which is using default database scoped credentials. My requirement is to use an existing Data Source which I am explicitly passing.

image

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the CDM util Function App's Application settings and the DataSourceName handling used when Synapse External Tables are created. Reproduce the setup with SynapseExternalTable as the DDL Type and compare the generated external data source with the explicitly configured existing source. Done means DataSourceName is honored instead of the default database-scoped-credential source.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
cloud, data-engineering, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.