Connect Visual Paradigm to Microsoft Fabric Lakehouse

Visual Paradigm support connect to Microsoft Fabric Lakehouse to perform database engineering. In this article you will learn how to establish connection with Microsoft Fabric Lakehouse.

To connection to Microsoft Fabric Lakehouse:

1. Download Msal4j libraries form Maven.

   <!-- https://mvnrepository.com/artifact/com.microsoft.azure/msal4j -->
   <dependency>
       <groupId>com.microsoft.azure</groupId>
       <artifactId>msal4j</artifactId>
       <version>1.17.2</version>
   </dependency>

2. Login to Microsoft Fabric and select OneLake data hub.
   

   Open OneLake Data Hub in Microsoft Fabric

3. Open your Lakehouse.
   

   Open your Lakehouse

4. Copy the SQL connection string.
   

   Copy Connection String

5. Go to Visual Paradigm desktop application.
6. Select Tools > DB > Database Configuration.
   

   Open Visual Paradigm’s Database Configuration

7. Select MS SQL Server.
   

   Select MS SQL Server

8. Change the Driver to MS SQL Server 2005 (Microsoft Driver).
   

   Switch to use Microsoft JDBC driver

9. Press the … button next to Driver file field, and select all jar files we previously download.
   

   Select all driver files downloaded from Maven

10. Switch to manual connection URL and replace the following:
    

    Switch to manual connection URL

    Original	New Value
    <host_name>:<port_number>	Connection string copied from Fabric
    <database_name>	Name of the Lakehouse (i.e. “Test” as in the example)

11. Add “;authentication=ActiveDirectoryPassword” to the end of the URL.
    

    Add authentication parameter to connection URL

12. Enter your login ID and password.
13. Press Test Connection button to try out the connection setting.

Once the connection successfully configured then you can perform database engineering with Microsoft Fabric Lakehouse with Visual Paradigm as usual.

Visual Paradigm connected to Microsoft Fabric Lakehouse