Microsoft Fabric Stage JDBC - Replace the placeholders - 1.5

The Generated Artifacts zip file contains files with placeholders for the target environment parameters.

You should replace all the placeholders to deploy to Microsoft Fabric Target System.

Replace the Placeholders

A toolkit is provided in the generated artifacts to replace the placeholders.

It is composed of a Powershell script to execute: replace_placeholders.ps1.

The process to follow is:

• Update the replacement_config.json file with your values:
  
  • Insert the value to replace into the value node
• Each database_name is filled by default with the layer name (example: rawvault)
  • It should contain the database name of the target lakehouse
    • In our example, we want to create the target tables in the lakehouse bglakehouse1
• Each database_directory placeholder must be empty, it is not needed for Microsoft Fabric

• JDBC source : please put the values to access the JDBC source data:
  • jdbc_url:
    • In our SQL Server JDBC source example: jdbc:sqlserver://bgsqlserver.database.windows.net:1433;encrypt=true;databaseName={DatabaseName};trustServerCertificate=true;
    • Replace {DatabaseName} by your SQL Server database name
  • jdbc_driver:
    • In our SQL Server JDBC source example: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • jdbc_user: 
    • In our SQL Server JDBC source example: '{DatabaseUser}'
    • Replace {DatabaseUser} by your SQL Server user

• • jdbc_password: 
    • In our SQL Server JDBC source example: '{DatabasePassword}'
    • Replace {DatabasePassword} by your SQL Server password

Depending on your load control environment:

• If you plan to use a native loaded control using multi-threading load, please update the execution_dependencies_file_path placeholder with the path that contains the dependencies file
  • In our example, it is abfss://bgfabricjdbc@onelake.dfs.fabric.microsoft.com/bglakehousejdbc.Lakehouse/Files/Dependencies/

Replace the placeholders in the files:

• Open Windows Powershell (or equivalent) in the replace_placeholders.ps1 location:
  
• Execute the following command :

• .\replace_placeholders.ps1

  • You should have a similar result:
    
• The configured values in all generated artifacts replaced the placeholders
• You can now use these files and deploy your Target system

.\replace_placeholders.ps1 - help

.\replace_placeholders.ps1 -ReplacementConfigPath "C:\TEMP\Replacement config files\replacement_config_