Using Brio with Minisoft's ODBC Driver

This document will provide the first steps to producing an ad-hoc report from data on your HP e3000. This sample was created using BriQuery version 5.0.3 from Brio Technology. 

Using Brio

1. Start a new Brio Session.
   From the DataModel menu, select Connections, Create.
   
   

 

2. Select ODBC from the Connection Software list.  Select ODBC from the Database Software list. Press OK.
   
   Note: If you enable the "Use ODBC Logon Dialogs" option, you will be prompted for filling in all required data manually.
   
   

 

3. From the Data Source list, select your Data Source Name.  Press OK.
   
   
   
   If a user password is required, use this syntax:
   
   User ID:
   [sessionname,]username.account[,group]
   
   Password:
   User-pw/account-pw/group-pw
   
   Note that leading slash characters are required. For example, if there is only an account password, the syntax must be:

   /account-pw

    

4. Use the default values for the Open Catalog Definition in this sample.
   Press OK.
   
   

 

5. Press OK.
   
   

 

6. View the available table list by selecting Table Catalog from the DataModel menu.
   
   

 

7. Double click on the table you wish to use.
   
   

 

8. Drag the data items from the selected table to the Request area. When complete, press the Process button.
   
   

 

9. Your Brio report should now be ready.