D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Connecting to External Database through AX 365

  • 1.  Connecting to External Database through AX 365

    Posted Sep 23, 2019 05:31 AM
    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

    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Connecting to External Database through AX 365

    GOLD CONTRIBUTOR
    Posted Sep 23, 2019 12:30 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Connecting to External Database through AX 365

    Posted Sep 25, 2019 12:26 PM
    Thank you Gilbert !!

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

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Connecting to External Database through AX 365

    Posted Sep 25, 2019 05:52 PM
    Hi Gokul,

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

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

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Connecting to External Database through AX 365

    GOLD CONTRIBUTOR
    Posted Oct 02, 2019 02:06 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Connecting to External Database through AX 365

    Posted Oct 02, 2019 02:24 PM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role