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. Copy the downloaded libraries to a specific folder.
   

   Copy downloaded libraries to a folder

3. Download the Microsoft SQL Server JDBC Driver.
   

   Download Microsoft SQL Server JDBC driver

4. Unzip the downloaded file, and copy the JDBC Driver to the folder containing the Msal4J libraries we previously downloaded.
   

   Copy JDBC driver to the folder containing Msal4J libraries

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

   Open OneLake Data Hub in Microsoft Fabric

6. Open your Lakehouse.
   

   Open your Lakehouse

7. Copy the SQL connection string.
   

   Copy Connection String

8. Go to Visual Paradigm desktop application.
9. Select Tools > DB > Database Configuration.
   

   Open Visual Paradigm’s Database Configuration

10. Select MS SQL Server.
    

    Select MS SQL Server

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

    Switch to use Microsoft JDBC driver

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

    Select all driver files downloaded from Maven

13. 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)

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

    Add authentication parameter to connection URL

15. Enter your login ID and password.
16. 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