Start a new topic
Answered

Integration with analytics tools

Does xDM integrate with analytics tools?


Best Answer

The main integration point with analytic tools is that these tools can directly query the xDM tables. 

The tables most commonly queried are the GD_ tables. But it can also be useful to query MD_ and other tables. As long as the analytic or reporting tool can connect to Oracle, PostgreSQL, or SQL Server (whichever database technology you are using for xDM) you can easily query the data.

You can generate model documentation to get a complete list of the tables in your data location including documentation about the system fields.


Export Model Documentation to HTML
Export Model Documentation to HTML


There is often indirect integration with analytic tools when your master data in Semarchy xDM is loaded into an enterprise data warehouse. But there is no requirement to move the data; you're free to query the xDM data hub directly.


1 Comment

Answer

The main integration point with analytic tools is that these tools can directly query the xDM tables. 

The tables most commonly queried are the GD_ tables. But it can also be useful to query MD_ and other tables. As long as the analytic or reporting tool can connect to Oracle, PostgreSQL, or SQL Server (whichever database technology you are using for xDM) you can easily query the data.

You can generate model documentation to get a complete list of the tables in your data location including documentation about the system fields.


Export Model Documentation to HTML
Export Model Documentation to HTML


There is often indirect integration with analytic tools when your master data in Semarchy xDM is loaded into an enterprise data warehouse. But there is no requirement to move the data; you're free to query the xDM data hub directly.


Login to post a comment