Supply chain | Supply Chain Management, Commerce

ODBC connection on an D365 on-Premise

(0) Share

Report

Posted on by Cembrit

We do have a D365 on-premise installation and need to connect to an external Database to read and write data over classes.
How can I create ODBC connections in an on-prem installation?

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Cembrit,

Please refer to this :

https://docs.to-increase.com/d365fo/Connectivity%20studio/1.0/en-us/BpmConcept_5637165581.html

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

HI, please refer to the following links to see if it can help:

https://docs.to-increase.com/d365fo/Connectivity%20studio/1.0/en-us/BpmBusinessProcess_5637202326.html

Was this reply helpful? Yes No
Cembrit on at

Like (0)

Report

Thx Mohamed

I found this site before but I do not understand what is needed if I want to read and write over ODBC connection

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Cembrit,

In this case i think you must do a customization and developing.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Cembrit on at

Like (0)

Report

@Mohamed Amine Mahmoudi If I had an idea how I would have done it ;-)

Was this reply helpful? Yes No
Cembrit on at

Like (0)

Report
Sorry to come back to this post but I do not find any option in D365FO to setup a DB connector
WIll it be possible to write SQL Statements like
SQL ="SELECT [accountid],[accountnumber],[ap_AccountTypeName],[ap_Categoryidname],[ap_crmaccountid],[ap_ResponsibleidName],[name],[OwningBusinessUnit] " + "FROM [EDW].[CRM].[CRM365_Account] CRM365Acc " + "where not exists (" + "select * from [EDW].[CRM].[CRM365AX_Account] CRM365AXAcc " + "where CRM365AXAcc.accountid = CRM365Acc.[accountid]) " + "AND CRM365Acc.[ap_AccountTypeName] = 'Customer'";

I really have no clue how to solve this in D365FO (on-premise)

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Cembrit,

Plese refer to this

https://learn.microsoft.com/en-us/dynamicsax-2012/developer/how-to-connect-to-an-external-database-from-x-code

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Cembrit on at

Like (0)

Report

@Mohamed

Thx I did that but do you have any idea how to setup the DSN than. Normally I would set it up with "integrated windows authentication" but if I do so I get an error :

Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: The certificate chain was issued by an authority that is not trusted.
[Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Cembrit,

In SSMS please goto connection properties and click on "Trust server certificated"

Ref :

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19

https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Cembrit on at

Like (0)

Report

Yes I found the option after I posted here but then I get

The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library.

Was this reply helpful? Yes No