Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Can we access Producti...
Finance forum
Unanswered

Can we access Production SQL DB ?

Posted on by

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,

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,643 Moderator on at
    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 Profile Picture
    VoltesDev on at
    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 Profile Picture
    Martin Dráb 225,490 Super User on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    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 Profile Picture
    VoltesDev on at
    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 Profile Picture
    VoltesDev on at
    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 Profile Picture
    Sukrut Parab 71,643 Moderator on at
    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 Profile Picture
    Martin Dráb 225,490 Super User on at
    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 Profile Picture
    VoltesDev on at
    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 Profile Picture
    HenryXie on at
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans