Attention all users! The ICAM team has migrated all accounts to Entra ID. All accounts require the VA network for access. More information on this migration can be found at this link: Entra ID Migration
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:
- Enter the appropriate database name if required.
- Follow the same login and data importing steps as outlined in Section 5.1 of the CX Insights guide.
Related articles
Content by label
There is no content with the specified labels