ODBC Connection to an other Database

Hello out there,

I run Dynamics AX on MS-SQL-Server. Is there a possibility to open up an ODBC connection from within X++ to an external Oracle Database to execute PL-SQL commands? If the answer is yes, could you please provide some sample code?

Thank you very much in advance!

You should check out the ODBCConnection class under System documentation\Classes.

(you will notice also the connection class (parent) and the userConnection classes)

You can simple put a search on AOT with text containing the name of the class and you will get a couple of examples at least.

Good luck!