Azure Synapse Stage JDBC - Replace the placeholders - 1.6

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

You should replace all the placeholders to deploy your Azure Synapse Stage JDBC 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 data lake
    • In our example, we want to create the target tables in the data lake rawvault
• Each database_directory placeholder should contain the path to create the Target Parquet files.
  • If you are using our Azure Synapse environment example, the path is the one inside the Storage Account chosen to store the Target Data Lake
    abfss://claire-datalake@bgsynapsedatalake1.dfs.core.windows.net/rawvault/ for the Raw Vault layer placeholder
    • claire-datalake is the name of the folder we created inside the Storage Account
    • bgsynapsedatalake1 is the name of the Storage Account itself

• • JDBC source: You should 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

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_