Can we access Production SQL DB ?

(0) Share

Report

Posted on by VoltesDev

Hi everyone,

Just need some confirmation, when F&O (Cloud based, not On Premise) is in Production, and so we can say it's "Went Live", Can our IT reach or connect to its database ? Lets say by using SQL Management Studio or even to use it as a source of Azure Data Factory stuff ?

Haven't experience a real project Go Live before, so it is kinda in the 'myst' for me, as currently I still can access the Azure SQL DB through SSMS, even we have create a scenario whereby we transfer data from Azure SQL DB which is actually the database of our F&O (still in development phase), with Azure Data Factory to pull data to ADLS.

So the confusion is, if we can't reach/connect to that Azure SQL DB when F&O went Live, this scenario is useless, am I correct to say that ?

Kindly advice,

Thanks,

All responses (13)

Answers (0)

Sukrut Parab 71,682 Moderator on at

Like (0)

Report

RE: Can we access Production SQL DB ?

As a part of export to ADLS feature which is in preview and not available currently in all regions , you should be able to export table data directly to data lake . Now for the customers who are using entity store or BYOD for their reporting requirements there is going to be transition path where they can provision their entity store and BYOD in data lake as it is so that what they have is not disturb and eventually transitioned to the new method.

If you are using entity store already in production for BI reporting then only thing you can try now is sign up for future preview and experiment with it . Details to sign up for future preview are given in the below link.

docs.microsoft.com/.../configure-export-data-lake

IF you are in the implementation process , you have option of using entity store or BYOD for reporting requirements and use those as your datasource and eventually transitioned when new features becomes available
VoltesDev on at

Like (0)

Report

RE: Can we access Production SQL DB ?

Hi Andre,

Yes, it is mainly for BI, so what we want to transfer or copy is Data entities. So the main issue here is actually whether we should start to use the ADLS integration and trickle feed options (although it is still on Public Preview), or using AzureDF and using the AX Data Connector as Sukrut mentioned, as that is the only options to get data from Production DB.

Or is it actually the same thing by means ADLS Integration inside F&O is actually just "a custom UI" which doing the same thing, transferring Data entities just like what Azure DF did ?

Thanks,
Martin Dráb 233,017 Most Valuable Professional on at

Like (0)

Report

RE: Can we access Production SQL DB ?

You surely can use Azure DF if you want, you just can't meddle with the production database, bypass all security and so on. You can use things like BYOD to export data you need and use this database as your data source.
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: Can we access Production SQL DB ?

Hi Voltes,

Can you provide information about what information you want to access and for what purpose? The future direction would be moving data to ADLS. Part of OData slowness is caused by the number of tables and x++ coding on data entities. Microsoft is investing in the option to move table contents to Azure Data Lake and then use e.g. Spark or Synapse to format the data for e.g. BI insights.
VoltesDev on at

Like (0)

Report

RE: Can we access Production SQL DB ?

Hi Sukrut,

You type as the same time as me. Well if OData, it is then make sense. I take a quick look on the link you provided. Bottom line is cannot access Production DB, but can with OData, one problem is only I think OData is slow. But of course, you cannot have everything.

Thank you guys for all this insights
VoltesDev on at

Like (0)

Report

RE: Can we access Production SQL DB ?

Hi Martin,

Noted that. It is just the ADLS integration is not reliable yet, I means it is still under Public Preview now and being pushed several time. Also because Azure DF has several advantage which is they have the Dataflow and transformation tools inside in which BYOD, even the ADLS integration cannot support.

I think that is my concern on why even with Azure DF, we're unable to retrieve data from Production SQL DB. Still what we access is Data entities, which is build for this integration, it is not retrieve data directly to F&O tables. Even OData can retrieve that as it is public artifact.

Thanks,
Sukrut Parab 71,682 Moderator on at

Like (0)

Report

RE: Can we access Production SQL DB ?

I didn't try using ADF connector mentioned in the below article but the ADF connector supports pulling data from D365 FO . The article mentions that its in preview state. However exporting data to BYOD or data lake should fulfill your reporting requirements .

docs.microsoft.com/.../connector-dynamics-ax

azure.microsoft.com/.../
Martin Dráb 233,017 Most Valuable Professional on at

Like (0)

Report

RE: Can we access Production SQL DB ?

The problem isn't in tools, but in permissions. The database is managed by Microsoft and they would explicitly allow you to connect (which they won't).

I don't know what you're trying to achieve, but it's possible the Data Lake or BYOD will help you with that.
VoltesDev on at

Like (0)

Report

RE: Can we access Production SQL DB ?

So, is that why for F&O we have the "Enable Data Lake Integration" feature?

Or at least using BYOD for the transfer to Data Lake ?

But actually I'm still curios on how or why Azure Data Factory cannot access Dynamics F&O Production, since it supposed to be a universal tools for Cloud Datawarehouse. I'm not sure this the correct forum, but since it is F&O I think it is still applicable.

Thanks.
HenryXie on at

Like (0)

Report

RE: Can we access Production SQL DB ?

Hi VoltesDev, for F&O production environment there is no way to access directly, DBA can monitor the DTU\ index fragment and kill process etc. via LCS.