Extracting Information from a Database

Create a SELECT statement in the SQL Statement Builder to extract information from a database. Use these statements in the configuration environment of Proficy Portal to generate data for charts, grids, and trees. You can also use SQL statements to drive the animations of graphical objects. See the following sections for more information:

SELECT statements can also make use of database results caching to reduce the load on your database server. For more information, refer to the Database Results Caching section.