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.
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
Cédric BLANC
said
over 2 years ago
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.
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.
Cédric BLANC
Does xDM integrate with analytics tools?
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.
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.
Cédric BLANC
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.
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.
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 71 topics