In Nathean Analyticss, a Data Mart is a SQL Server database that holds a copy of the results of a Dataset in a database table. Some typical uses for a Data Mart would include storing the content of an imported Spreadsheet, storing a snapshot of a slow-running database or API query in a table where it can be queried with Parameters, storing data from disparate systems that requires complex logic to be applied in a SQL query before it is returned to users etc.

Datamarts are usually defined on the same SQL Server database server as the Nathean Analytics system database. To identify a Data Connector as being a Data Mart, and make it available in the associated drop-down list in Dataset caching properties, tick the Data Mart checkbox in the properties of a Data Connector:

Revision: 2
Last modified: Jun 22, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment