I know you can connect your CRM database from SQL. I also know you can connect your PowerBI to your D365 BC cloud database.
I’m trying to connect my D365 Cloud database to SQL so that I can query the data. However, I’m struggling to get this to work. I can’t seem to get the server name for the Cloud database, similar to how you do it with CRM.
Have you ever done this with F&O or BC?
Am I going about this wrong?
Hi, you might find useful my blog post:
As far as F&O is concerned, there’s no way to directly connect to the production SQL database. If you need to connect via SQL, you’d need to create an external BYOD using Azure SQL and connect to that. The BYOD is typically populated via DIXF entities, so it’s not a 1:1 replacement for direct access to SQL and it’s also asynchronous.
You can use Skyvia to extract data from BC to an SQL database on a schedule, which may solve your reporting needs without direct querying. You can find more info here.