Add a connection to Microsoft Dynamics 365 about dbeaver HOT 5 OPEN

Thank you for request

from dbeaver.

@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

from dbeaver.

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

from dbeaver.

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.

from dbeaver.

@dane-stevens if the connection doesn't work, then you might need to change the default navigator?
I've set it to firefox, then the authentication worked

from dbeaver.