Add a connection to Microsoft Dynamics 365

[Schmlughtz007]

Today I was able to connect using SQL Server connection to Microsoft Dynamics 365 (on the cloud)
The table access is working fine, I can see the data in DBeaver.

Unfortunately I cannot see the relationships between tables in an ER Diagram.
The error being :
SQL Error [40000] [S0001]: "Invalid table name key_constraints for schema sys. Line:2, Position:1"
RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158
Time: 2024-05-14T15:28:29.6013407Z
"Invalid table name key_constraints for schema sys. Line:2, Position:1"
RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158
Time: 2024-05-14T15:28:29.6013407Z
"Invalid table name key_constraints for schema sys. Line:2, Position:1"
RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158
Time: 2024-05-14T15:28:29.6013407Z

It would be really good to have DBeaver connect to Microsoft Dynamics and be able to generate an ERDiagram (obviously not by using
Obviously there would be a need to sys.key_constraints

[E1izabeth]

Thank you for request

[Schmlughtz007]

@E1izabeth do you have any idea if this feature request would be implemented and if yes when?
I can support with any beta testing you might need

[E1izabeth]

I can't give any estimations. Currently this ticket is not planned to any milestone.

[dane-stevens]

Today I was able to connect using SQL Server connection to Microsoft Dynamics 365 (on the cloud) The table access is working fine, I can see the data in DBeaver.

Unfortunately I cannot see the relationships between tables in an ER Diagram. The error being : SQL Error [40000] [S0001]: "Invalid table name key_constraints for schema sys. Line:2, Position:1" RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158 Time: 2024-05-14T15:28:29.6013407Z "Invalid table name key_constraints for schema sys. Line:2, Position:1" RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158 Time: 2024-05-14T15:28:29.6013407Z "Invalid table name key_constraints for schema sys. Line:2, Position:1" RequestId: TDS;d7c2dbc5-9e1d-4071-b8f6-31b9e09881ef;158 Time: 2024-05-14T15:28:29.6013407Z

It would be really good to have DBeaver connect to Microsoft Dynamics and be able to generate an ERDiagram (obviously not by using Obviously there would be a need to sys.key_constraints

How were you able to connect? I can't seem to get the connection to work.