Configuring BRIO Connections for the Data Warehouse

Follow the steps below to create a BRIO .oce file (Open Catalog extension) connection for your machine:

Step 1: Welcome to BrioQuery

  

• Select A New Database Connection File
• Click OK

 

Step 2: Database Connection Wizard: Type of Connection 

 

• Select ODBC for connection software
• Select ODBC for type of database
• Click "Show Meta Connection Wizard"
• Leave remaining boxes blank
• Click Next>

 

Step 3: Database Connection Wizard: Connect to the data source, enter user name…. 

 

• Enter User Name as assigned
• Enter Password as assigned
• Select Data Warehouse as the Host
• Click Next>

 

Step 4: Meta Connection Wizard

• Select On the Current connection
• Click Next>

Step 5: Meta Connection Wizard

• Click Edit...

Step 6: Meta Data Definition: create the custom view for the desired application. The custom views give users the opportunity to filter out tables not relevent to needs. Underlying systems tables, for instance, are eliminated from table listings when the following steps are completed. Users may wish to set up separate .oce files for separate systems, i.e. one for Financial, and one for Personnel. The proper syntax for defining various views are listed below. The syntax must be copied identically (including all the quotes and asterisks).

This screen shot reflects the "Where" statement for users who want to view Financial tables only.

• Owner Name: leave blank
• *Physical Table Name: table_name
• Table Alias: '*'
• Table Type: table_type
• From: SYS.SYSTABLE

To view Financial tables only:

• Where: table_type = 'VIEW' and table_name LIKE 'Fin_%'
• Click OK

To view Personnel tables only:

• Where: table_type = 'VIEW' and table_name LIKE 'Per_%'
• Click OK

To view all Financial and Personnel tables:

• Where: table_type = 'VIEW' and (table_name LIKE 'Fin_%' OR table_name LIKE 'Per_%')
• Click OK

To view all Financial and only Campus Personnel Snapshot tables:

• Where: table_type = 'VIEW' and (table_name LIKE 'Fin_%' OR table_name LIKE 'Per_Snap%')
• Click OK

Step 7: back to the Meta Connection Wizard screen (from Step 5).

• Click Next>

Step 8: Database Connection Wizard: Press Finish… 

 

• Click Finish

 

Step 9: Do you want to save your OCE? 

 

• Click Yes

 

Step 10: Save Open Catalog 

 

• Enter dwh as File Name
• Click Save

 

Upon completion of Step 10, BrioQuery will launch and you will be connected to the Data Warehouse.