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 24 days ago
    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

    ------------------------------
    Conference-AXUG_200x200


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

    GOLD CONTRIBUTOR
    Posted 23 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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

    Posted 21 days ago
    Thank you Gilbert !!

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

    Conference-AXUG_200x200


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

    Posted 21 days ago
    Hi Gokul,

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

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

    Conference-AXUG_200x200


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

    SILVER CONTRIBUTOR
    Posted 14 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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

    Posted 14 days ago
    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
    ------------------------------

    Conference-AXUG_200x200


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