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

SynapseToSQL_ADF - Steps 4

Open
#89 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

https://github.com/microsoft/Dynamics-365-FastTrack-Implementation-Assets/blob/0f8769074e1c1bab26ad45efe36b5cdb1db91066/Analytics/SynapseToSQL_ADF/readme.md#steps

4 - Run Console Application and create views for Tables (in dbo schema) and ChangeFeed files( CDC schema)

To be more precise;
Console Application requires to be run twice one for Table views and one for ChangeFeed views with using related parameters in CDMUtil_ConsoleApp.dll.config.

The initial run - Tables with CDMUtil_ConsoleApp.dll.config having below params;
ManifestFilePath -> "/Tables/Tables.manifest.cdm.json"
ManifestURL -> "https://YourStorageAccount.blob.core.windows.net/dynamics365-financeandoperations/YourEnvironment.sandbox.operations.dynamics.com/Tables/Tables.manifest.cdm.json"
Schema -> "dbo"

And the second run - ChangeFeed with CDMUtil_ConsoleApp.dll.config having below parameters;
ManifestFilePath -> "/ChangeFeed/ChangeFeed.manifest.cdm.json"
ManifestURL -> "https://YourStorageAccount.blob.core.windows.net/dynamics365-financeandoperations/YourEnvironment.sandbox.operations.dynamics.com/ChangeFeed/ChangeFeed.manifest.cdm.json"
Schema -> "CDC"

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 linked Analytics/SynapseToSQL_ADF/readme.md section for Step 4 and review the CDMUtil_ConsoleApp.dll.config parameters described in the issue. Done means the documentation clearly explains the two runs, the Tables and ChangeFeed manifest paths and URLs, and their dbo and CDC schemas.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
cloud, data-engineering, documentation
Issue type
Documentation
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.