Unable to create View in Azure synapses using CDMUtil_ConsoleApp

Athira Reghuraman 20 Reputation points
2023-03-10T16:32:17.3666667+00:00

I had tried to create a view for D365 F&O data in synapses using CDMUtil_ConsoleApplication.exe to convert the manifest data to DLL . I got stuck with the below error . It has mentioned to create credential in manage identities and CREATE DATABASE SCOPED CREDENTIAL is not supported in master database. Please help on this User's image

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,332 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,195 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,329 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 76,436 Reputation points Microsoft Employee
    2023-03-14T06:46:53.1333333+00:00

    Hello @Athira Reghuraman,

    Thanks for the question and using MS Q&A platform.

    This tutorial - Analyze data with a serverless SQL pool will help you to create a database in the sql serverless pool and then you can create CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL).

    You may checkout the MS Q&A thread addressing similar issue.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful