Azure Synapse projects can use direct connect to reverse engineer entire schemas in seconds. Please refer to the instructions below to configure and perform a direct connection to your Azure account.
Direct Connect
To establish a direct connection to Azure Synapse the next details are required:
A named service account
Server: e.g., https://accout.region.redshift.amazonaws.com
Username
Password
Required permissions:
To perform this action, your user needs to be a member of the db_ddladmin role on the source database.
Using these details, follow the highlighted steps to establish the connection (or get more details in the related articles at the end of this post):
Navigate to the Reverse Engineering screen
Click the "Connect to DW" button
Enter the server details from the section above
Select the user type
Enter the credentials from the section above
Connect and select the schema to import
IP allowlisting and private networking
Corporate networking and security policies may interfere with connectivity between SqlDBM and Azure. If you are unable to connect despite following the guidelines in this article, please make sure that IP blocking or private networking is not interfering.
An easy way to diagnose this type of issue is by attempting to connect to your Azure account from a home computer, without using a VPN or any corporate software.
For instructions on allowing SqlDBM through the firewall or private network, please see the related article at the bottom of this page.