Use the tables from external DB , and bound to grid

Finance and Operations/AX Developer Forum
1

Hi all,

I want to use tables from an external database and bind them to a GridView control to display the data.

Is it possible to use a database other than AXDB? I know we can perform CRUD operations using SqlConnection, but I want to integrate the external database throughout the entire application.

2

You can’t bind grid to a table that doesn’t exist in AOT. What you can do is creating a temporary table in AX, populate it with data from another database and use this temporary table in a form.

By the way, which version of AX are you using?

3

You can use SqlConnection (or any other database provider like OleDbConnection or OracleConnection) to connect to your external database. Make sure the external database is accessible and that you have the necessary credentials to connect to it.

4

Thanks!
Currently working on Dynamics 365 FO

5

it means we have to create the table , if want to use the as datasource for Query, form etc…Correct?

6

Yes, you indeed need a table. You can’t have a data source without a table. Try to create such a data source and you’ll quickly see that.

7

Thanks, @MartinDrab, for your guidance.