Explain the SQL Queries activated to data base from Data provider in BO ?

Interview Candidate
Sep 3rd, 2005
1
1988

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Ravi

Dec 8th, 2005

BO automatically generates the SQL query when objects are selected into query panel. When you run the query, the query is processed to database based on your connectivity.
for ex: If you run query using, Local Machine Full Client (BO reporter), the query directly connects to database through midilleware
Full Client <---> Database
If you run query using Webi, the webi browser will connects to Web Server and Webserver will proces request to Database.
WEBI <--->Web Server <---> Database