Browse xDM Discovery profiles

xDM Discovery includes built-in customizable dashboards to browse the profiling data. You can also use your own BI tool to build your own dashboards on top of the profiles.

xDM Discovery built-in dashboards

xDM Discovery includes the Datasource Profile and Table Profile built-in dashboards to visualize the profiling data.

Datasource profile

The Datasource Profile dashboard shows the profiling information at the datasource level. It is available by clicking:

  • a datasource in the navigation drawer’s Shortcuts,

  • a datasource in the Datasources list,

  • the view profile View profile button in the datasource editor.

This dashboard contains the following tabs:

  • Profile shows the profiled tables status with their record count.

  • Table shows the columns of a given table, including lowest, highest, most frequent values, etc. Use the charts on this dashboard to infer the correct sizing for a column, the value range and mandatory nature of the columns within a table.

  • Columns shows the detailed column metrics for a given table, including lowest, highest, most frequent values and other value metrics. It also exposes value and pattern distribution for the column. Use this dashboard to decide whether a column should be constrained to a list of values, to infer the nature (Phone Number, SSID, etc.), as well as the rules and format to apply to the column.

Table profile

The Table Profile dashboard shows the metrics from the Table and Column tabs, focusing on a single table of the datasource. It appears when clicking the View profile link for a table from the dashboard editor.

Built-in dashboards have an edit Edit datasource button in the upper left corner to return to the datasource editor.

Customize the profiling dashboards

xDM Discovery lets you seed an application in xDM Dashboard that contains the built-in dashboards. You can customize this application in the Dashboard Builder and create visualizations specifically for your use case.

To seed a profiling application:

  1. Select Datasources in the navigation drawer.
    The Datasources list opens.

  2. From the list, select the datasources that you want to include in your dashboard application.

  3. In the more menu More menu, select seed profiling app Seed profiling app.

  4. Provide a Title and a Name for this application.

  5. Click Create
    The application is generated and opens in Dashboard Builder.

The generated application contains multiple charts and dashboard, some of which are not used in the application. You can use and customize every component of this application.

Customizing the generated application does not alter the built-in dashboards. Re-generating the application in the Dashboard Builder recreates it from the built-in dashboards.

Use your BI tools

You can use your own BI Tool to connect and perform analysis on xDM Discovery profiles:

  • The Semarchy xDM repository, which stores the profile data, is hosted in a relational database accessible via JDBC, ODBC and other connectivity methods.

  • xDM Discovery tables reference contains a reference to help you build dashboards based on the tables storing the profile data.

  • The built-in dashboards may be used as starting points and examples to build your own visualizations.

Make sure to access these schemas from your BI tools with credentials having SELECT privileges only. Do not attempt to insert or update data in these schemas. .