User Tools

Site Tools


external_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
external_data [2022/03/25 19:00]
yves created
external_data [2022/03/31 12:01]
antreas
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
 +  * SQL Server
 +  * Oracle
 +{{ :​external_connection_add.png?​600 |}}
 +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
 +  * Name: A name for the new connection to distinguish this connection from others
 +  * Connection String: The connection string to the database system including the credentials PMA.core will use to connect
 +
 +{{ ::​externa_connection_add_page.jpg?​600 |}}
  
 ==== Configure queries ==== ==== Configure queries ====
Line 11: Line 20:
 === SQL query === === SQL query ===
  
-** include at least one screenshot here **+include at least one screenshot here
  
 === Testing === === Testing ===
  
-** include at least one screenshot here **+include at least one screenshot here
  
 ==== Consumption and applications ==== ==== Consumption and applications ====
  
-** Some screenshots from the SQLServer side on one hand, and the downstream presentation in PMA.studio perhaps? ​**+Some screenshots from the SQLServer side on one hand, and the downstream presentation in PMA.studio perhaps?
  
 ==== More background ==== ==== More background ====
external_data.txt ยท Last modified: 2022/11/10 16:01 by yves