Open Federated Query Builder
- Click Data Management then Federated Query.
The treeview gives access to all the datasources you’re granted through direct privileges and roles.
Expand each node to view the database structure.
Hover your mouse pointer over each node to get a connection message (e.g., Last successful connection, Timed Out, etc.)
|Datasource_Name||Datasource is connected.|
|Datasource_Name||Datasource is disconnected.|
|Mouseover and click to paste the node to the editor.|
|Fetch…||Choose up to 10,000 rows to fetch with your query. The default is 1000.|
|Select a specific line or execute the entire your query.|
|Query tab||View query results|
|Script Output||View runtime messages and errors.|
|Download the query results as a .csv file.|