Direct Data Access

Direct Data Access allows you to securely connect to your tenant'sClosed High-level organizational grouping used to manage technical support, billing, and global settings for your CXone environment database in Microsoft Excel create customized reports and analytics. Direct Data Access is supported for all versions of Microsoft Excel 2013 or later which include Office 365. Most metrics in the Data Dictionary are available for Direct Data Access.

Direct Data Access is intended to be used by data analysts, or people in similar roles. They should have advanced knowledge of and access to Microsoft Excel features, including but not limited to:

  • PivotTables and related functionality.
  • Data Analysis Expressions (DAX) language.
  • PivotCharts.
  • PowerView Reports.

You cannot limit the visibility of the data generated in these reports through a user's security profile.

Support of this product is limited to initial setup and connection to the data model and data related questions. No level of support or training pertaining to Microsoft Excel features and functionality will be provided by NICE CXone. For questions related to Microsoft Excel, please refer to Microsoft's external training and documentation resources.

Set Up Direct Data Access

Required permissions: Direct Data Access

  1. Create a blank workbook in Excel.

  2. Open the Data Connection Wizard using:

  3. Enter the following for Server name based on the tenant you are in. If the tenant you are using isn't listed below, you can find a list of all domain names by cluster here.

    • A32:

    • B2–C20:
    • E1–E31:
    • AWS C30 or C31:
    • AWS C29 & C32 or higher:
    • C71–C74:
    • M32 & M33:
    • L32–L36:
    • J32:
  4. Click OK.

  5. Enter your CXone User Name and Password. Under Log on credentials, make sure Use the following User Name and Password is selected. Do not select Use Windows Authentication.
  6. Click Next.

    When you set up the location and user credentials, you might see an error that says Parser: The syntax for 'GET' is incorrect. Typically this error occurs when you've entered your server name or credentials incorrectly. Also, make sure that your server name is using an HTTPS address instead of HTTP.

  7. From the Select Database and Table drop-down, pick the database you want to use. You can choose from Insight, ACD Detail, Intraday ACD Detail, and Personal Connection.
  8. Click Finish.

  9. When the Import Data window appears, click OK.