How to query database on cloud based solution

(0) Share

Report

Posted on by AdamDavis

Hi we are upgrading our version of dynamics.

i understand the next version to be a cloud based solution that does not allow database access.

my question is , how can I query the data within the database going forward post the upgrade.

thank you

All responses (7)

Answers (1)

AdamDavis 20 on at

Like (0)

Report

RE: How to query database on cloud based solution

Thank you
Verified answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (1)

Report

RE: How to query database on cloud based solution

Hi,

Data export service provided by microsoft will help you replicate CRM online data to azure sql database which can later be used for Analytics, BI and Upgrade data migration validation.

Please find below blog which has step by step tutorial to setup this.

docs.microsoft.com/.../replicate-data-microsoft-azure-sql-database
Suggested answer

AJ-22040756-0 on at

Like (0)

Report

RE: How to query database on cloud based solution

Hi Partner

Yes this should work for online dynamics CRM environment
AdamDavis 20 on at

Like (0)

Report

RE: How to query database on cloud based solution

Sorry to ask silly questions , I’m not techie !
AdamDavis 20 on at

Like (0)

Report

RE: How to query database on cloud based solution

Ok thank you , so this will work on cloud based crm dynamics ?
Suggested answer

AJ-22040756-0 on at

Like (2)

Report

RE: How to query database on cloud based solution

Hi Partner

Userss can directly query the data by connecting online database.

Users will have read access to the data.

It is still a preview feature : https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query
AdamDavis 20 on at

Like (0)

Report

RE: How to query database on cloud based solution

Sorry in the question is ambiguous, I have limited information at this time.