Unable to create View in Azure synapses using CDMUtil_ConsoleApp

Question

Unable to create View in Azure synapses using CDMUtil_ConsoleApp

Athira Reghuraman 20

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

PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-13T06:12:35.3266667+00:00

Hello @Athira Reghuraman, Thanks for the question and using MS Q&A platform.

As per the error related to the use of CREATE DATABASE SCOPED CREDENTIAL, you may need to ensure that you are running the script in the correct database. For example, if you are encountering an error related to the master database, you may need to ensure that you are running the script in the target database instead.
Athira Reghuraman 20 Reputation points

2023-03-13T19:48:30.0333333+00:00

@PRADEEPCHEEKATLA-MSFT , Thankyou for your response .

I am new to this area .And I am using a an serverless SQL pool Connection strings as 'TargetDbConnectionString' , could you please let me know how can I get the targetbase instead .
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-15T06:44:22.9466667+00:00

Hello @Athira Reghuraman,

Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,
PRADEEPCHEEKATLA-MSFT

PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-13T06:12:35.3266667+00:00

Hello @Athira Reghuraman, Thanks for the question and using MS Q&A platform.

As per the error related to the use of CREATE DATABASE SCOPED CREDENTIAL, you may need to ensure that you are running the script in the correct database. For example, if you are encountering an error related to the master database, you may need to ensure that you are running the script in the target database instead.
Athira Reghuraman 20 Reputation points

2023-03-13T19:48:30.0333333+00:00

@PRADEEPCHEEKATLA-MSFT , Thankyou for your response .

I am new to this area .And I am using a an serverless SQL pool Connection strings as 'TargetDbConnectionString' , could you please let me know how can I get the targetbase instead .
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-15T06:44:22.9466667+00:00

Hello @Athira Reghuraman,

Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,
PRADEEPCHEEKATLA-MSFT

Answer 1

PRADEEPCHEEKATLA-MSFT 56,301 Microsoft Employee

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.

Athira Reghuraman 20 Reputation points

2023-03-14T12:51:01.8066667+00:00

Thank you @PRADEEPCHEEKATLA-MSFT for the response . It worked and I am able to create the view . Is there any way to create a table and copy data from view to the table . I want to do this on n number for views .
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-15T06:45:03.87+00:00

Hello @Athira Reghuraman,

The scope of your question is different compared to the original scope of the question asked.

I would recommend creating a new thread on the same forum with as much details about your issue as possible. That would make sure that your issue has better visibility in the community.

Unable to create View in Azure synapses using CDMUtil_ConsoleApp

0 additional answers

Activity