How to retrieve the ConfigData.SQLServerClient.ProductID for Microsoft SQL Server client ODBC drivers - Esri/arcgis-powershell-dsc GitHub Wiki

This workflow outlines the steps to retrieve the Product Id for ODBC SQL Drivers that can be used for the ConfigData.SQLServerClient.ProductID attribute.

1. Download Microsoft Windows SDK.
2. Install Orca. Orca is a Microsoft's tool, and is included with Windows SDK. Try searching for Orca-x86_en-us.msi - under Program Files (x86) and install the MSI.
   • Example path: C:\Program Files (x86)\Windows Kits\10\bin\10.0.22000.0\x86\Orca-x86_en-us.msi.
   • May need to change version numbers as required towards the end of the path.
3. Right click on msi installer of ODBC driver and click “Edit with Orca”.
4. Go to the Property table and find the value of ProductCode. Enter this value into the ConfigData.SQLServerClient.ProductID attribute within your configuration json file.

"SQLServerClient": [
  {
    "Name": "Microsoft ODBC Driver 17 for SQL Server",
    "InstallerPath": "C:\\Setups\\msodbcsql_17.8.1_x64.msi",
    "ProductId": "7453C0F5-03D5-4412-BB8F-360574BE29AF",
    "Arguments": " /quiet /qn IACCEPTMSODBCSQLLICENSETERMS=YES ADDLOCAL=ALL"
  }
],