This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
external_data [2022/03/31 13:40] antreas |
external_data [2022/11/10 16:01] (current) yves |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| ==== Configuring data connections ==== | ==== Configuring data connections ==== | ||
| + | |||
| The first step in configuring your external data link to PMA.core is to create the connection to the data source. PMA.core supports connection to the following databases | The first step in configuring your external data link to PMA.core is to create the connection to the data source. PMA.core supports connection to the following databases | ||
| * SQL Server | * SQL Server | ||
| Line 37: | Line 38: | ||
| === Testing === | === Testing === | ||
| + | |||
| To test your query for errors and validating its results you can use the Test query field. You can either write a slide identifier manually in the text box or use the //Set from treeview// button after selecting a slide from the treeview on the right hand side of the screen. | To test your query for errors and validating its results you can use the Test query field. You can either write a slide identifier manually in the text box or use the //Set from treeview// button after selecting a slide from the treeview on the right hand side of the screen. | ||
| {{ :test_query.jpg?400 |}} | {{ :test_query.jpg?400 |}} | ||
| Line 46: | Line 48: | ||
| After creating the queries you can now use the [[https://docs.pathomation.com/pma.core.api/#/Api/PMA.Services.Api.HistoScope.GetFormData|FormData]] API to request data by using the Query Id as the Form Id, the same way you request native PMA.core Form Data. | After creating the queries you can now use the [[https://docs.pathomation.com/pma.core.api/#/Api/PMA.Services.Api.HistoScope.GetFormData|FormData]] API to request data by using the Query Id as the Form Id, the same way you request native PMA.core Form Data. | ||
| - | This is the same API that is used to provide external data in downstream application like PMA.studio, PMA.slidebox, PMA.control etc. | + | This is the same API that is used to provide external data in downstream application like [[https://www.pathomation.com/pma.studio|PMA.studio]], [[https://www.pathomation.com/pma.slidebox|PMA.slidebox]], [[https://www.pathomation.com/pma.control|PMA.control]] etc. |
| + | {{ ::pmastudio_external_data.jpg?600 |}} | ||
| ==== More background ==== | ==== More background ==== | ||