Certain datasets within CX Insights are only available through the Serverless Pool, which differs from the CX Insights Dedicated SQL Pool (commonly referred to as the “Conditioned Data Layer”). While the credentialing process for both pools is the same, the connection location differs. Below are the steps to access CX Insights Serverless Pool using Azure Synapse Analytics, SQL Server Management Studio, or Power BI.

Datasets Available via Serverless Pool (as of July 2024)

  • VADIR MPD (Military Personnel Domain)
  • AHOBPR Eligibility File
  • CommCare Raw
  • VAHC Salesforce Raw
  • UDO Raw

Accessing Serverless Pool via Azure Synapse Analytics

  • Follow the steps for Azure Synapse Analytics:
    • Refer to the steps in Section 3.1 of the CX Insights guide.
    • Use the following URL instead:
      • CX Insights PROD Azure Synapse Workspace:

Accessing Serverless Pool via SQL Server Management Studio

  • Follow the steps for SQL Server Management Studio:
    • Refer to the steps in Section 4.1 of the CX Insights guide.
    • Use the following server name instead: 
      vac20vdwaswroprod-ondemand.sql.azuresynapse.usgovcloudapi.net

Accessing Serverless Pool via Power BI


  • Follow the steps for Power BI:
    • Open Microsoft Power BI.
    • Click “Get Data”.
    • Select “Azure” and then “Azure Synapse Analytics (SQL DW)”.
    • Click on "Connect".
    • Enter the following server name:



There is no content with the specified labels