A data source is a connection from Matik to your data. Data sources connect to Inputs and Dynamic Content. A data source can be a spreadsheet, data warehouse, CRM, or API connection, a BI Tool, or many others. See the Data Sources section of our help center for details on specific data sources. Additionally, see this article if you wish to access your data sources through an SSH Tunnel.
Having reliable data sources with strong data governance will improve the End User and Admin experiences. Below are the best practices for the types of data sources you might encounter:
- Data Warehouse and Databases: We recommend creating a Matik user profile instead of connecting to an existing user to prevent having to re-enter credentials if user changes occur and to limit table ACLs to Matik specific content. Depening on your security requirements, we suggest you create a user profile specifically for Matik that only gives read-only access to the tables needed to create the dynamic content. You also have the ability to force the end user to log into the data source with their credentials before being able to generate a presentation by clicking on the Require end user to log in to access this data source. They will only be able to generate the presentation if they have access to that data with their credentials.
- Google Sheets: ensure READ access of the spreadsheet is granted to Admins.
Check out the video below to learn more: