Target solution environment
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. Target solution environment

      Microsoft Fabric Stage JDBC - Target environment

      This article proposes a possible target environment for Microsoft Fabric Stage JDBC generator.

      Installation and configuration of the target environment are not part of biGENIUS support.

      Unfortunately, we won't be able to provide any help beyond this example in this article.

      Many other configurations and installations are possible for a Microsoft Fabric Stage JDBC target environment.

      Below is a possible target environment setup for a Microsoft Fabric Stage JDBC generator.

      The Property Target Platform should be set to the Fabric value:

      Setup environment

      You should have access to a Microsoft Fabric target environment:

       

      You should also have access to an Azure DevOps git repository to later activate the git integration. 

      Enter the Synapse Data Engineering section:

      The Synapse Data Engineering section is displayed:

      Create a Workspace

      Click on the Workspace entry in the left menu, then on + New workspace:

      In this example, we will create a Workspace named bgfabricstagejdbc.

      Fill in the name and click on the Apply button:

      Now click on the Workspace settings menu to configure the git integration:

      Choose the Git integration entry in the left menu:

      Connect to your Azure DevOps git repository, then click on the Connect and sync button:

      Source Data

      The source data are coming from a JDBC source.

      In this example, we will use a Microsoft SQL Server database stored in Azure in a dedicated resource group:

      The Azure database is AdventureWorks2019 and contains the data from the SQL Server sample database AdventureWorks2019.

      To be able to access the Microsoft SQL Server from Microsoft Fabric, you should check the box Allow Azure services and resources to access this server in the Server Networking configuration:

      Upload Artifacts in Microsoft Fabric

      As your source was not a file, you should add the source schema name before the source Model Object Name in biGENIUS-X, Dataflow Modeling overview. 

      Transform CreditCard in Sales.CreditCard, for example.

      Please now upload the generated Artifacts from the biGENIUS-X application to the Microsoft Fabric Workspace.

      Please replace the placeholders before uploading the artifacts.

      • Click on the Workspace we just created in the left menu:
      • Click on the Import button and choose Notebook then From this computer:
      • Click on the Upload button:
      • Select all the generated artifacts from the folders Jupyter, Helpers, and LoadControl:
      • Import, in addition, the following helper:

      In the file 500_Deploy_and_Load_DataVault_Fabric.ipynb, adapt the name of the XXX_Deployment, the XXX_SimpleLoadexecution, the XXX_MultithreadingLoadExecution, and the XXX_SelectResults by the name of your Helper files.

      • Commit all the changes into your git repository by:
        • Clicking on the Source control menu:
        • Selecting all the changes
        • Clicking on the Commit button:


      Depending on your load control environment:

       

      You're now ready to deploy these artifacts and subsequently load the data based on the Generator you are using with the following possible load controls: