Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Gokul G]

Just like we used to connect to external Database through ODBC in AX 2012, is there a way to connect to external database in AX 365 ?

If there is way to connect to external database through AX 365, Kindly share the details on how to achieve the same.

——————————
Gokul Gopalakrishnan

——————————

[Steeve Gilbert]

Simply use the System.Data.SqlClient library just like you would in a standard C# project.
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-code-examples#sqlclient

The “bad” thing is that if you are using D365 cloud, then your external DB needs to be visible to D365, which means being exposed to internet.

——————————
Steeve Gilbert
Software Development Supervisor
Boa-Franc S.E.N.C.
QC, Canada
——————————
——————————————-

[Gokul G]

Thank you Gilbert !!

——————————
Gokul G
ONECECO
——————————
——————————————-

[vishal Dhawgaye]

Hi Gokul,

Check ‘ResultSetHelper’,  ‘ResultSetHelper’ classes in D365. these classes also connecting to external database.

——————————
vishal Dhawgaye
Hitachi Solutions America, Ltd.
——————————
——————————————-

[Chaitanya Golla]

Hi,

If your external database is on Azure then probably you can use BYOD(Bring Your Own Database) feature of D365FO.

Please refer below links for setup and usage:

(Bring Your Own Database(BYOD) in D365FO – Setup) 
https://www.axug.com/blogs/chaitanya-golla/2018/07/26/bring-your-own-database-in-d365fo-setup

(Bring Your Own Database(BYOD) in D365FO – Data entity Publish )
https://www.axug.com/blogs/chaitanya-golla/2018/07/26/bring-your-own-database-in-d365fo-publish-entity

Bring Your Own Database(BYOD) in D365FO – Export data
https://www.axug.com/blogs/chaitanya-golla/2018/07/26/bring-your-own-database-in-d365fo-export-data

——————————
Regards,
Chaitanya Golla
Lead Architect
——————————
——————————————-

[Gokul G]

Hi,

I am already aware about BYOD part. In my case it’s an ON-PREMISE database.

Hence BYOD wont apply over here.

Regards,
Gokul

——————————
Gokul G
ONECECO
——————————
——————————————-