Eclipse Reports saves report files for you in open database connectivity (ODBC) files. Each report is saved to a separate file. You can use any tool, such as Microsoft Access or Excel, to handle ODBC files. Use the ODBC files to compare information you have gathered on different reports or merge two of your reports.
Note: You must request access to the ODBC files through Eclipse Support. For best results, have Eclipse Support walk you through the setup procedures.
Before handling ODBC files, you need to make sure you have the following items:
The UniVerse ODBC driver on your system. This file is included in your normal Eclipse system setup. This driver needs to be installed on each computer handling ODBC files.
The ID for the reports you want to manipulate as assigned by Eclipse Reports.
The Eclipse account from which you want to pull ODBC files.
A third-party tool of your choice to view ODBC files, such as Microsoft Access or Excel.
Set the
Use the following two-step process to setup your UniVerse Driver:
Find the UVODBC folder on your server and locate the Universe 10.1b Client.
Run the setup.exe program and follow the instructions.
On your computer, from the Start > Programs > IBM U2 > UCI Editor > UniVerse ODBC Driver menu, select UCI editor.
Right-click on the ODBC data sources node and select Add.
Enter the source name <account-odbc>, such as main-odbc.
Select UNIVERSE and enter the host name (server name), such as EclipseMain, and click OK.
On the Data Source Editing window, click Add.
On the Parameter Adding window, complete the Parameter and Value fields (such as Parameter: ACCOUNT, Value: /relcut/main) and click Set.
Save and exit the window.
On your computer, from the Start > Programs > IBM U2 > UCI Editor > UniVerse ODBC Driver menu, select ODBC Data Source Administrator.
Select dBASE Files and click Add to display the Create New Data Source screen.
Select IBM UniVerse ODBC Driver and click Finish to display the UniVerse ODBC Data Source Setup.
In the Server field of the Server area, use the drop down arrow and select your server.
Important: Use the drop down arrow to select the server, do not type it in.
Click Test Connection to make sure the setup is correct, click OK, and exit the window.
To import ODBC files into your third party tool, you need the assigned ID for the reports.
To locate the report ID:
Click Home from the main task bar and click the Reports tab to display all available reports for your user ID.
Do one of the following:
Hold the cursor or hover over the report name. The ID displays in a pop-up tool tip.
Click the report name and then click the Report Detail tab. The ID displays in the Report File field, such as ODBC$.515.
The following is an example of setting up a tool to use Eclipse ODBC files.
Launch Microsoft Access.
From the Data menu, select Import External Data.
Select New Database Query to display the window.
Select the account from which you want to view ODBC files.
Expand the file folder displayed to view the current report files.
Select the files you want to import into the Access database.