- User states (glossary)
Oftentimes you have external data in a separate repository and want access to it through the Pathomation software platform for digital pathology and virtual microscopy. Importing the data as Pathomation form data may not always make sense for a variety of reasons.
If your data falls into this category; fear not! PMA.core allows you to link to it in real-time.
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
To add an external connection you simply click on the Add button in ExternalData page of the administrator front-end UI and then select the type of connection you want. On the next page you will be prompted to add
After creating the external database connection we need to create a link between the data and the slides in PMA.core. To accomplish this we need to define an SQL query that will instruct PMA.core how each slide is linked to one or more rows of data in the external connection. To start that we need to click ton Add button in the external data source page
Even though the Add Query page seems complicated it is nothing more than an intuitive UI to create an SQL query so that PMA.core can link the the external data to the slides provided. The page is divided in two parts, on the right hand side there is a treeview with PMA.core slides that is only used for testing the query and on the left hand side UI to create the query. The parts that are needed to successfully create the query are:
As stated an above the #SLIDE_IDENTIFIER# part of the query is dependent on the mode selected and the regular expression if provided. So this can be the file name or the barcode text of a slide, after it is transformed by the regular expression.
Before your query is ready you need to test that it works as expected
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.
Clicking on the Execute button will execute the query on the server. Any errors in syntax will be reported immediately bellow the execute button. If no errors occur a popup will appear that will show the results of the query.
After creating the queries you can now use the FormData API to request data by using the Query Id as the Form Id, the same way you request native PMA.core Form Data.
See our blog article.